Udemy - Advanced SQL for Data Engineering

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

No comments yet.