IBM Db2 12: SQL Workshop

Unit 1: SQL Introduction

Unit 2: Simple SQL Queries

Unit 3: Retrieving Data from Multiple Tables

Unit 4: Scalar Functions and Arithmetic

Unit 5: Column Functions and Grouping

Unit 6: Advanced Functions

Unit 7: Performance Optimization

Unit 8: UNION

Unit 9: Using Subqueries

Unit 10: Maintaining Data

This course is intended for individuals seeking to write, support, or understand SQL queries. This includes (but is not limited to) end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language (DML).

• Participants should have the following skills:
  • Familiarity with the Windows Operating System
  • Basic computer literacy

After completing this course, learners should be able to:

• Explain the role and use of SQL dialects (DDL, DML, and DCL) in managing and interaction with Db2 databases
• Summarize the new and deprecated features of Db2 v12, such as enhanced query optimization
• Retrieve rows based on comparisons to numeric or alphanumeric column values
• Implement correlation names in queries to simplify table references
• Implement rounding and truncation functions, including ROUND and DECIMAL
• Utilize the GROUP BY clause to categorize data into meaningful subsets and the HAVING clause to filter grouped results based on aggregate conditions
• Apply date and time functions to extract, manipulate, and compare date, time, and timestamp values in SQL queries
• Identify the impact of special registers, advanced window functions, and AI-driven query optimization on database performance and workload management
• Differentiate between UNION and UNION ALL and explain how each affects query performance and result set behavior
• Explain the role of subqueries in SQL and how they differ from standard joins in retrieving data
• Explain the role of transaction management using COMMIT, ROLLBACK, and SAVEPOINT to control database changes