SQL Intermediate to Advanced Certificate for Alexandru Damian
Certificate ID:
740299
Authentication Code:
1ffca
Certified Person Name:
Alexandru Damian
Trainer Name:
Philip Isham
Duration Days:
2
Duration Hours:
14
Course Name:
SQL Intermediate to Advanced
Course Date:
24 October 2023 10:00 to 25 October 2023 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