When does class start/end?
Class hours may vary, please reach out to contact@ascendientlearning.com if you have any questions.
Db2 11.5 for LUW: SQL Workshop for Experienced Users
This course teaches how to make use of advanced SQL techniques. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows...
Read More
$2,850 USD
Duration
2.5 days
Course Code
CL732G
Available Formats
Classroom, Virtual
Overview
This course teaches how to make use of advanced SQL techniques. This course utilizes IBM Data Studio on a Windows 11 operating system, but the SQL queries are appropriate for Linux, UNIX, and Windows environments.
Along with a review of some basic relational database concepts, this course covers some of the OLAP features of Db2, including GROUP and RANK functions. Learners will explore coding joins, using the CASE expressions, the CAST function, and code advance SQL constructs, such as recursive SQL and table expressions.
Learners will also participate in hands-on exercises to practice writing complex queries and subqueries.
Skills Gained
After completing this course, learners should be able to:
- Discuss basic relational database concepts
- Use some of the OLAP features of DB2, such as GROUP and RANK functions
- Code outer joins and join tables to themselves
- Use CASE expressions and the CAST function
- Write complex subqueries
- Code advanced SQL constructs, such as recursive SQL and table expressions
Who Can Benefit
This course is intended for individuals seeking to make use of SQL techniques to access Db2 databases in different environments. This course is appropriate for customers working in Db2 environments for Linux, UNIX, and Windows.
Prerequisites
Before taking this course, participants should:
- Be able to discuss basic Relational Database concepts
- Be able to code basic SQL statements
OR
- Have completed the SQL Workshop course (CL722G or 2L722G)
Course Details
Unit 1: SQL Introduction
- Identify the purpose of the clauses in the SELECT statement
- Describe the key differences among the IBM Db2 platforms
- Describe and use some of the OLAP features of Db2 such as GROUPING functions like CUBE and ROLLUP, and the RANK, DEFENSE_RANK, and ROW_NUMBER functions
Unit 2: Create Objects
- Code statements to:
- Create tables and views
- Alter tables
- Create indexes
- Implement referential integrity (RI)
- Define triggers and check constraints
- Identify impacts and advantages of referential integrity, including impacts of delete rules
- Identify considerations when using triggers and check constraints
- Identify the advantages of views
Unit 3: JOIN
- Use inner and outer joins to retrieve data from more than one table
- Use joins of tables to themselves
Unit 4: CASE, CAST, Summary (Materialized Query) Tables, and Temporary Tables
- Identify when CASE expressions can be useful
- Code CASE expressions in the SELECT list and in the WHERE clause
- Identify when CAST specifications can be used
- Identify the advantages of using Summary (Materialized Query) Tables and Temporary tables
Unit 5: Using Subqueries
- Code subqueries using the ALL, ANY / SOME, and EXISTS keywords
- Code correlated subqueries
- Choose the proper type of subquery to use in each case
Unit 6: Scalar Functions
- Extend your knowledge of scalar functions which:
- Manipulate arithmetic data
- Manipulate date values
- Manipulate character data
Unit 7: Table Expressions and Recursive SQL
- Identify reasons for table expressions and recursive SQL
- Use nested and common table expressions
- Identify the difference between views and table expressions
- Code recursive SQL
- Control the depth of recursion when coding recursive SQL
Unit 8: An Introduction to UDTs / UDFs and Stored Procedures
- Describe the concepts behind User-Defined District Types, User-Defined Functions, and Stored Procedures
Unit 9: SQL and Db2 Performance
- Explain some basic principles of Db2 performance
- Code SQL statements to obtain better performance
Schedule
5 options available
-
May 13, 2025 - May 15, 2025 (3 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Jun 11, 2025 - Jun 13, 2025 (3 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Aug 13, 2025 - Aug 15, 2025 (3 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Oct 8, 2025 - Oct 10, 2025 (3 days)
Live Virtual | 9:30AM – 5:30PM EDT Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EDT- Enroll
- Enroll Add to quote
-
Dec 3, 2025 - Dec 5, 2025 (3 days)
Live Virtual | 9:30AM – 5:30PM EST Language English Select from 1 options below Live Virtual |9:30AM – 5:30PM EST- Enroll
- Enroll Add to quote
FAQ
Does the course schedule include a Lunchbreak?
Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.
What languages are used to deliver training?
Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.
What does GTR stand for?
GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.
How do I find an Ascendient Learning training location?
We have training locations across the United States and Canada - View a complete list of classroom training locations.
Which delivery formats are available?
At Ascendient Learning, we offer training that is Instructor-Led, Online, Virtual, and Self-Paced.
Does Ascendient Learning deliver group training?
Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.
What does vendor-authorized training mean?
As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.
Is the training too basic, or will you go deep into technology?
It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.
How up-to-date are your courses and support materials?
We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.
Are your instructors seasoned trainers who have deep knowledge of the training topic?
Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.
Do you provide hands-on training and exercises in an actual lab environment?
Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.
Will you customize the training for our company’s specific needs and goals?
We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.
How do I get started with certification?
Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.
Will I get access to content after I complete a course?
You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.
How do I request a W9 for Ascendient Learning?
View our filing status and how to request a W9.
Reviews
The class covered the concepts needed for the AWS Cloud Practitioner Certification.
I found this course informative. It was easy to follow and provided some good information.
I thought the course was informative and the tools to go over the material were very nice.
Exit certified was great as it is very in depth and hands on learning which made it very easy to learn this type of work.
You get detailed labs to guide you through the technical material giving you a hands on method of learning otherwise difficult material.
