Udemy - Master SQL For Data Science [TP]

seeders: 5
leechers: 1
Added 7 years ago by tutplanet in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

Udemy - Master SQL For Data Science [TP] (Size: 1.27 GB)
  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

Description


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

Related Torrents

torrent name size uploader age seed leech
2
10
0
9
6