IBM DB2 Database SQL Fundamentals

This course provides students with the technical skills required to write SQL queries for IBM DB2 9.7 to 11.5. This course is the foundation for all DB2-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

On successful Completion of this course you will be able to:

• Describe the basic architecture and concepts of IBM DB2
• Understand the similarities and differences between SQL and other computer languages
• Write SELECT queries
• Query multiple tables
• Sort and filter data
• Describe the use of data types in DB2
• Modify data using SQL
• Use built-in functions
• Group and aggregate data
• Use subqueries
• Use table expressions
• Use set operators
• Use window ranking, offset and aggregate functions
• Implement pivoting and grouping sets
• Execute stored procedures
• Program with SQL
• Implement error handling
• Implement transactions