Other
[Tutorialsplanet NET] Udemy - Master SQL For Data Science
Torrent info
Torrent Files List
1. Chapter 1 (Size: 1.27 GB) (Files: 88)
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
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [Tutorialsplanet NET] Udemy - Master SQL For Data Science Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
