Advanced SQL



Course Length: 2 Days

Learning Objectives:
By the end of this training you’ll be able to:
  • Become a SQL power user.
  • Understand and solve complex SQL problems.
  • Learn more about set processing, advanced grouping, table expressions, recursion and more.
Target Student:
Programmers, Analysts, Database Administrators, End Users and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database.

Prerequisites :
Before taking this course, students should take SQL Basics or have equivalent work experience.

Course Outline:
Get ready to go to the next level with the Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you. Come prepared to master the Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. We begin with a review of joins and move quickly to more complex operations involving set processing, advanced grouping, table expressions, recursion and more. Each topic is reinforced with hands-on workshops. Examples and workshops are provided for multiple platforms, such as Db2 for z/OS, Db2 for Linux, Unix & Windows, Oracle, SQL Server or PostgreSQL, with discussion of the relevant differences.

Topics covered in this course:
  • Review Inner/Outer Joins
  • Subquery Table Expressions
  • Set Operations
  • Advanced Grouping with the CUBE, ROLLUP and GROUPING SETS Extensions
  • Solving Complex Problems with SQL
  • PIVOT and UNPIVOT Operations
  • Using Temporary Tables and Views

This Course Comes With

PDF Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices



Delivered by One of Our Trusted Partners
Advanced
Date(s) Price Qty
January 12 & 13, 2023 10am to 5pm EST $1,440.00 (CAD)*  
May 4 & 5, 2023 10am to 5pm EST $1,440.00 (CAD)*  

* 13% HST will be applied on checkout


Online registration closes two business days before the start of the class.
Questions?
Do you have questions about this course? Would you like a class sooner or on a different date? Are you interested in scheduling a private group class? Please submit the simple form below and we will respond promptly.
Private Training for GroupsIf you are training 8+ people, a private training session may be more cost-effective. Click to contact us today and learn more.
Register for this class here
Learn more about each course here
Contact us for more information here