https://img100.pixhost.to/images/617/539499712_359020115_tuto.jpg
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://i.postimg.cc/y1dTF6k1/10-Installing-Postgre-SQL-pg-Admin-Dataset-Setup-for-Windows.jpg


Код:
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