SQL Advanced - Bespoke Certificate for Clyde Ravi Bitera
Certificate ID:
569883
Authentication Code:
1a8d8
Certified Person Name:
Clyde Ravi Bitera
Trainer Name:
Rey Norbert Besmonte
Duration Days:
2
Duration Hours:
14
Course Name:
SQL Advanced - Bespoke
Course Date:
2018-12-09 08:00 to 2018-12-10 17:00
Venue:
Makati City
Course Outline:
Lesson 1: Differences in syntax for different database
- Redshift, PosgreSQL, AWS Athena, MySQL
- SQL for data mining
Lesson 2: Querying with unions and advanced joins
- Querying multiple tables with unions
- Advanced Joins
- Calculating with COMPUTE
Lesson 3: Querying with subqueries
- Subqueries
Lesson 4: Writing efficient queries
- How SQL compiles into a query plan
- Rewriting SQL statements
- Avoiding unecessary processing, optimizing subqueries, etc.
Lesson 5: Query Performance (How to optimize SQL queries)
- Understanding SQL compilation, execution and parallelization
- How index structures and compression impact query execution
- Environment considerations
Lesson 6: Common Query Errors and how to resolve
- Nulls, NOT IN, indexes, subquery columns, etc.