| 1. Let's Recap.mp4 | 33 MB | ||
| 1. Overview.mp4 | 1.3 MB | ||
| 1. Welcome to Level 2!.mp4 | 20.1 MB | ||
| 2. Creating a Window Function.mp4 | 17.6 MB | ||
| 2. Our Learning Objectives.mp4 | 11.5 MB | ||
| 2. Simple CASE - Data Transformation.mp4 | 21.1 MB | ||
| 2. Union, Intersect, Except.mp4 | 34.9 MB | ||
| 2. Virtual Tables (Views).mp4 | 35.1 MB | ||
| 2. What is Subquery.mp4 | 10.6 MB | ||
| 3. Common Table Expressions (CTEs).mp4 | 14.1 MB | ||
| 3. Conditional Logic – Single Row.mp4 | 35.8 MB | ||
| 3. Cross-Join.mp4 | 12.3 MB | ||
| 3. Loading the Books Datasets.mp4 | 48.6 MB | ||
| 3. Searched CASE – Classification and Binning.mp4 | 28.4 MB | ||
| 3. Sequential Numbers.mp4 | 19.6 MB | ||
| 4. Conditional Logic – Multiple Rows.mp4 | 32.7 MB | ||
| 4. Inner-Join.mp4 | 42.8 MB | ||
| 4. Loading the eCommerce Datasets.mp4 | 36.1 MB | ||
| 4. Quiz #3 - Conditional Logic (CASE).html | 204.8 B | ||
| 4. Quiz #5 - Simplify Queries (Views, CTEs).html | 204.8 B | ||
| 4. Ranking.mp4 | 7.8 MB | ||
| 5. As Inline Views (FROM).mp4 | 18 MB | ||
| 5. Outer-Join.mp4 | 31.8 MB | ||
| 5. Quiz #4 - Window Functions.html | 204.8 B | ||
| 6. Quiz #1 - Combining Data from Multiple Tables.html | 204.8 B | ||
| 6. Quiz #2 - Subqueries.html | 204.8 B | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| books1.csv | 16.6 MB | ||
| books2.csv | 6 MB | ||
| customers.csv | 5.8 MB | ||
| order_items.csv | 10.4 MB | ||
| order_payments.csv | 5.5 MB | ||
| order_reviews.csv | 5.5 MB | ||
| orders.csv | 12 MB | ||
| products.csv | 2 MB | ||
| ratings.csv | 26.7 MB | ||
| suppliers.csv | 162.8 KB | ||
| users.csv | 10.1 MB | ||
| ▲ 43 total files | |||
The Complete SQL Bootcamp for Data Analysis – Level 2
https://DevCourseWeb.com
Published 09/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 25 lectures (1h 43m) | Size: 568.1 MB
Learn SQL A-to-Z for Data Analysis Projects
What you'll learn
Use SQL to query data in databases
Perform data analysis and extract useful insights
Combine Data from Multiple Tables
Filter Data using Subqueries
Perform Data Transformation using CASE statements
Utilize Window Functions for data analysis
Simplify Queries using Views and CTEs
Requirements
A basic SQL syntax (SELECT, WHERE, ORDER BY, GROUP BY, HAVING)
It is recommended to start with Level 1 of this training program
Don't forget to bring a nice coffee (or tea), and a smile for a great starting vibe ;-)
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.7 GB | freecoursewb | 3 days | 0 | 0 | |
| 3.8 GB | freecoursewb | 3 days | 6 | 24 | |
| 1.3 GB | freecoursewb | 3 days | 79 | 7 | |
| 1.5 GB | freecoursewb | 3 days | 1 | 16 | |
| 628.1 MB | freecoursewb | 3 days | 0 | 0 |
All Comments