数据工程的高级 SQL
- 1. Setting up the environment and overview of relational databases
- 1. Introduction to the course
- 3. Setting up the environment
- 4. An overview of relational databases
- 5. DDL, DML, DQL, DCL
- 6. SQL syntax
- 2. Manipulating databases Mastering essential SQL statements
- 1. Intro SQL statements
- 2. CREATE
- 3. ALTER
- 4. INSERT
- 5. UPDATE
- 6. DELETE
- 7. MERGE
- 8. DROP
- 3. Timing is everything managing and manipulating DateTime in SQL
- 1. DateTime intro
- 2. Different DateTime types
- 3. Timezones
- 4. Intervals
- 4. Complex data types ENUMs, ARRAYs, Ranges, and Nested data in SQL
- 1. ENUM
- 2. ARRAYs
- 3. RANGE
- 4. Nested data
- 5. Advanced query techniques exploring OVER, JOINS, CASE and more in SQL
- 1. OVER
- 2. CROSS JOIN
- 3. LATERAL JOIN
- 4. CROSS JOIN LATERAL
- 5. COALESCE
- 6. CASE
- 7. CONCAT
- 8. Recursive CTE
- 9. Recursive CTE - second part
- 6. Optimizing data structures The art and science of data normalization in SQL
- 1. Data normatlization (13)
- 2. Data normatlization (23)
- 3. Data normatlization (33)
- 4. STAR schema Snowflake
- 7. Performance and control Mastering stored procedures, temporary tables
- 1. Stored procedures and UDFs (13)
- 2. Stored procedures and UDFs (23)
- 3. Stored procedures and UDFs (33)
- 4. Temp table
- 5. Materialized view
- 6. Transactions
- 7. SQL structures
- 8. Practical tasks
- 1. Question 1
- 2. Question 2
- 3. Question 3
- 4. Question 4