top of page

Writing SQL Queries

The course describes the ANSI/ISO SQL standard, but also identifies deviations from the standard in the two most widely used database products, Oracle and Microsoft SQL Server.

$1299/Attendee

Cost

2 Days

Program Length
Upcoming Session

Scheduled by Demand

Join the Waitlist to be notified.

8:00AM - 5:00 PM

(Central Time Zone)

Virtual (Zoom)

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

Be the first to know when registration opens by joining our exclusive Training Notification List.

  • Early Access: Get priority access.

  • Stay Informed: Receive details about new sessions.

  • Limited Spots: Ensure you secure your spot.

No Upcoming Session?

All training classes are NONREFUNDABLE within 14 days of the training’s scheduled start date.

 

Attendees who wish to cancel within the 14-day nonrefundable period will need to email Rami Lotay (rslotay@memphis.edu) and give a detailed explanation as to why they cannot possibly attend.

 

Attendees may still be liable for payment in full pending review from our staff.

Cancellation Policy
bottom of page