SQL Intermediate

• An understanding of Basic SQL

This instructor-led, live training is aimed at intermediate-level SQL users who want to improve their basic skills in SQL and also systematize already gained knowledge.

Table Joins

• Recap of joins using primary key and foreign key connections
• Recap of difference between inner and outer joins
• Recap of usage of link tables to resolve many-to-many relationships
• Self Joins

Sub Queries

• Recap of nested sub-queries in Where & Having clauses
• Recap of correlated sub-queries in Where & Having clauses
• Common Table Expression
• Sub-Queries as columns

Summary Functions

• Recap of main summary functions
• Recap of Group By & Having clauses
• Use of Rollup function
• Use of Cube function
• Use of Grouping & Grouping_Id functions

Hierarchical Queries

• Use of Connect By Prior facility
• Use of Recursive Common Table Expression

Analytic/ Window functions

• Analytic versions of main summary functions
• Ranking functions
• Lead & Lag functions

Summary and Next Steps