Udemy - Advanced SQL for Data Engineering

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Setting up the environment and overview of relational databases
• 1. Introduction to the course.mp4 (22.0 MB)
• 2. Coure GitHub repository.html (0.8 KB)
• 3. Setting up the environment.mp4 (39.3 MB)
• 4. An overview of relational databases.mp4 (40.7 MB)
• 5. DDL, DML, DQL, DCL.mp4 (38.3 MB)
• 6. SQL syntax.mp4 (41.4 MB)
2. Manipulating databases Mastering essential SQL statements
• 1. Intro SQL statements.mp4 (18.6 MB)
• 2. CREATE.mp4 (21.1 MB)
• 3. ALTER.mp4 (10.7 MB)
• 4. INSERT.mp4 (9.1 MB)
• 5. UPDATE.mp4 (7.7 MB)
• 6. DELETE.mp4 (12.1 MB)
• 7. MERGE.mp4 (24.9 MB)
• 8. DROP.mp4 (8.4 MB)
3. Timing is everything managing and manipulating DateTime in SQL
• 1. DateTime intro.mp4 (53.6 MB)
• 2. Different DateTime types.mp4 (22.3 MB)
• 3. Timezones.mp4 (56.9 MB)
• 4. Intervals.mp4 (12.0 MB)
4. Complex data types ENUMs, ARRAYs, Ranges, and Nested data in SQL
• 1. ENUM.mp4 (54.5 MB)
• 2. ARRAYs.mp4 (42.9 MB)
• 3. RANGE.mp4 (31.6 MB)
• 4. Nested data.mp4 (49.3 MB)
5. Advanced query techniques exploring OVER, JOINS, CASE and more in SQL
• 1. OVER.mp4 (98.9 MB)
• 2. CROSS JOIN.mp4 (12.0 MB)
• 3. LATERAL JOIN.mp4 (35.7 MB)
• 4. CROSS JOIN LATERAL.mp4 (24.1 MB)
• 5. COALESCE.mp4 (45.9 MB)
• 6. CASE.mp4 (36.9 MB)
• 7. CONCAT.mp4 (24.0 MB)
• 8. Recursive CTE.mp4 (24.0 MB)
• 9. Recursive CTE - second part.mp4 (45.1 MB)
6. Optimizing data structures The art and science of data normalization in SQL
• 1. Data normatlization (13).mp4 (29.8 MB)
• 2. Data normatlization (23).mp4 (16.7 MB)
• 3. Data normatlization (33).mp4 (21.6 MB)
• 4. STAR schema Snowflake.mp4 (18.6 MB)
7. Performance and control Mastering stored procedures, temporary tables
• 1. Stored procedures and UDFs (13).mp4 (39.1 MB)
• 2. Stored procedures and UDFs (23).mp4 (25.2 MB)
• 3. Stored procedures and UDFs (33).mp4 (5.5 MB)
• 4. Temp table.mp4 (26.7 MB)
• 5. Materialized view.mp4 (34.5 MB)
• 6. Transactions.mp4 (65.1 MB)
• 7. SQL structures.mp4 (68.8 MB)
8. Practical tasks
• 1. Question 1.mp4 (21.0 MB)
• 2. Question 2.mp4 (63.4 MB)
• 3. Question 3.mp4 (11.0 MB)
• 4. Question 4.mp4 (36.1 MB)
• Bonus Resources.txt (0.4 KB)