CS318 - Advanced SQL Queries: Level 1

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 

Applies Towards the Following Certificates

• Data Analysis Certificate : Required Courses
• Database Technology Certificate : Core Courses Required
• Programming Certificate : Required Courses
• Python Data Analysis Certificate : Electives