Discover Classes. Earn Rewards.
DB2 9 Database Administration: Linux, UNIX & Windows is unfortunately unavailable

Thankfully we have 811 other Tech Classes for you to choose from. Check our top choices below or see all classes for more options.

DB2 9 Database Administration: Linux, UNIX & Windows

at Global Knowledge - Financial District

(58)
Course Details
Price:
$2,995
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Financial District, Manhattan
1 State Street Plaza 23rd Flr
Btwn Pearl and Water Streets
New York, New York 10004
(Map)
Share:
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 10

What you'll learn in this ibm db2 training:

This course is designed to teach you how to perform database administration tasks using DB2 9. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pure XML (native XML storage) will be introduced. Hands-on exercises provide an option of using either an AIX, Linux, or Windows operating system.

Course Materials

The course materials address DB2 9.7 for Linux, UNIX, and Windows.

Hands-On Labs

Ten labs are included to address DB2 9.7 for Linux, UNIX, and Windows.

Certification

Prepare for IBM Certification Test 731: DB2 9 for Linux, UNIX, and Windows Database Administration

What You'll Learn
  • Administer a DB2 database system using commands and GUI tools
  • Manage System Managed Storage (SMS) and Database Managed Storage (DMS) databases and apply data placement principles 
  • Implement a given logical database design using DB2 to support integrity and concurrency requirements 
  • List and describe the components of DB2 
  • Define a DB2 recovery strategy and perform the tasks necessary to support the strategy 
  • Use autonomic features of DB2 
  • Implement DB2 security 
Who Needs to Attend

This intermediate course is for System administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.

This course is appropriate for students using DB2 in a z/Linux environment.

Prerequisites
  • Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor 
  • State the functions of the Structured Query Language (SQL), and be able to construct DDL, DML, and authorization statements 
  • Discuss basic relational database concepts and objects such as tables, indexes, views, and joins 
  • These skills can be developed by taking: 
  • Basic OS functions: 
  • Windows Operating System Training 
  • Linux Operating System Training 
  • AIX Operating System Training
    or have equivalent administration experience 
  • SQL and relational database basics 
  • DB2 SQL Workshop (CE12), (3E12)
    or have equivalent knowledge of SQL basics 
What's Next

Use the link to the Training Path in the course description for easy access to prerequisite courses, and other courses that might be of interest to you.

The next courses that may be of interest to you include:
  • DB2 9 for LUW Advanced Database Administration for Experts (CL46)
  • DB2 9 for Linux, UNIX, and Windows Performance 
  • Tuning and Monitoring Workshop (CL41) 
  • DB2 9 for LUW Advanced Database Recovery (CL49) 
  • DB2 SQL Workshop (CE121G) 
  • DB2 SQL Workshop for Experienced Users (CE131G) 
Follow-On Courses
  • DB2 9 for LUW Advanced Database Administration for Experts (CL462G)
  • DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop (CL412G) 
  • DB2 9 for LUW Advanced Database Recovery (CL492G)

Still have questions? Ask the community.

Refund Policy
Notice of cancellation must be submitted 16 business days prior to class.

Map

Google Map

Global Knowledge

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 29950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at Global Knowledge (12)

School: Global Knowledge

Global Knowledge

Global Knowledge is the world's leading learning services and professional development solutions provider. We deliver learning solutions to support customers as they adapt to key business transformations and technological advancements that drive the way that organizations around the world differentiate...

Read more about Global Knowledge

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

811 Top Choices

Python for Data Science

at Practical Programming - Chelsea 115 W 30th St 5th Fl Ste 501, New York, New York 10001

Our program serves as the foundation for many well-known concepts of data science. We teach practical techniques and algorithms for extracting and studying useful knowledge from data. This course is not a theory class as we believe there are many ways to learn statistics and analytics concepts on your own. We are providing students with a set of practical...

Saturday Jul 20th, 10am - 3pm

  (4 sessions)
$999

4 sessions

Illustrator I (Mac)

at Fashion Institute of Technology - Chelsea 227 W 27th St, New York, New York 10001

Adobe Illustrator is a must for any design professional. Learn to set up a document, create basic illustrations with lines and points, and edit your artwork. Program includes spacing, scaling, rotating graphics, and importing and auto-tracing objects. Creating text paths and aligning text to a circle are also covered.  Required Material: Bring...

Monday Jul 22nd, 6:20pm - 9:10pm

  (4 sessions)
$360

4 sessions

Beginner SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Beginner SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. Learn to use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database in our beginner SQL training class. Our SQL courses are taught in our state-of-the-art...

Monday Jul 22nd, 5:50pm - 9:20pm

  (2 sessions)
$325

2 sessions

Introduction to SQL and Data Analysis

at Practical Programming - Chelsea 115 W 30th St 5th Fl Ste 501, New York, New York 10001

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work.  We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples.  Also, this workshop will teach you advanced concepts of databases as well as...

Wednesday Jul 24th, 6pm - 9pm

  (3 sessions)
$399

3 sessions

Beginner Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Microsoft Excel Training Course Overview - Level 1 The Career Center, hands on, instructor-led, Beginner Excel training class in New York City will teach you to organize, calculate, analyze, revise, and present your data. Our basic Excel training course is classroom based instruction, with a live instructor, to introduce the basic look and feel...

Wednesday Jul 17th, 6pm - 9pm

  (2 sessions)
$209

2 sessions

Microsoft PowerPoint

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

This training will cover the basic to advance functions of Microsoft PowerPoint. You will learn how to create a presentation that is visually appealing to an audience, by adding graphical objects, color themes, charts, pictures, customize texts, and a variety of slide effects. This is a great course for anyone looking to learn PowerPoint for the...

