Udemy - Master SQL For Data Science [TP]

seeders: 3
leechers: 3
updated:
Added by tutplanet in Other > Tutorials

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

Files

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

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.



Download torrent
1.3 GB
seeders:3
leechers:3
Udemy - Master SQL For Data Science [TP]


Trackers

tracker name
ahttp://0d.kebhana.mx:443/announce
udp://bigfoot1942.sektori.org:6969/announce
https://tracker.fastdownload.xyz:443/announce
https://opentracker.xyz:443/announce
http://open.trackerlist.xyz:80/announce
http://torrent.nwps.ws:80/announce
udp://tracker.port443.xyz:6969/announce
udp://tracker.tiny-vps.com:6969/announce
http://t.nyaatracker.com:80/announce
udp://tracker.birkenwald.de:6969/announce
udp://tracker.vanitycore.co:6969/announce
udp://tracker.torrent.eu.org:451/announce
udp://retracker.lanta-net.ru:2710/announce
udp://retracker.hotplug.ru:2710/announce
udp://bt.xxx-tracker.com:2710/announce
udp://tracker.uw0.xyz:6969/announce
udp://exodus.desync.com:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://explodie.org:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.iamhansen.xyz:2000/announce
udp://tracker.toss.li:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://tracker.justseed.it:1337/announce
https://2.track.ga:443/announce
udp://open.stealth.si:80/announce
udp://zephir.monocul.us:6969/announce
udp://open.demonii.si:1337/announce
µTorrent compatible trackers list

Download torrent
1.3 GB
seeders:3
leechers:3
Udemy - Master SQL For Data Science [TP]


Torrent hash: C386C3B56DB58CD2E808B648454EDB9C1C88F06C