Course Outline
Table Joins
- Review of joins utilizing primary key and foreign key relationships
- Review of the differences between inner and outer joins
- Review of using link tables to address many-to-many relationships
- Self Joins
Sub Queries
- Review of nested sub-queries in Where and Having clauses
- Review of correlated sub-queries in Where and Having clauses
- Common Table Expressions
- Sub-Queries as columns
Summary Functions
- Review of primary summary functions
- Review of Group By and Having clauses
- Use of the Rollup function
- Use of the Cube function
- Use of Grouping and Grouping_Id functions
Hierarchical Queries
- Use of the Connect By Prior feature
- Use of Recursive Common Table Expressions
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 Basic SQL for government use.
Testimonials (5)
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.
Mona Dobre - DB Global Technology
Course - SQL Advanced level for Analysts
They way the instructor teaches is very informative and effective especially on the 2nd day when topics are a bit advanced.
