SQL Advanced - Bespoke Certificate for John Paul Guim
Certificate ID:
555679
Authentication Code:
02611
Certified Person Name:
John Paul Guim
Trainer Name:
Rey Norbert Besmonte
Duration Days:
2
Duration Hours:
14
Course Name:
SQL Advanced - Bespoke
Course Date:
2018-06-24 09:00 to 2018-06-25 17:30
Venue:
Makati
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.