Writing SQL Queries
$1299/Attendee
Cost
Program Length
2 Days
Course Overview
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
For cancellation notices received more than fifteen business days prior to the class date, students may receive either a full refund or reschedule into another class date.
For cancellation notice less than fifteen business days prior to the class start date, students will receive an voucher in the amount of the paid tuition to use for the same course up to a six months’ time frame and will be automatically put onto the wait list of the course of their choice and granted final admission ten business days prior to class start day based on enrollment levels.