| 1 - Introduction.mp4 | 59.8 MB | ||
| 10 - Type of Joins.mp4 | 97 MB | ||
| 10 - joins.sql | 1.2 KB | ||
| 11 - How To Use INNER JOIN.mp4 | 40.1 MB | ||
| 12 - How To Use LEFT JOIN.mp4 | 21.9 MB | ||
| 13 - How To Use RIGHT JOIN.mp4 | 37.9 MB | ||
| 14 - How To Use FULL OUTER JOIN.mp4 | 13.2 MB | ||
| 15 - Lecture CTEs And How To Structure A Query.mp4 | 139.5 MB | ||
| 15 - ctes.sql | 716.8 B | ||
| 16 - Window Functions ROW NUMBER LEAD LAG PARTITION BY.mp4 | 186.4 MB | ||
| 16 - window-functions.sql | 716.8 B | ||
| 17 - SQL-Best-Practices.pdf | 108.1 KB | ||
| 17 - Work Smarter Not Harder MarketProven Tips for Optimal Queries Tables.mp4 | 126.1 MB | ||
| 2 - Lecture 2 Whats a Relational Database Anyway.mp4 | 55 MB | ||
| 3 - DBeaver Community Download Link.txt | 0 B | ||
| 3 - Lecture 3 The SQL Toolbox.mp4 | 40.5 MB | ||
| 3 - online-store-sales.csv | 147.4 KB | ||
| 4 - How To Use SELECT statement.mp4 | 36.5 MB | ||
| 4 - basic-statements.sql | 921.6 B | ||
| 5 - How To Use WHERE statement.mp4 | 44.8 MB | ||
| 6 - How To Use CASE WHEN statement.mp4 | 46.4 MB | ||
| 7 - How To Use ORDER BY statement.mp4 | 19.1 MB | ||
| 8 - How To Use GROUP BY statement.mp4 | 43.8 MB | ||
| 8 - aggregations.sql | 614.4 B | ||
| 9 - How To Use HAVING statement.mp4 | 33 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| _bus_routes.csv | 614.4 B | ||
| _bus_trips.csv | 614.4 B | ||
| _buses.csv | 614.4 B | ||
| _ticket_sales.csv | 716.8 B | ||
| bus_routes.csv | 48.3 KB | ||
| bus_trips.csv | 71.8 KB | ||
| buses.csv | 21.6 KB | ||
| ticket_sales.csv | 31.9 KB | ||
| ▲ 35 total files | |||
Sql For Newbies: Hands-On Sql With Industry Best Practices
https://WebToolTip.com
Published 3/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.02 GB | Duration: 1h 33m
Beginner-friendly guide to writing, optimizing, and mastering SQL step by step!
What you'll learn
Real-World Application & Optimization – Master industry-proven practices to optimize queries, enhance performance, and handle heavy data pipelines efficiently.
Learn in a hands-on onboarding setting, as if we’re working side by side at the office, preparing you to manage upcoming requests.
Master the Fundamentals of SQL – Learn how to write basic SQL queries using SELECT, WHERE, CASE WHEN and ORDER BY to retrieve and filter data effectively.
Perform Data Aggregation & Analysis – Use SQL functions such as GROUP BY, HAVING, SUM(), COUNT(), and AVG() to summarize and analyze data.
Work with Multiple Tables & Optimize Queries – Understand different types of joins, use CTEs, and apply best practices for query optimization.
Leverage Advanced SQL Features – Explore window functions (ROW_NUMBER(), PARTITION BY, LEAD(), LAG()), date manipulation and data transformations
Requirements
No programming experience needed.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.6 GB | freecoursewb | 5 days | 0 | 0 | |
| 1.3 GB | freecoursewb | 5 days | 0 | 0 | |
| 258.8 MB | freecoursewb | 5 days | 0 | 0 | |
| 3.8 GB | freecoursewb | 1 month | 23 | 3 | |
| 1.7 GB | freecoursewb | 1 month | 16 | 1 |
All Comments