Loading...

Course Description

Take your SQL skills to the next level and learn to write more advanced select queries. Building on the skills learned in the prior SQL classes, enhance your queries with date and string functions. Learn special purpose, irregular pattern, and top value queries. Use correlated subqueries to create running totals and subtotals. Explore metadata queries and schemabinding. Pivoting query results will also be covered.

In this class, you will learn how to: 

  • Use date functions 

  • Use string functions 

  • Make custom queries to handle irregular patterns in your data 

  • Display different output values based on data conditions 

  • Run different types of top-value queries 

  • Create running totals 

  • Search database metadata 

  • Use pivot table data 

  • Perform self-joins on tables 

Prerequisites

Advanced SQL Queries: Level 1 or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced SQL Queries: Level 2
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 26, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 24, 2024
Transfer Request Deadline
Mar 24, 2024
Section Title
Advanced SQL Queries: Level 2
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 26, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 24, 2024
Transfer Request Deadline
Mar 24, 2024
Section Title
Advanced SQL Queries: Level 2
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Apr 16, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 14, 2024
Transfer Request Deadline
Apr 14, 2024
Section Title
Advanced SQL Queries: Level 2
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Apr 16, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 14, 2024
Transfer Request Deadline
Apr 14, 2024
Section Title
Advanced SQL Queries: Level 2
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Jun 04, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 02, 2024
Transfer Request Deadline
Jun 02, 2024
Section Title
Advanced SQL Queries: Level 2
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Jun 04, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Jun 02, 2024
Transfer Request Deadline
Jun 02, 2024
Required fields are indicated by .