Monday Jul 22nd, 10am - 6pm

Intermediate Microsoft Excel 2016

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Intermediate Microsoft Excel 2016 Class Overview The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal...

Tuesday Jul 23rd, 10am - 5pm

Python Programming 101

at Practical Programming - Chelsea 115 W 30th St 5th Fl Ste 501, New York, New York 10001

This class aims to help beginners, regardless of their backgrounds, to feel justifiably confident to start using Python programming language. During the course you will learn how to start writing small practical programs using Python. You will get familiar with Python’s fundamentals, How to work with the built-in data structures and iterate with...

Tuesday Jul 30th, 6pm - 9pm

Adobe Premiere Pro 101

at Manhattan Edit Workshop - Chelsea 119 W 23rd St Ste 700, New York, New York 10011

Craft your story efficiently with Adobe Premiere Pro software, the high-performance video production solution that enables you to work dramatically faster thanks to the native 64-bit, GPU-accelerated Adobe Mercury Playback Engine. Edit natively with the video formats you want.  Save time by batch encoding source content to a wide variety of video...

Friday Aug 2nd, 10am - 6pm

  (3 sessions)
$1,295

3 sessions

Intermediate SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Intermediate SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep,...

Wednesday Jul 24th, 5:50pm - 9:20pm

  (2 sessions)
$325

2 sessions

Basic Rhino Workshop

at e+i Studio - Lower East Side 2 E Broadway #906, New York, New York 10038

This course delivers a concise introduction to Rhino and an overview of fundamental skills for creating and editing geometry. Requirements: No prior knowledge required. The course is good for both Mac and PC. Course Topics Overall familiarity with the Rhino interface An introduction to Rhino geometry types Essential skills for creating and editing...

Sunday Aug 4th, 10am - 4:30pm

$489.94

Python Immersive

at Practical Programming - Chelsea 115 W 30th St 5th Fl Ste 501, New York, New York 10001

Our program is designed to be a base for a career in the tech industry. Learn from scratch to comfortably program in Python.  We teach the fundamentals of programming, and the best practices for real life opportunities. After finishing our program, you will have a solid foundation for a career in Data Science, Application development, and information...

Monday Jul 22nd, 10am - 5pm

  (5 sessions)
$999

5 sessions

Python in a Day

at Noble Desktop - SoHo 594 Broadway Ste 1202, New York, New York 10012

In this introductory class, you’ll learn Python, an increasingly popular and powerful programming language. Python is a great beginner language that is quick to learn and extremely versatile. It can be used to build software, analyze data, and build great-looking websites. In this one day hands-on course, you’ll begin by learning the...

Monday Aug 5th, 10am - 5pm

Excel for Business Fundamentals

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Excel for Business Fundamentals covers the essential applications of Excel used frequently by business professionals. In this introductory course, you will learn basic and multi-input functions, absolute references, charts and tables. We will help you produce polished and presentable work with formatting and printing techniques, while learning crucial...

Monday Jul 22nd, 10am - 5pm

Intermediate Excel for Business

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

Intermediate Excel for Business Intermediate Excel for Business covers the essential applications of Excel used frequently by business professionals. This course is perfect for those with familiarity with basic formulas and functions, charts, and workbook management techniques. In this intermediate-level course, you will learn Pivot Tables, database...

Tuesday Jul 23rd, 10am - 5pm

Photoshop in a Day

at Noble Desktop - SoHo 594 Broadway Ste 1202, New York, New York 10012

This class is designed to get you up and running quickly with the fundamentals of Photoshop: retouch photos, improve contrast and color, save files for print or web, and more! This 6-hour class is meant to get you started fast. It is designed for people who need to use Photoshop lightly and only have one day to spare. If you want to learn Photoshop...

Friday Aug 16th, 10am - 5pm

Intro to HTML & CSS

at Noble Desktop - SoHo 594 Broadway Ste 1202, New York, New York 10012

Learn the foundations of the Markup Language used to create webpages. In this class we’ll introduce you to HTML, the standard markup language used to create webpages. You’ll dive in and hand code a webpage from scratch, learning how to format paragraphs, headings, and lists. You’ll also learn how to create links, add images, and modify tags...

Monday Aug 26th, 6pm - 9pm

Excel Programming with VBA

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

The Excel Power Programming with VBA concentrates on how to automate repetitious Excel tasks and reports. By the end of this course, you will feel confident in writing macros to automate your Excel tasks, even if the data is not consistently formatted, creating custom Excel applications and environments, and creating custom Excel Add-ins to increase...

Saturday Jul 27th, 9:30am - 5:30pm

  (2 sessions)
$595

2 sessions

Web Scraping with Python

at Practical Programming - Chelsea 115 W 30th St 5th Fl Ste 501, New York, New York 10001

How to Scrape Amazon Product Details and Pricing using Python! We will teach you how to scrape AJAX with Selenium! Web Scraping is a method for extracting textual characters from websites so that they could be analyzed. Web scraping is sort of content mining, which means that you collect useful information from websites, including quotes, prices,...

Monday Aug 12th, 6pm - 9pm

Video Editing with Premiere Pro

at NYC Career Centers - SoHo 594 Broadway, 12th Floor, New York, New York 10012

Are you interested in learning how to make films, and not just home movies? Want to add a video editing suite to your skillset? Or are you a seasoned video editor, looking to switch software? Take your videos to a new level, by learning the basics of Adobe’s Premiere Pro, one of the industry standard video and film editing software packages used...

Monday Sep 9th, 10am - 5pm

Loading...