Course Outline
Table Joins
- Overview of joins utilizing primary key and foreign key relationships
- Differentiation between inner and outer joins
- Use of link tables to manage many-to-many relationships
- Self Joins
Sub Queries
- Review of nested sub-queries in the Where and Having clauses
- Examination of correlated sub-queries in the Where and Having clauses
- Common Table Expression (CTE)
- Sub-Queries as columns
Summary Functions
- Review of primary summary functions
- Utilization of the Group By and Having clauses
- Application of the Rollup function
- Implementation of the Cube function
- Use of Grouping and Grouping_Id functions
Hierarchical Queries
- Utilization of the Connect By Prior feature
- Use of Recursive Common Table Expressions (CTEs)
Analytic/ Window Functions
- Analytic versions of primary summary functions
- Ranking functions
- Lead and Lag functions
Summary and Next Steps for government
Requirements
- A foundational knowledge of SQL for government data management and analysis.
Testimonials (5)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Gunnar created a great rapport with the audience and was quick to identify our needs. He was engaging and highly knowledgeable throughout and we enjoyed his humour.
Kurt - Complete Coherence
Course - SQL For Data Science and Data Analysis
Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.
Stefan
Course - SQL in SQL Server
analytical functions
khusboo dassani - Tech Northwest Skillnet
Course - SQL Advanced
The training materials.
