Objectives

This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to:

• Maximize the potential of SQL to build powerful, complex and robust SQL queries

• Query multiple tables with inner joins, outer joins and self joins

• Construct recursive common table expressions

• Summarize data using aggregation and grouping

• Execute analytic functions to calculate ranks

• Build simple and correlated subqueries

• Thoroughly test SQL queries to avoid common errors

• Select the most efficient solution to complex SQL problems

Course Outline

• SQL Quick Refresher

• Retrieving Data with SELECT

• Executing Quries

• Implementing Various Types of Joins

• Writing Self Joins

• Combining Queries with Set Operators

• Summarizing Data with Aggregate Functions

• Grouping Data

• Extending Group Queries

• The OVER Clause

• Extending the Use of Aggregates

• Building Subqueries

• Self-contained Subqueries

• Correlated Subqueries

• Common Table Expressions