[Tutorialsplanet.NET] Udemy - Master SQL For Data Science

Other

Size

1.3 GB

Seeders

Leechers

Files

Category

Other

Added

08/09/19 at 8:41am GMT+1

Status

Verified by VeriPLUS

Infohash

c386c3b56db58cd2e808b648454edb9c1c88f06c

Direct link Torrent file Download now

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. There are over 100 puzzles scattered throughout the course with in-depth solutions providing plenty of opportunity for you to practice. After completing the course and all of it’s assignments, I promise you, you’ll never be afraid to look at a large SQL query again.

Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, rollups and cubes, window functions, transposing & ranking data and using conditional expressions in very interesting ways.

As always I offer a 30 day money back guarantee but I doubt you’ll need it.

File list

[Tutorialsplanet.NET] Udemy - Master SQL For Data Science
1. Chapter 1/1. Course Overview.mp4 52.8 MB
1. Chapter 1/1. Course Overview.vtt 6.3 KB
10. Window Functions for Analytics/1. Window Functions using the OVER() Clause.mp4 29.9 MB
10. Window Functions for Analytics/1. Window Functions using the OVER() Clause.vtt 23.6 KB
10. Window Functions for Analytics/2. Ordering Data in Window Frames.mp4 34.8 MB
10. Window Functions for Analytics/2. Ordering Data in Window Frames.vtt 25.3 KB
10. Window Functions for Analytics/3. RANK, FIRST_VALUE and NTILE Functions.mp4 111.2 MB
10. Window Functions for Analytics/3. RANK, FIRST_VALUE and NTILE Functions.vtt 15.1 KB
10. Window Functions for Analytics/4. LEAD and LAG Functions.mp4 63.2 MB
10. Window Functions for Analytics/4. LEAD and LAG Functions.vtt 9.7 KB
10. Window Functions for Analytics/5. Working with Rollups and Cubes.mp4 111.9 MB
10. Window Functions for Analytics/5. Working with Rollups and Cubes.vtt 14.4 KB
10. Window Functions for Analytics/5.1 sales_tbl.txt.txt 696 B
11. Difficult Query Challenges/1. Challenging Puzzles For the Brave.html 135 B
11. Difficult Query Challenges/2. Get Access to All of my current and future courses!.html 1021 B
2. Database Basics/1. What is a Database.mp4 15.5 MB
2. Database Basics/1. What is a Database.vtt 11.5 KB
2. Database Basics/2. Install Postgres Database on Mac.mp4 12.6 MB
2. Database Basics/2. Install Postgres Database on Mac.vtt 9.3 KB
2. Database Basics/3. Troubleshoot Connection.html 1.1 KB
2. Database Basics/4. Install Postgres on Windows.mp4 71.6 MB
2. Database Basics/4. Install Postgres on Windows.vtt 10.1 KB
2. Database Basics/5. Create Table and Insert Statements.mp4 43.3 MB
2. Database Basics/5. Create Table and Insert Statements.vtt 25.6 KB
2. Database Basics/6. Data file that will be used in the course (IMPORTANT).html 444 B
2. Database Basics/7. Prepare the Database.mp4 39.9 MB
2. Database Basics/7. Prepare the Database.vtt 17.1 KB
2. Database Basics/7.1 mock_data.sql.sql 119.6 KB
2. Database Basics/8. Create More Tables and Populate Data.html 135 B
3. SQL Query Basics/1. Introducing the SELECT Statement.mp4 32.8 MB
3. SQL Query Basics/1. Introducing the SELECT Statement.vtt 21.2 KB
3. SQL Query Basics/2. Filter Data Using the WHERE Clause + AND & OR.mp4 40.4 MB
3. SQL Query Basics/2. Filter Data Using the WHERE Clause + AND & OR.vtt 28.4 KB
3. SQL Query Basics/3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.mp4 30.1 MB
3. SQL Query Basics/3. Filtering Operators - IN, NOT IN, IS NULL, BETWEEN.vtt 18.6 KB
3. SQL Query Basics/4. [EXERCISES] WHERE Clause and Operators.mp4 19.3 MB
3. SQL Query Basics/4. [EXERCISES] WHERE Clause and Operators.vtt 13.6 KB
3. SQL Query Basics/5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.mp4 21.2 MB
3. SQL Query Basics/5. Using ORDER BY, LIMIT, DISTINCT and Renaming Columns.vtt 13.8 KB
3. SQL Query Basics/6. Practice Writing Basic Queries (5 Problems).html 135 B
4. Using Functions/1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.mp4 25 MB
4. Using Functions/1. UPPER(), LOWER(), LENGTH(), TRIM() + Boolean Expressions & Concatenation.vtt 19.6 KB
4. Using Functions/2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().mp4 23.9 MB
4. Using Functions/2. String Functions SUBSTRING(), REPLACE(), POSITION() and COALESCE().vtt 20.2 KB
4. Using Functions/3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().mp4 15.6 MB
4. Using Functions/3. Grouping Functions MIN(), MAX(), AVG(), SUM(), COUNT().vtt 12.6 KB
4. Using Functions/4. Practice with Functions, Conditional Expressions and Concatenation.html 135 B
5. Grouping Data and Computing Aggregates/1. Understanding Grouping.mp4 8.9 MB
5. Grouping Data and Computing Aggregates/1. Understanding Grouping.vtt 7.4 KB
5. Grouping Data and Computing Aggregates/2. GROUP BY & HAVING Clauses.mp4 25.9 MB
5. Grouping Data and Computing Aggregates/2. GROUP BY & HAVING Clauses.vtt 20.9 KB
5. Grouping Data and Computing Aggregates/3. [EXERCISES] Using GROUP BY and HAVING Clauses.mp4 25.9 MB
5. Grouping Data and Computing Aggregates/3. [EXERCISES] Using GROUP BY and HAVING Clauses.vtt 21 KB
5. Grouping Data and Computing Aggregates/4. Practice Aggregation Queries.html 135 B
6. Using Subqueries/1. Aliasing Sources of Data.mp4 9.4 MB
6. Using Subqueries/1. Aliasing Sources of Data.vtt 7.9 KB
6. Using Subqueries/2. Introducing Subqueries.mp4 23.9 MB
6. Using Subqueries/2. Introducing Subqueries.vtt 16.8 KB
6. Using Subqueries/3. Subqueries Continued + [EXERCISES].mp4 29.7 MB
6. Using Subqueries/3. Subqueries Continued + [EXERCISES].vtt 22.1 KB
6. Using Subqueries/4. Subqueries with ANY and ALL Operators + [EXERCISES].mp4 33 MB
6. Using Subqueries/4. Subqueries with ANY and ALL Operators + [EXERCISES].vtt 23 KB
6. Using Subqueries/5. [EXERCISES] More Practice with Subqueries.mp4 22.5 MB
6. Using Subqueries/5. [EXERCISES] More Practice with Subqueries.vtt 18.3 KB
6. Using Subqueries/6. Practice with Subqueries.html 135 B
7. Using the CASE Clause in Interesting Ways/1. Conditional Expressions Using CASE Clause + [EXERCISES].mp4 33.1 MB
7. Using the CASE Clause in Interesting Ways/1. Conditional Expressions Using CASE Clause + [EXERCISES].vtt 24.2 KB
7. Using the CASE Clause in Interesting Ways/2. Transposing Data using the CASE Clause + [EXERCISES].mp4 30.2 MB
7. Using the CASE Clause in Interesting Ways/2. Transposing Data using the CASE Clause + [EXERCISES].vtt 20.8 KB
7. Using the CASE Clause in Interesting Ways/3. Practice Using Case and Transposing Data.html 135 B
8. Advanced Query Techniques using Correlated Subqueries/1. Understanding Correlated Subqueries.mp4 32.1 MB
8. Advanced Query Techniques using Correlated Subqueries/1. Understanding Correlated Subqueries.vtt 24.9 KB
8. Advanced Query Techniques using Correlated Subqueries/2. [EXERCISES] Correlated Subqueries Continued.mp4 26.1 MB
8. Advanced Query Techniques using Correlated Subqueries/2. [EXERCISES] Correlated Subqueries Continued.vtt 18.8 KB
9. Working with Multiple Tables/1. Introducing Table Joins.mp4 25.6 MB
9. Working with Multiple Tables/1. Introducing Table Joins.vtt 19.5 KB
9. Working with Multiple Tables/2. INNER and OUTER Joins + [EXERCISES].mp4 40.7 MB
9. Working with Multiple Tables/2. INNER and OUTER Joins + [EXERCISES].vtt 31 KB
9. Working with Multiple Tables/3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].mp4 21 MB
9. Working with Multiple Tables/3. Using UNION, UNION ALL and EXCEPT Clauses + [EXERCISES].vtt 18.5 KB
9. Working with Multiple Tables/4. Cartesian Product with the CROSS JOIN.mp4 11.6 MB
9. Working with Multiple Tables/4. Cartesian Product with the CROSS JOIN.vtt 8.1 KB
9. Working with Multiple Tables/5. [EXERCISES] Joins and Subqueries Continued.mp4 27.4 MB
9. Working with Multiple Tables/5. [EXERCISES] Joins and Subqueries Continued.vtt 20.3 KB
9. Working with Multiple Tables/6. Creating Views vs. Inline Views.mp4 80.4 MB
9. Working with Multiple Tables/6. Creating Views vs. Inline Views.vtt 11.7 KB
9. Working with Multiple Tables/7. ADVANCED Problems using Joins, Grouping and Subqueries.html 135 B

