
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 W***se 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 W***ser 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
https://rapidgator.net/file/4f62f4de6feef8f73de31a8aa29e8529/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part01.rar https://rapidgator.net/file/2cff1f5ecddbe07a1b4c90b22380ee32/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part02.rar https://rapidgator.net/file/0632bc62778f9f164a02051e52004486/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part03.rar https://rapidgator.net/file/cb4d729ede2a26e237f9e1cba739fc04/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part04.rar https://rapidgator.net/file/d322ce6906f9f203a8a4518f93f5e649/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part05.rar https://rapidgator.net/file/47d1422bfa65e3383f417c4e8fa5be82/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part06.rar https://rapidgator.net/file/9c84cec38deb3bd7d15657f1a57fb9cb/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part07.rar https://rapidgator.net/file/0391c23df5df997a535c45a66aeff9b4/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part08.rar https://rapidgator.net/file/32fd92ad07fb0f39f5ca536b3245c1ea/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part09.rar https://rapidgator.net/file/854f7b4958a0bc103e77abcfbd9d7ffd/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part10.rar
DDownload
https://ddownload.com/418vb8qs2bpm/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part01.rar https://ddownload.com/38iu52ob8m9n/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part02.rar https://ddownload.com/zhps7lwr5a5q/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part03.rar https://ddownload.com/cwj8s3m8qfw2/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part04.rar https://ddownload.com/cxcge8ifmwzu/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part05.rar https://ddownload.com/vv7jdcy9wgfn/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part06.rar https://ddownload.com/1f4h1qzqcful/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part07.rar https://ddownload.com/aefk5vaooszm/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part08.rar https://ddownload.com/gqaa07ror3e3/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part09.rar https://ddownload.com/zf01dqdizioo/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part10.rar
NitroFlare
https://nitroflare.com/view/02245962B1615D5/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part01.rar https://nitroflare.com/view/49FCB22629357BD/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part02.rar https://nitroflare.com/view/A7EFCC27E0A7A04/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part03.rar https://nitroflare.com/view/7E770484AEA6620/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part04.rar https://nitroflare.com/view/5A4DC124300D66E/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part05.rar https://nitroflare.com/view/BA27F13F4B05B2A/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part06.rar https://nitroflare.com/view/A5203271422F37A/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part07.rar https://nitroflare.com/view/AC1BF135C15E741/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part08.rar https://nitroflare.com/view/C6105D9EAB3BA70/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part09.rar https://nitroflare.com/view/ECDF68033787927/Complete.SQL.in.10.Days.Data.Analysis.Bootcamp-.Zero.to.Hero.part10.rar
UsersDrive
