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

Thankfully we have 691 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
Booking this class for a group? Find great private group events here

691 Top Choices

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...

Monday Oct 21st, 10am - 5pm

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 formats...

Monday Oct 21st, 10am - 6pm

  (3 sessions)
$1,295

3 sessions

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...

Monday Oct 21st, 10am - 5pm

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 Oct 23rd, 9am - 5pm

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...

Tuesday Oct 22nd, 9am - 5pm

Introduction to Adobe InDesign
Deal

Introduction to Adobe InDesign

at Spectrum Creative Consulting - Greenpoint 198 Greenpoint Ave., Brooklyn, New York 11222

This hands-on introductory course details the most essential Adobe InDesign features for beginner level users. Students will create multi-page documents while learning a variety of text and image layout techniques. Topics Covered: Creating & Customizing Documents Page Setup & Layout Working With Master Pages Working With Typography ...

Sunday Oct 27th, 11am - 5pm

Now:
$570
Was:
$600

Python Programming 101

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

Ever wondered how to get started with Python programming? Look no further than Python Programming 101 – a live Python tutorial in NYC with expert instructors from Practical Programming.  This is a “Python for absolute beginners” workshop – the best Python class that caters to complete beginners who have never coded before.  Python...

Monday Oct 28th, 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...

Tuesday Oct 29th, 9am - 5pm

  (2 sessions)
$595

2 sessions

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 Nov 2nd, 10am - 3pm

  (4 sessions)
$1,250

4 sessions

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...

Saturday Oct 19th, 10am - 5pm

Introduction to Adobe Illustrator
Deal

Introduction to Adobe Illustrator

at Spectrum Creative Consulting - Greenpoint 198 Greenpoint Ave., Brooklyn, New York 11222

This hands-on introductory course details the most essential Adobe Illustrator features for beginner level users. Students will learn how to create and manipulate vector shapes with a variety of tools. The course also covers text, color, effects, and layers. Topics Covered: Understanding Vector Graphics Creating & Transforming Paths...

Monday Oct 28th, 11am - 5pm

Now:
$570
Was:
$600
Introduction to Adobe After Effects
Deal

Introduction to Adobe After Effects

at Spectrum Creative Consulting - Greenpoint 198 Greenpoint Ave., Brooklyn, New York 11222

This hands-on introductory level course covers the fundamentals of Adobe After Effects. The class will introduce students to the key concepts, terminology, and interface of After Effects. Topics include compositions, layers, animation, keyframing, effects, 3D, and rendering. Topics Covered: Best Practices File Management Project Organization...

Tuesday Oct 29th, 11am - 5pm

Now:
$570
Was:
$600

Python Immersive

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

Python Immersive is the best and most comprehensive way to learn the fundamentals of Python for complete beginners - whether you are breaking into a new career, trying to gain new skills to boost your career, or automate tedious tasks with Python. There is only one course that can get you can get started coding in a week – Python Immersive. ...

Monday Oct 21st, 10am - 5pm

  (5 sessions)
$999

5 sessions

After Effects in a Day

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

Adobe After Effects is the tool of choice for many professionals in both animation and video post-production. Because it is an Adobe product it is similar to Photoshop in interface, with a whole lot more thrown in. This class is designed to get you up and running with the program in the shortest amount of time possible. It's a chance to see what After...

Saturday Oct 26th, 10am - 5pm

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...

Wednesday Nov 6th, 10am - 5pm

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 how to write...

Wednesday Nov 6th, 6pm - 9pm

  (3 sessions)
$399

3 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...

Saturday Nov 9th, 10am - 4:30pm

$489.94

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...

Sunday Nov 10th, 10am - 6pm

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...

Sunday Oct 20th, 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...

Thursday Oct 24th, 10am - 5pm

Loading...