Rating

Not rated yet

Comments

No comments yet.

Similar torrents

Name	Size	Date
Udemy - SQL for Data Analysis & Data Science Verified in Other	2.4 GB	11/27/20	3	1
Udemy - Master R for Statistics and Data Science Verified in Other	2.7 GB	03/21/24	1	1
[ WebToolTip.com ] Udemy - SQL For Data Science Oracle , MySQL, R And Python (2025) in Other	1.7 GB	04/14/25	1	1
[FreeCourseLab.com] Udemy - Master SQL For Data Science Verified in Other	1.3 GB	12/27/18	0	1
[Tutorialsplanet.NET] Udemy - R Programming Hands-on Specialization for Data Science (Lv1) Verified in Other	1 GB	08/02/19	0	1
[Tutorialsplanet.NET] Udemy - Microsoft SQL for Beginners Verified in Other	1 GB	08/08/19	0	1
[Tutorialsplanet.NET] Udemy - Learning Python for Data Analysis and Visualization Verified in Other	3.7 GB	08/09/19	0	1
[Tutorialsplanet.NET] Udemy - Python for Data Science and Machine Learning Bootcamp Verified in Other	3.8 GB	08/21/19	0	1
[Tutorialsplanet.NET] Udemy - Wordpress for Beginners - Master Wordpress Quickly Verified in Other	2.8 GB	08/27/19	0	1
[Tutorialsplanet.NET] Udemy - Scraping and Data Mining for Beginners and Pros Verified in Other	148 MB	08/31/19	0	1
[Tutorialsplanet.NET] Udemy - Beginning with Machine Learning & Data Science in Python Verified in Other	543 MB	09/24/19	0	1
[Tutorialsplanet.NET] Udemy - Oracle Certification Mastering Java for Beginners & Experts Verified in Other	2.6 GB	09/24/19	0	2
[DesireCourse.Net] Udemy - Complete Data Science Training with Python for Data Analysis Verified in Other	2.3 GB	09/28/19	0	0
[Tutorialsplanet.NET] Udemy - SQL Course For Beginners Learn SQL Using MySQL Database Verified in Other	585 MB	10/07/19	0	1
[Tutorialsplanet.NET] Udemy - Node, SQL, & PostgreSQL - Mastering Backend Web Development Verified in Other	651 MB	10/26/19	0	3