Complete SQL in 10 Days Data Analysis Bootcamp— Zero to Hero

8.75 GB | 16min 33s | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English

Files Included :
FileName :1 Welcome to the Course.mp4 | Size: (64.09 MB)
FileName :2 How to Get the Most Out of This Course.mp4 | Size: (37.09 MB)
FileName :3 Course Structure & 10-Day Roadmap.mp4 | Size: (26.32 MB)
FileName :4 How Coding Exercises and Role Play Work.mp4 | Size: (27.84 MB)
FileName :6 How Databases Power the Real World.mp4 | Size: (76.9 MB)
FileName :7 What is SQL — The Language Behind Every Database.mp4 | Size: (82.63 MB)
FileName :8 SQL Environments — PostgreSQL vs MySQL vs SQL Server vs SQLite.mp4 | Size: (51.49 MB)
FileName :9 Databases, Tables & Relationships — 5-Minute Crash Course.mp4 | Size: (51 MB)
FileName :10 Installing PostgreSQL + pgAdmin + Dataset Setup for Windows.mp4 | Size: (197.1 MB)
FileName :11 Exploring the Course Dataset.mp4 | Size: (104.12 MB)
FileName :12 Your First SQL Query SELECT & FROM.mp4 | Size: (59.36 MB)
FileName :13 Column Aliases with AS.mp4 | Size: (69.43 MB)
FileName :14 SELECT DISTINCT — Removing Duplicates.mp4 | Size: (37.81 MB)
FileName :15 LIMIT — Controlling Result Size.mp4 | Size: (58.39 MB)
FileName :16 ORDER BY — Sorting Your Results.mp4 | Size: (32.62 MB)
FileName :17 ORDER BY Multiple Columns & Direction.mp4 | Size: (54.93 MB)
FileName :18 SQL Query Execution Order.mp4 | Size: (35.69 MB)
FileName :19 The WHERE Clause — Introduction.mp4 | Size: (33.32 MB)
FileName :20 The WHERE Clause — Practical.mp4 | Size: (56.37 MB)
FileName :21 Comparison Operators (=, !=, , , =, =).mp4 | Size: (78.85 MB)
FileName :22 AND Operator.mp4 | Size: (38 MB)
FileName :23 OR Operator.mp4 | Size: (42.46 MB)
FileName :24 NOT Operator.mp4 | Size: (35.85 MB)
FileName :25 Combining AND, OR & NOT — Operator Precedence.mp4 | Size: (38.85 MB)
FileName :26 Combining AND, OR & NOT — Practical.mp4 | Size: (41.67 MB)
FileName :27 BETWEEN Operator.mp4 | Size: (63.78 MB)
FileName :28 IN Operator.mp4 | Size: (70.94 MB)
FileName :29 LIKE & ILIKE — Wildcards & Case-Insensitive Matching.mp4 | Size: (47.45 MB)
FileName :30 LIKE & ILIKE — Wildcards & Case-Insensitive Matching - Practical.mp4 | Size: (45.89 MB)
FileName :31 IS NULL & IS NOT NULL.mp4 | Size: (67.39 MB)
FileName :32 Filtering Best Practices + Writing Readable SQL.mp4 | Size: (28.02 MB)
FileName :33 SQL Comments & Code Formatting.mp4 | Size: (111.72 MB)
FileName :34 What Are Aggregate Functions.mp4 | Size: (20.77 MB)
FileName :35 COUNT() — Counting Rows & Values.mp4 | Size: (55.48 MB)
FileName :36 SUM() — Totalling Values.mp4 | Size: (57.13 MB)
FileName :37 AVG() — Calculating Averages.mp4 | Size: (60.94 MB)
FileName :38 MIN() & MAX() — Finding Extremes.mp4 | Size: (56.17 MB)
FileName :39 Combining Multiple Aggregates — Real Business Queries.mp4 | Size: (40.16 MB)
FileName :40 GROUP BY — Grouping & Summarising Data.mp4 | Size: (82.1 MB)
FileName :41 GROUP BY Multiple Columns.mp4 | Size: (75.91 MB)
FileName :42 HAVING — Filtering Aggregated Results.mp4 | Size: (47.94 MB)
FileName :43 HAVING vs WHERE — The Critical Difference.mp4 | Size: (43.38 MB)
FileName :44 What Is CASE WHEN.mp4 | Size: (38.79 MB)
FileName :45 Simple CASE WHEN Syntax.mp4 | Size: (61.39 MB)
FileName :46 Searched CASE WHEN.mp4 | Size: (107.02 MB)
FileName :47 CASE WHEN with Aggregate Functions.mp4 | Size: (125.43 MB)
FileName :48 Bucketing & Categorisation with CASE WHEN.mp4 | Size: (84.41 MB)
FileName :49 CASE WHEN in ORDER BY.mp4 | Size: (85.66 MB)
FileName :50 Introduction to String Functions.mp4 | Size: (12.39 MB)
FileName :51 UPPER(), LOWER(), LENGTH() & TRIM().mp4 | Size: (110.47 MB)
FileName :52 CONCAT() & the Operator.mp4 | Size: (90.9 MB)
FileName :53 SUBSTRING(), LEFT() & RIGHT().mp4 | Size: (104.76 MB)
FileName :54 REPLACE(), POSITION() & SPLIT PART().mp4 | Size: (130.02 MB)
FileName :55 Combining String Functions — Real Data Cleaning.mp4 | Size: (67.25 MB)
FileName :56 Understanding Date & Time Data Types.mp4 | Size: (22.74 MB)
FileName :57 NOW(), CURRENT DATE & CURRENT TIME.mp4 | Size: (64.36 MB)
FileName :58 EXTRACT() & DATE PART() — Pulling Out Date Components.mp4 | Size: (67.68 MB)
FileName :59 TO CHAR() — Formatting Dates for Reports.mp4 | Size: (67.67 MB)
FileName :60 Date Arithmetic with INTERVAL.mp4 | Size: (76.02 MB)
FileName :61 AGE() & Date Subtraction — Calculating Differences.mp4 | Size: (72.52 MB)
FileName :62 Understanding NULL — What It Really Means.mp4 | Size: (16.92 MB)
FileName :63 COALESCE() — Replacing NULLs Intelligently.mp4 | Size: (74.8 MB)
FileName :64 COALESCE vs Dialect Variants (IFNULL, ISNULL, NVL).mp4 | Size: (17.01 MB)
FileName :65 NULLIF() — Converting Values to NULL.mp4 | Size: (67.37 MB)
FileName :66 What Are JOINs Concept + Dataset Relationships.mp4 | Size: (36.8 MB)
FileName :67 INNER JOIN — Theory & Practice.mp4 | Size: (114.69 MB)
FileName :68 INNER JOIN — Real Business Queries.mp4 | Size: (148.3 MB)
FileName :69 LEFT JOIN — Theory & Practice.mp4 | Size: (111.76 MB)
FileName :70 LEFT ANTI JOIN — Finding Non-Matching Records.mp4 | Size: (92.63 MB)
FileName :71 INNER vs LEFT JOIN — When to Use Which.mp4 | Size: (22.15 MB)
FileName :72 Many-to-Many Relationships — Concept & Bridge Tables.mp4 | Size: (18.98 MB)
FileName :73 RIGHT JOIN.mp4 | Size: (64.55 MB)
FileName :74 FULL OUTER JOIN — Native PostgreSQL Support.mp4 | Size: (76.55 MB)
FileName :75 RIGHT ANTI JOIN.mp4 | Size: (51.64 MB)
FileName :76 CROSS JOIN.mp4 | Size: (89.73 MB)
FileName :77 Joining 3+ Tables Together.mp4 | Size: (106.44 MB)
FileName :78 JOINs on Multiple Conditions + JOIN Decision Guide.mp4 | Size: (83.96 MB)
FileName :79 What Are SET Operators.mp4 | Size: (17.3 MB)
FileName :80 UNION — Combining Result Sets.mp4 | Size: (77.78 MB)
FileName :81 UNION ALL — Keeping Duplicates.mp4 | Size: (81.95 MB)
FileName :82 INTERSECT — Finding Common Records.mp4 | Size: (49.9 MB)
FileName :83 EXCEPT — Finding Differences.mp4 | Size: (42.04 MB)
FileName :84 What Is a Subquery Types & When to Use.mp4 | Size: (24.95 MB)
FileName :85 Subquery in WHERE — Single & Multiple Values.mp4 | Size: (79.15 MB)
FileName :86 Subquery in FROM — Derived Tables.mp4 | Size: (68.58 MB)
FileName :87 Subquery in SELECT — Scalar Subqueries.mp4 | Size: (67.36 MB)
FileName :88 Correlated Subqueries.mp4 | Size: (102.76 MB)
FileName :89 EXISTS & NOT EXISTS.mp4 | Size: (49.85 MB)
FileName :90 Subquery vs JOIN.mp4 | Size: (40.28 MB)
FileName :91 What Is a CTE and Why Use It.mp4 | Size: (17.94 MB)
FileName :92 Basic CTE Syntax — WITH Clause.mp4 | Size: (97.85 MB)
FileName :93 CTE vs Subquery — Key Differences.mp4 | Size: (82.32 MB)
FileName :94 Multiple CTEs in One Query.mp4 | Size: (80.33 MB)
FileName :95 CTE with Aggregates & Filtering.mp4 | Size: (104.55 MB)
FileName :96 Recursive CTEs — Theory & Concept.mp4 | Size: (22.2 MB)
FileName :97 Recursive CTE — Building a Date Series with generate series().mp4 | Size: (61.44 MB)
FileName :98 Recursive CTE — Hierarchy Traversal (Employee Tree).mp4 | Size: (128.14 MB)
FileName :99 CTE vs Subquery vs Temp Table vs View — Full Comparison.mp4 | Size: (31.59 MB)
FileName :100 What Are Window Functions (vs Aggregate Functions).mp4 | Size: (16.29 MB)
FileName :101 OVER() Clause — The Heart of Window Functions.mp4 | Size: (65.1 MB)
FileName :102 PARTITION BY — Segmenting Your Window.mp4 | Size: (98.64 MB)
FileName :103 ORDER BY Inside OVER().mp4 | Size: (56.24 MB)
FileName :104 ROW NUMBER() — Unique Row Ranking.mp4 | Size: (95.17 MB)
FileName :105 RANK() & DENSE RANK() — Ranking with & without Gaps.mp4 | Size: (102.31 MB)
FileName :106 LAG() & LEAD() — Accessing Previous & Next Rows.mp4 | Size: (125.88 MB)
FileName :107 Moving Averages with AVG() OVER().mp4 | Size: (138.4 MB)
FileName :108 FIRST VALUE(), LAST VALUE() & NTILE().mp4 | Size: (141.25 MB)
FileName :109 PostgreSQL Data Types Overview — Choosing the Right Type.mp4 | Size: (17.81 MB)
FileName :110 Integer Types — SMALLINT, INT, BIGINT & SERIAL.mp4 | Size: (30.83 MB)
FileName :111 NUMERIC vs REAL vs DOUBLE PRECISION — Precision Matters.mp4 | Size: (62.94 MB)
FileName :112 CHAR vs VARCHAR vs TEXT — The PostgreSQL Way.mp4 | Size: (51.83 MB)
FileName :113 DATE, TIME, TIMESTAMP vs TIMESTAMPTZ — Which to Use.mp4 | Size: (69.93 MB)
FileName :114 Bonus Types — BOOLEAN, ENUM, UUID & JSON (Overview).mp4 | Size: (30.8 MB)
FileName :115 CREATE DATABASE — Setting Up Your Workspace.mp4 | Size: (33.55 MB)
FileName :116 CREATE TABLE + NOT NULL & DEFAULT Values.mp4 | Size: (152.63 MB)
FileName :117 PRIMARY KEY, SERIAL IDENTITY & UNIQUE Constraint.mp4 | Size: (77.48 MB)
FileName :118 CHECK Constraints — Enforcing Data Rules.mp4 | Size: (51.34 MB)
FileName :119 FOREIGN KEY Constraints & Referential Integrity.mp4 | Size: (82.47 MB)
FileName :120 ON DELETE CASCADE — Automatic Cascade Deletion.mp4 | Size: (113.8 MB)
FileName :121 DEFAULT NOW() Auto-Timestamps + ALTER TABLE.mp4 | Size: (72.26 MB)
FileName :122 Why User Management Matters — Database Security Basics.mp4 | Size: (13.9 MB)
FileName :123 CREATE USER CREATE ROLE — Adding Database Users.mp4 | Size: (66.43 MB)
FileName :124 GRANT — Giving Table & Schema Privileges.mp4 | Size: (64.57 MB)
FileName :125 REVOKE — Removing Privileges.mp4 | Size: (47.55 MB)
FileName :126 Roles & Group Privileges — Managing Access at Scale.mp4 | Size: (40.51 MB)
FileName :127 INSERT INTO SELECT — Copying Data Between Tables.mp4 | Size: (54.97 MB)
FileName :128 UPDATE — Modifying Existing Records.mp4 | Size: (60.23 MB)
FileName :129 DELETE + Safe DML Practices + DELETE vs TRUNCATE.mp4 | Size: (84.43 MB)
FileName :130 Views — CREATE, USE, DROP & REPLACE.mp4 | Size: (103.04 MB)
FileName :131 Materialized Views — A PostgreSQL Superpower.mp4 | Size: (89.28 MB)
FileName :132 Indexes — What They Are & When to Use Them.mp4 | Size: (55.85 MB)
FileName :133 Final Project Introduction & Dataset Overview.mp4 | Size: (15.09 MB)
FileName :134 Final Project Part 1 — Sales & Customer Analysis.mp4 | Size: (140.99 MB)
FileName :135 BONUS - Final Project Part 2 — Rankings, Trends + Solutions + Wrap-Up.mp4 | Size: (100.88 MB)]
Screenshot

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm