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


Complete SQL in 10 Days Data Analysis Bootcamp- Zero to Hero
8.75 GB | 16min 33s | mp4 | 1920X1080 | 16:9

Files Included :
Spoiler:
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 :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 :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 :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 :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)
Screenshot

Importantissimo!

Per NON SBAGLIARE link e finire su qualche possibile clone, approfittare di offerte esclusive personalizzate per il nostro sito, e se gradisce questo articolo ed il nostro lavoro, la preghiamo di supportarci rinnovando o sottoscrivendo un Account Premium su FILESTORE cliccando sul link qui sotto:

FileStore

Share This Post!

Torna in cima