Loading...

Course Description

Continue your path to mastery of SQL commands with more complex queries and advanced features of SQL to access information from a relational database. Work with complex joins from multiple tables, three or more table queries, and learn to reference the same data set multiple times. Understand how to do sub-queries to handle multi-table tasks and when to use sub-queries versus using joins. Review Date Queries and understand how to use the Datename and Datepart functions. Topics include working with aggregate data and using the Over(), Group By, and Having clauses. Additional topics include Top Record/Top Percent queries and using the Rank() and Dense_Rank() functions.

In this class, you will learn how to: 

  • Use complex joins to link two or more tables 

  • Understand relationships between linked tables 

  • Work with Aggregate Data and the Order, Group By, and Having clauses 

  • Pull out the top and top percent in your results 

  • Understand the Rank() and Dense_Rank functions 

  • Execute subqueries 

  • Understand the difference between subqueries and joins 

  • Work with date queries and the Datename and Datepart functions 

Prerequisites

Intermediate Applications of SQL or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced SQL Queries: Level 1
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 19, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 17, 2024
Transfer Request Deadline
Mar 17, 2024
Section Title
Advanced SQL Queries: Level 1
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Mar 19, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Mar 17, 2024
Transfer Request Deadline
Mar 17, 2024
Section Title
Advanced SQL Queries: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Apr 11, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 09, 2024
Transfer Request Deadline
Apr 09, 2024
Section Title
Advanced SQL Queries: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Apr 11, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 09, 2024
Transfer Request Deadline
Apr 09, 2024
Section Title
Advanced SQL Queries: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
May 30, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 28, 2024
Transfer Request Deadline
May 28, 2024
Section Title
Advanced SQL Queries: Level 1
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
May 30, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 28, 2024
Transfer Request Deadline
May 28, 2024
Required fields are indicated by .