SQL Intermediate to Advanced Certificate for Stefan Frond
Add to LinkedIn
Certificate ID:
809943
Authentication Code:
83dc4
Certified Person Name:
Stefan Frond
Trainer Name:
Philip Isham
Duration Days:
2
Duration Hours:
14
Course Name:
SQL Intermediate to Advanced
Course Date:
21 May 2025 10:00 to 23 May 2025 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