Course Code:
adsql2
Duration:
14 hours
Prerequisites:
SQL: Fundamentals of Querying or equivalent knowledge.
Overview:
Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
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.