| 1. Chapter 1 | |||
| 1. Course Overview.mp4 | 52.84 MB | ||
| 1. Course Overview.vtt | 6.33 KB | ||
| 10. Window Functions for Analytics | |||
| 1. Window Functions using the OVER() Clause.mp4 | 29.87 MB | ||
| 1. Window Functions using the OVER() Clause.vtt | 23.61 KB | ||
| 2. Ordering Data in Window Frames.mp4 | 34.78 MB | ||
| 2. Ordering Data in Window Frames.vtt | 25.32 KB | ||
| 3. RANK, FIRST_VALUE and NTILE Functions.mp4 | 111.24 MB | ||
| 3. RANK, FIRST_VALUE and NTILE Functions.vtt | 15.11 KB | ||
| 4. LEAD and LAG Functions.mp4 | 63.17 MB | ||
| 4. LEAD and LAG Functions.vtt | 9.68 KB | ||
| 5. Working with Rollups and Cubes.mp4 | 111.95 MB | ||
| 5. Working with Rollups and Cubes.vtt | 14.4 KB | ||
| 5.1 sales_tbl.txt.txt | 696 B | ||
| 11. Difficult Query Challenges | |||
| 1. Challenging Puzzles For the Brave.html | 135 B | ||
| 2. Get Access to All of my current and future courses!.html | 1021 B | ||
| 2. Database Basics | |||
| 1. What is a Database.mp4 | 15.48 MB | ||
| 1. What is a Database.vtt | 11.55 KB | ||
| 2. Install Postgres Database on Mac.mp4 | 12.56 MB | ||
| 2. Install Postgres Database on Mac.vtt | 9.31 KB | ||
| 3. Troubleshoot Connection.html | 1.14 KB | ||
| 4. Install Postgres on Windows.mp4 | 71.58 MB | ||
| 4. Install Postgres on Windows.vtt | 10.15 KB | ||
| 5. Create Table and Insert Statements.mp4 | 43.26 MB | ||
| 5. Create Table and Insert Statements.vtt | 25.61 KB | ||
| 6. Data file that will be used in the course (IMPORTANT).html | 444 B | ||
| 7. Prepare the Database.mp4 | 39.94 MB | ||
| 7. Prepare the Database.vtt | 17.1 KB | ||
| 7.1 mock_data.sql.sql | 119.58 KB | ||
| 8. Create More Tables and Populate Data.html | 135 B | ||
| 3. SQL Query Basics | |||
| 1. Introducing the SELECT Statement.mp4 | 32.79 MB | ||
| 1. Introducing the SELECT Statement.vtt | 21.16 KB | ||
| 2. Filter Data Using the WHERE Clause + AND & OR.mp4 | 40.41 MB | ||
| 2. Filter Data Using the WHERE Clause + AND & OR.vtt | 28.43 KB | ||
| 3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.mp4 | 30.13 MB | ||
| 3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.vtt | 18.59 KB | ||
| 4. [EXERCISES] WHERE Clause and Operators.mp4 | 19.26 MB | ||
| 4. [EXERCISES] WHERE Clause and Operators.vtt | 13.58 KB | ||
| 5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.mp4 | 21.25 MB | ||
| 5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.vtt | 13.83 KB | ||
| 6. Practice Writing Basic Queries (5 Problems).html | 135 B | ||
| 4. Using Functions | |||
| 1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.mp4 | 25.01 MB | ||
| 1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.vtt | 19.64 KB | ||
| 2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().mp4 | 23.87 MB | ||
| 2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().vtt | 20.18 KB | ||
| 3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().mp4 | 15.55 MB | ||
| 3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().vtt | 12.59 KB | ||
| 4. Practice with Functions, Conditional Expressions and Concatenation.html | 135 B | ||
| 5. Grouping Data and Computing Aggregates | |||
| 1. Understanding Grouping.mp4 | 8.91 MB | ||
| 1. Understanding Grouping.vtt | 7.38 KB | ||
| 2. GROUP BY & HAVING Clauses.mp4 | 25.88 MB | ||
| 2. GROUP BY & HAVING Clauses.vtt | 20.89 KB | ||
| 3. [EXERCISES] Using GROUP BY and HAVING Clauses.mp4 | 25.9 MB | ||
| 3. [EXERCISES] Using GROUP BY and HAVING Clauses.vtt | 20.98 KB | ||
| 4. Practice Aggregation Queries.html | 135 B | ||
| 6. Using Subqueries | |||
| 1. Aliasing Sources of Data.mp4 | 9.4 MB | ||
| 1. Aliasing Sources of Data.vtt | 7.88 KB | ||
| 2. Introducing Subqueries.mp4 | 23.89 MB | ||
| 2. Introducing Subqueries.vtt | 16.77 KB | ||
| 3. Subqueries Continued + [EXERCISES].mp4 | 29.73 MB | ||
| 3. Subqueries Continued + [EXERCISES].vtt | 22.12 KB | ||
| 4. Subqueries with ANY and ALL Operators + [EXERCISES].mp4 | 32.95 MB | ||
| 4. Subqueries with ANY and ALL Operators + [EXERCISES].vtt | 23.05 KB | ||
| 5. [EXERCISES] More Practice with Subqueries.mp4 | 22.47 MB | ||
| 5. [EXERCISES] More Practice with Subqueries.vtt | 18.34 KB | ||
| 6. Practice with Subqueries.html | 135 B | ||
| 7. Using the CASE Clause in Interesting Ways | |||
| 1. Conditional Expressions Using CASE Clause + [EXERCISES].mp4 | 33.08 MB | ||
| 1. Conditional Expressions Using CASE Clause + [EXERCISES].vtt | 24.24 KB | ||
| 2. Transposing Data using the CASE Clause + [EXERCISES].mp4 | 30.2 MB | ||
| 2. Transposing Data using the CASE Clause + [EXERCISES].vtt | 20.8 KB | ||
| 3. Practice Using Case and Transposing Data.html | 135 B | ||
| 8. Advanced Query Techniques using Correlated Subqueries | |||
| 1. Understanding Correlated Subqueries.mp4 | 32.05 MB | ||
| 1. Understanding Correlated Subqueries.vtt | 24.88 KB | ||
| 2. [EXERCISES] Correlated Subqueries Continued.mp4 | 26.11 MB | ||
| 2. [EXERCISES] Correlated Subqueries Continued.vtt | 18.85 KB | ||
| 9. Working with Multiple Tables | |||
| 1. Introducing Table Joins.mp4 | 25.62 MB | ||
| 1. Introducing Table Joins.vtt | 19.48 KB | ||
| 2. INNER and OUTER Joins + [EXERCISES].mp4 | 40.68 MB | ||
| 2. INNER and OUTER Joins + [EXERCISES].vtt | 30.98 KB | ||
| 3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4 | 20.96 MB | ||
| 3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].vtt | 18.5 KB | ||
| 4. Cartesian Product with the CROSS JOIN.mp4 | 11.56 MB | ||
| 4. Cartesian Product with the CROSS JOIN.vtt | 8.06 KB | ||
| 5. [EXERCISES] Joins and Subqueries Continued.mp4 | 27.38 MB | ||
| 5. [EXERCISES] Joins and Subqueries Continued.vtt | 20.3 KB | ||
| 6. Creating Views vs. Inline Views.mp4 | 80.44 MB | ||
| 6. Creating Views vs. Inline Views.vtt | 11.69 KB | ||
| 7. ADVANCED Problems using Joins, Grouping and Subqueries.html | 135 B | ||
| [Tutorialsplanet.NET].url | 128 B |
Udemy - Master SQL For Data Science [TP]
This course will turn you into a SQL query wizard. You’ll learn the skills you need to extract critical insight from data sitting in a database.
For more Udemy Courses: https://tutorialsplanet.net
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.2 GB | freecoursewb | 2 weeks | 14 | 2 | |
| 1.3 GB | freecoursewb | 3 weeks | 14 | 10 | |
|
Udemy - LoadRunner Essentials - Master Performance Testing and Analysis Posted by
freecoursewb in Other
|
942.4 MB | freecoursewb | 4 weeks | 0 | 0 |
|
Udemy - Master AI Prompt Writing - Content, Branding and Productivity Posted by
freecoursewb in Other
|
1.2 GB | freecoursewb | 4 weeks | 23 | 9 |
| 561.9 MB | freecoursewb | 4 weeks | 8 | 6 |
All Comments