SQL Intermediate to Advanced Certificate for Titus Guvir
Certificate ID:
740307
Authentication Code:
a61f7
Certified Person Name:
Titus Guvir
Trainer Name:
Philip Isham
Duration Days:
2
Duration Hours:
14
Course Name:
SQL Intermediate to Advanced
Course Date:
2023-10-24 10:00 to 2023-10-25 17:00
Course Outline:
Extended Use Of Summary Functions
- Group_Concat
- Rollup
- Grouping Function
Window Functions
- Summarising
- Ranking
- Lead & Lag
- Percentiles
Extended Use Of Sub-Queries
- Common Table Expression
- Columns
Recursive Common Table Expressions
- Hierarchical Queries
- Reporting Grids
Stored Procedures
- Use of parameters
- Use of IF statements
- Use of Loops & Cursors
Execution Plan
Indexes