Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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.
14 Hours
Testimonials (3)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,
Annina - Ricardo AG
Course - SQL: Basics to Intermediate
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
