| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ~Get Your Files Here ! | |||
| 1 - Introduction What Is A Database | |||
| 1 - Welcome What Is A Database Why Sql.mp4 | 22 MB | ||
| 11 - Recap And Next Steps | |||
| 12 - Bonus Reference Materials | |||
| 17 - Bonus 1 Top 10 Sql Errors And How To Fix Them.html | 12.1 KB | ||
| 18 - Bonus 2 Sql Dialect Cheat Sheet Sqlite Postgresql Mysql Ms Sql Oracle.html | 9.2 KB | ||
| 19 - Bonus 3 Postgresql Setup Guide Step By Step.html | 14.4 KB | ||
| 19 - ecommerce-postgres.sql | 186.3 KB | ||
| 2 - Ddl Create Your First Table | |||
| 3 - Dml Insert Update Delete | |||
| 4 - Select Reading And Filtering Data | |||
| 5 - Aggregations And Group By | |||
| 10 - Lecture 5 Study Guide.html | 22.7 KB | ||
| 7 - Joins Connecting Tables | |||
| 11 - Lecture 6 Joins Connecting Tables.mp4 | 38.8 MB | ||
| 12 - Lecture 6 Study Guide.html | 27.3 KB | ||
| 8 - Subqueries And Ctes | |||
| 13 - Lecture 7 Subqueries And Ctes.mp4 | 35.5 MB | ||
| 14 - Lecture 7 Study Guide.html | 21.3 KB | ||
| 9 - Lecture 5 Aggregations Group By Dates.mp4 | 37 MB | ||
| 7 - Lecture 4 Select Where Null Order By Limit Distinct.mp4 | 31 MB | ||
| 8 - Lecture 4 Study Guide.html | 24 KB | ||
| 5 - Lecture 3 Dml Insert Update Delete The Where Rule.mp4 | 27.4 MB | ||
| 6 - Lecture 3 Study Guide.html | 29.4 KB | ||
| 3 - Lecture 2 Ddl Create Your First Table.mp4 | 47.8 MB | ||
| 4 - Lecture 2 Study Guide.html | 35.1 KB | ||
| 15 - Lecture 8 Recap And Whats Next.mp4 | 18.9 MB | ||
| 16 - Lecture 8 Study Guide.html | 9.8 KB | ||
| 2 - Lecture 1 Study Guide.html | 35.2 KB |
Practical Sql For Analysts: From Zero To Ctes
https://WebToolTip.com
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 258.79 MB | Duration: 2h 37m
Build, Fill, and Query a Real E-Commerce Database — DDL, DML, JOINs, Subqueries & CTEs. Build a Real Sales Dashboard.
What you'll learn
Design and create database tables using DDL commands (CREATE TABLE, ALTER TABLE, DROP TABLE) with appropriate data types, primary keys, and foreign keys.
Manipulate data safely using INSERT, UPDATE, and DELETE statements, applying the "always use WHERE" rule to avoid catastrophic mistakes.
Read and filter data with SELECT, WHERE, ORDER BY, LIMIT, DISTINCT, and proper handling of NULL values using IS NULL, IS NOT NULL, and COALESCE.
Aggregate data using GROUP BY, HAVING, and aggregate functions (COUNT, SUM, AVG, MIN, MAX), including grouping by date components for time-series analysis.
Combine data from multiple tables using all five JOIN types (INNER, LEFT, RIGHT, FULL OUTER, SELF JOIN) and understand when each is appropriate.
Write subqueries and CTEs (WITH ... AS) to break down complex business questions into readable, maintainable SQL queries.
Build a complete data mart — a monthly_sales_dashboard view that combines all course concepts into a portfolio-ready analytics artifact.
Translate SQL across dialects — recognize syntactic differences between SQLite, PostgreSQL, MySQL, MS SQL Server, and Oracle, and switch between them.
Requirements
No prior SQL experience required — we start from absolute zero.
No programming experience required — SQL is declarative, not procedural.
A modern web browser (Chrome, Firefox, Safari, Edge) — all practice happens in Udemy's built-in coding environment, no installations needed.
Basic computer literacy — file management, copy/paste, web navigation.
English reading comprehension at intermediate level — videos use clear, slow English.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2.6 GB | freecoursewb | 16 hours | 0 | 0 | |
| 3.5 GB | freecoursewb | 16 hours | 0 | 0 | |
| 2.8 GB | freecoursewb | 1 day | 14 | 24 | |
| 1.9 GB | freecoursewb | 1 day | 0 | 0 | |
| 397.7 MB | freecoursewb | 1 week | 4 | 5 |
All Comments