Loading...

IBM Information Management Courses

* Courses listed below can also be customized based on user demandDon't see a course that you are looking for?
Click Here to Request It.

CL285G – Quick Basics of DB2 Administration for Windows

This course teaches basic database administrative tasks using DB2 10.5 for Linux, UNIX, and Windows. These tasks include creating database objects like table, indexes and views and loading data into the database with DB2 utilities like LOAD and INGEST. Various diagnostic methods will be presented, including using various db2pd command options and monitoring using SQL statements with DB2 monitor functions. Students will learn how to implement automatic archival for database logs and how to recover a database to a specific point in time using the archived logs. Locking performed by DB2 and the effect the application isolation level has on locking and lock wait conditions are covered. This course provides a quick start to DB2 database administration skills for experienced relational Database Administrators (DBA).

The lab exercises are performed using DB2 LUW 10.5 for Windows. For some exercise tasks students will have the option to complete the task using a DB2 command line processor or using the graphical interface provided by IBM Data Server Manager.

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Enroll Now

CL2X3G – DB2 10 for LUW: Basic Administration for Linux and Windows

This course teaches students to perform basic database administrative tasks using DB2 10.1 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using the DB2 Explain tools. Various diagnostic methods will be presented including using the db2diag.log file messages to direct your investigation of problems as well as using the db2pd commands.

  • In-class
  • Instructor Led Online
Enroll Now

CL450G – Implementation and Use of DB2 BLU Acceleration

This course covers the implementation of DB2 BLU Acceleration and column-organized table support, for a new or existing DB2 database. Students will learn to describe how the column dictionaries used for DB2 BLU Acceleration are built and utilized to provide extreme compression for column-organized tables. Students will get practical experience in the planning and utilization of the DB2 BLU Acceleration functions, using DB2 LUW commands, utilities and SQL statements, and by performing a lab exercise using DB2 Advanced Enterprise Edition 10.5 installed on a Linux platform.

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Enroll Now

CL451G – DB2 11 BLU Acceleration Implementation and Use

This course is intended for Data Administrators preparing to use DB2 BLU Acceleration facilities of DB2 11.1 for Linux, UNIX and Windows systems.

The course covers concepts and facilities of the BLU Acceleration feature of DB2 11,  including loading data into column-organized tables,  and monitoring the processing of SQL statements that access the tables.

The DB2 10.5 Fix Pack 4, referred to as Cancun, added support for Shadow tables, a new type of Materialized Query Table, and also Column-organized User Maintained MQT tables.  With DB2 11.1, BLU Acceleration can be used in a clustered multiple database partition DB2 environment.

This course includes a lecture and demonstration that allows students to create a set of column-organized tables from an existing set of row-organized tables and execute and analyze the performance of BLU Acceleration in a MPP database.

The lab demonstrations are performed using DB2 LUW 11.1 for Linux.

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Enroll Now

CL485G – DB2 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs

This course teaches basic and advanced, database administrative tasks using DB2 10.5 for Linux, UNIX, and Windows. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed.

  • In-class
  • Instructor Led Online
Enroll Now

CL487G – Db2 11.1 Quickstart for Experienced Relational DBAs

In this course students will learn how to perform, basic and advanced, database administrative tasks using Db2 11.1. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the Db2 Optimizer will be examined using the Db2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. This course also covers using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA).

The lab demonstrations are performed using DB2 LUW 11.1 for Linux. For some lab tasks, students will have the option to complete the task using a DB2 command line processor, or using the graphical interface provided by IBM Data Server Manager.

  • In-class
  • Instructor Led Online
Enroll Now

CV832G – DB2 11 for z/OS Database Administration Workshop Part 1

This course provides students with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.

Note: This course material is at the DB2 11 for z/OS level.

  • In-class
Enroll Now

CV843G – DB2 11 for zOS Database Administration Workshop Part 2

This course teaches database administrators various features they must be familiar with as DB2 11 for z/OS Database Administrators. These include program preparation, online schema changes, user defined functions, archive-enabled and temporal tables, partition management, stored procedures, and triggers. The course includes many hands-on demonstrations which give the students experience with the included topics.  Additionally, there is information on other features in the course appendices, including schemas and user defined data types, clone tables, materialized query tables, large objects, global variables, and row permissions and column masks.  This course is a follow-on course to CV832 – IBM DB2 11 for z/OS Database Administration Workshop Part 1.

  • In-class
Enroll Now

DW540G – IBM Netezza Analytics for Data Scientists – Using R and NZSQL

IBM Netezza Analytics provides a game-changing experience for Data Scientists by allowing data miners and quantitative analysts to leverage all the data while still achieving high performance throughout the entire modeling cycle – from data prep through exploratory data analysis through to model scoring and deployment. By leveraging the massively parallel processing architecture of an IBM Netezza Appliance, analytics can be performed in-database so that there is no superfluous data movement. This harnesses the full power of IBM Netezza Appliance and allows data miners and quantitative analysts to greatly reduce the time to build and deploy/score a model in a single environment while leveraging increasing massive data sets and shrinking the time from model concept to deployment.

This course will focus on how to effectively leverage the IBM Netezza Analytics platform to build, test and score analytic models in-database. Students will learn how to leverage:

  • In-Database Analytics fully scalable and parallelized in-database analytics package
  • Enterprise R, the statistical language, that runs on Netezza
  • Matrix Engine, a parallelized, linear algebra package
  • In-class
  • Instructor Led Online
Enroll Now

DW634G – IBM Big SQL for Developers (v5.0)

This course is designed to introduce the student to the capabilities of IBM Big SQL. IBM Big SQL allows you to access your HDFS data by providing a logical view to it. You can use the same SQL that was developed for your data warehouse data on your HDFS data.

This course provides context on why students would use Big SQL followed by how to use Big SQL to access your data. It also covers what Big SQL is, how it is used, and the Big SQL architecture. The course also covers how to connect to Big SQL, create tables with a variety of data types, load data in, and run queries against the data. The course also shows how to use Big SQL with other components of the Hadoop ecosystem.

  • In-class
  • Instructor Led Online
  • Self-Paced Virtual Classroom
Enroll Now