[Tutorialsplanet NET] Udemy Master SQL For Data Science Torrent Download Locations

[Tutorialsplanet.NET] Udemy - Master SQL For Data Science
    1. Chapter 1
          1. Course Overview.mp4 -

          1. Course Overview.vtt -

    10. Window Functions for Analytics
          1. Window Functions using the OVER() Clause.mp4 -

          1. Window Functions using the OVER() Clause.vtt -

          2. Ordering Data in Window Frames.mp4 -

          2. Ordering Data in Window Frames.vtt -

          3. RANK, FIRST_VALUE and NTILE Functions.mp4 -

          3. RANK, FIRST_VALUE and NTILE Functions.vtt -

          4. LEAD and LAG Functions.mp4 -

          4. LEAD and LAG Functions.vtt -

          5. Working with Rollups and Cubes.mp4 -

          5. Working with Rollups and Cubes.vtt -

          5.1 sales_tbl.txt.txt -

    11. Difficult Query Challenges
          1. Challenging Puzzles For the Brave.html -

          2. Get Access to All of my current and future courses!.html -

    2. Database Basics
          1. What is a Database.mp4 -

          1. What is a Database.vtt -

          2. Install Postgres Database on Mac.mp4 -

          2. Install Postgres Database on Mac.vtt -

          3. Troubleshoot Connection.html -

          4. Install Postgres on Windows.mp4 -

          4. Install Postgres on Windows.vtt -

          5. Create Table and Insert Statements.mp4 -

          5. Create Table and Insert Statements.vtt -

          6. Data file that will be used in the course (IMPORTANT).html -

          7. Prepare the Database.mp4 -

          7. Prepare the Database.vtt -

          7.1 mock_data.sql.sql -

          8. Create More Tables and Populate Data.html -

    3. SQL Query Basics
          1. Introducing the SELECT Statement.mp4 -

          1. Introducing the SELECT Statement.vtt -

          2. Filter Data Using the WHERE Clause + AND & OR.mp4 -

          2. Filter Data Using the WHERE Clause + AND & OR.vtt -

          3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.mp4 -

          3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.vtt -

          4. [EXERCISES] WHERE Clause and Operators.mp4 -

          4. [EXERCISES] WHERE Clause and Operators.vtt -

          5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.mp4 -

          5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.vtt -

          6. Practice Writing Basic Queries (5 Problems).html -

    4. Using Functions
          1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.mp4 -

          1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.vtt -

          2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().mp4 -

          2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().vtt -

          3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().mp4 -

          3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().vtt -

          4. Practice with Functions, Conditional Expressions and Concatenation.html -

    5. Grouping Data and Computing Aggregates
          1. Understanding Grouping.mp4 -

          1. Understanding Grouping.vtt -

          2. GROUP BY & HAVING Clauses.mp4 -

          2. GROUP BY & HAVING Clauses.vtt -

          3. [EXERCISES] Using GROUP BY and HAVING Clauses.mp4 -

          3. [EXERCISES] Using GROUP BY and HAVING Clauses.vtt -

          4. Practice Aggregation Queries.html -

    6. Using Subqueries
          1. Aliasing Sources of Data.mp4 -

          1. Aliasing Sources of Data.vtt -

          2. Introducing Subqueries.mp4 -

          2. Introducing Subqueries.vtt -

          3. Subqueries Continued + [EXERCISES].mp4 -

          3. Subqueries Continued + [EXERCISES].vtt -

          4. Subqueries with ANY and ALL Operators + [EXERCISES].mp4 -

          4. Subqueries with ANY and ALL Operators + [EXERCISES].vtt -

          5. [EXERCISES] More Practice with Subqueries.mp4 -

          5. [EXERCISES] More Practice with Subqueries.vtt -

          6. Practice with Subqueries.html -

    7. Using the CASE Clause in Interesting Ways
          1. Conditional Expressions Using CASE Clause + [EXERCISES].mp4 -

          1. Conditional Expressions Using CASE Clause + [EXERCISES].vtt -

          2. Transposing Data using the CASE Clause + [EXERCISES].mp4 -

          2. Transposing Data using the CASE Clause + [EXERCISES].vtt -

          3. Practice Using Case and Transposing Data.html -

    8. Advanced Query Techniques using Correlated Subqueries
          1. Understanding Correlated Subqueries.mp4 -

          1. Understanding Correlated Subqueries.vtt -

          2. [EXERCISES] Correlated Subqueries Continued.mp4 -

          2. [EXERCISES] Correlated Subqueries Continued.vtt -

    9. Working with Multiple Tables
          1. Introducing Table Joins.mp4 -

          1. Introducing Table Joins.vtt -

          2. INNER and OUTER Joins + [EXERCISES].mp4 -

          2. INNER and OUTER Joins + [EXERCISES].vtt -

          3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4 -

          3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].vtt -

          4. Cartesian Product with the CROSS JOIN.mp4 -

          4. Cartesian Product with the CROSS JOIN.vtt -

          5. [EXERCISES] Joins and Subqueries Continued.mp4 -

          5. [EXERCISES] Joins and Subqueries Continued.vtt -

          6. Creating Views vs. Inline Views.mp4 -

          6. Creating Views vs. Inline Views.vtt -

          7. ADVANCED Problems using Joins, Grouping and Subqueries.html -

     [Tutorialsplanet.NET].url -