Course Duration: 1 month (25 hours of theory and 25 hours of practicals)

Course Content:

Unit #1: Database Planning

  1. Understanding the Db2 products
  2. Understanding Db2 offering in Cloud
  3. Understanding Db2 BLU and pureScale
  4. Understanding Netezza and Oracle compatibility features

Unit #2: Database Security

  1. Understanding Authentication
  2. Understanding Authorizations and Privileges
  3. Working with Row and Column Access Control (RCAC)
  4. Implementing Label Based Access Control (LBAC)
  5. Understanding Trusted Context and Native Encryption
  6. Hands On Lab – 5 exercises

Unit #3: Working With Database Objects

  1. Understanding Db2 Server, Instance and Databases
  2. Understanding Db2 Objects
  3. Understanding Database Catalog, Connections Types
  4. Working with all the database objects
  5. Hand On Lab – 10 exercises

Unit #4: Writing SQL and XQuery Statements

  1. Basics of SQL
  2. Getting started with the SELECT statement
  3. Filtering and sorting data
  4. Combining Data Sets
  5. Analytical Functions – Grouping, Windowing
  6. Understanding Cursors and Temporary Tables
  7. Querying XML and JSON data
  8. Working with Stored Procedures and User Defined Functions
  9. Hands on Lab – 20 exercises

Unit #5: Working with DB2 tables, views and indexes

  1. Understanding Db2 data types
  2. Understanding Db2 Constraints
  3. Creating and working with tables
  4. Working with Db2 views and indexes
  5. Hands on Lab – 20 exercises

Unit #6: Isolation Levels and Data Concurrency

  1. Understanding data consistency
  2. Understanding isolation levels, Locks in Db2
  3. SQL best practices for Db2
  4. Hands on Lab – 10 exercises

Contact us for any Db2 consulting and training requirements.