SQL Mastery for Data Analytics and Business Intelligence 1080

23.48 GB | 27min 29s | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English

Files Included :
FileName :1 Course Introduction.mp4 | Size: (31.81 MB)
FileName :3 Course Roadmap & Structure.mp4 | Size: (48.35 MB)
FileName :4 What is SQL and What are Databases.mp4 | Size: (46.81 MB)
FileName :5 The Data Analytics Process with SQL.mp4 | Size: (37.06 MB)
FileName :6 What is DBMS.mp4 | Size: (35.66 MB)
FileName :7 Types of Databases.mp4 | Size: (32.04 MB)
FileName :8 Database Structure.mp4 | Size: (124.54 MB)
FileName :9 SQL Commands.mp4 | Size: (33.65 MB)
FileName :10 Why Learn SQL.mp4 | Size: (12.87 MB)
FileName :11 Environment Setup SQL Server, SSMS and Databases.mp4 | Size: (744.66 MB)
FileName :1 Intro - What is SQL Query.mp4 | Size: (39.33 MB)
FileName :2 Components of SQL.mp4 | Size: (38.93 MB)
FileName :3 SELECT & FROM.mp4 | Size: (130.29 MB)
FileName :4 WHERE.mp4 | Size: (95.72 MB)
FileName :5 ORDER BY.mp4 | Size: (206.99 MB)
FileName :6 GROUP BY.mp4 | Size: (42.42 MB)
FileName :7 HAVING.mp4 | Size: (38.2 MB)
FileName :8 DISTINCT.mp4 | Size: (55.05 MB)
FileName :9 TOP.mp4 | Size: (26.63 MB)
FileName :10 Coding & Execution Order.mp4 | Size: (59.96 MB)
FileName :11 Cool SQL Stuff.mp4 | Size: (104.33 MB)
FileName :1 Intro - What is Data Filtering.mp4 | Size: (22.17 MB)
FileName :2 Comparison Operators.mp4 | Size: (146.24 MB)
FileName :3 AND Operator.mp4 | Size: (69.89 MB)
FileName :4 OR Operator.mp4 | Size: (42.38 MB)
FileName :5 NOT Operator.mp4 | Size: (53.9 MB)
FileName :6 BETWEEN Operator.mp4 | Size: (66.41 MB)
FileName :7 IN Operator.mp4 | Size: (91.88 MB)
FileName :8 LIKE Operator.mp4 | Size: (506.61 MB)
FileName :1 Intro - What is Data Transformation.mp4 | Size: (34.88 MB)
FileName :2 SQL Functions.mp4 | Size: (103.8 MB)
FileName :3 CONCAT.mp4 | Size: (48.32 MB)
FileName :4 UPPER & LOWER.mp4 | Size: (40.25 MB)
FileName :5 TRIM.mp4 | Size: (81.85 MB)
FileName :6 REPLACE.mp4 | Size: (57.73 MB)
FileName :7 LEN.mp4 | Size: (29.91 MB)
FileName :8 LEFT & RIGHT.mp4 | Size: (50.01 MB)
FileName :9 SUBSTRING.mp4 | Size: (95.16 MB)
FileName :10 Number Functions.mp4 | Size: (76.68 MB)
FileName :1 What is Date & Time.mp4 | Size: (116.81 MB)
FileName :2 Overview of Date & Time Functions.mp4 | Size: (38.43 MB)
FileName :3 DAY, MONTH, YEAR.mp4 | Size: (47.05 MB)
FileName :4 DATEPART.mp4 | Size: (91.97 MB)
FileName :5 DATENAME.mp4 | Size: (108.5 MB)
FileName :6 DATETRUNC.mp4 | Size: (119.38 MB)
FileName :7 EOMONTH.mp4 | Size: (57.84 MB)
FileName :8 Use Cases – Date Extraction.mp4 | Size: (80.58 MB)
FileName :9 Comparing Extract Functions.mp4 | Size: (62.09 MB)
FileName :10 Introduction to Formatting & Casting.mp4 | Size: (176.71 MB)
FileName :11 FORMAT.mp4 | Size: (401.29 MB)
FileName :12 CONVERT.mp4 | Size: (106.9 MB)
FileName :13 CAST.mp4 | Size: (78.79 MB)
FileName :14 DATEADD.mp4 | Size: (72.26 MB)
FileName :15 DATEDIFF.mp4 | Size: (140.39 MB)
FileName :16 ISDATE.mp4 | Size: (133.56 MB)
FileName :17 Date & Time Summary.mp4 | Size: (15.51 MB)
FileName :1 Introduction to NULLs.mp4 | Size: (10.89 MB)
FileName :2 COALESCE vs ISNULL.mp4 | Size: (207.91 MB)
FileName :3 Handling NULLs – Data Aggregation.mp4 | Size: (186.47 MB)
FileName :4 Handling NULLs – Mathematical Operations.mp4 | Size: (95.67 MB)
FileName :5 Handling NULLs – Joining Data.mp4 | Size: (36.06 MB)
FileName :6 Handling NULLs – Sorting Data.mp4 | Size: (297.22 MB)
FileName :7 NULLIF.mp4 | Size: (102.62 MB)
FileName :8 IS NULL & IS NOT NULL.mp4 | Size: (278.11 MB)
FileName :9 NULL vs Empty vs Blank.mp4 | Size: (85.32 MB)
FileName :10 Handling NULLs – Data Policies.mp4 | Size: (196.62 MB)
FileName :11 NULL Summary.mp4 | Size: (22.35 MB)
FileName :1 Introduction to CASE Statements.mp4 | Size: (446.86 MB)
FileName :2 Use Case – Categorizing Data.mp4 | Size: (275.81 MB)
FileName :3 CASE Rules.mp4 | Size: (24.35 MB)
FileName :4 Use Case – Mapping Values.mp4 | Size: (43.54 MB)
FileName :5 Use Case – Handling NULLs.mp4 | Size: (142.76 MB)
FileName :6 CASE Statement Summary.mp4 | Size: (21.65 MB)
FileName :1 Intro - What is Combining Data.mp4 | Size: (41.93 MB)
FileName :2 Intro to JOINS.mp4 | Size: (177.93 MB)
FileName :3 NO JOIN.mp4 | Size: (48.23 MB)
FileName :4 INNER JOIN.mp4 | Size: (198.02 MB)
FileName :5 LEFT JOIN.mp4 | Size: (178.81 MB)
FileName :6 RIGHT JOIN.mp4 | Size: (71.2 MB)
FileName :7 FULL JOIN.mp4 | Size: (116.96 MB)
FileName :8 LEFT ANTI JOIN.mp4 | Size: (103.87 MB)
FileName :9 RIGHT ANTI JOIN.mp4 | Size: (96.75 MB)
FileName :10 FULL ANTI JOIN.mp4 | Size: (187.45 MB)
FileName :11 CROSS JOIN.mp4 | Size: (94.82 MB)
FileName :12 Choosing the Right JOIN.mp4 | Size: (17.38 MB)
FileName :13 Multiple Table JOINS.mp4 | Size: (332.71 MB)
FileName :1 Introduction to SET Operators.mp4 | Size: (2.95 MB)
FileName :2 SET Rules & Syntax.mp4 | Size: (254.42 MB)
FileName :3 UNION.mp4 | Size: (125.01 MB)
FileName :4 UNION ALL.mp4 | Size: (120.48 MB)
FileName :5 EXCEPT.mp4 | Size: (123.53 MB)
FileName :6 INTERSECT.mp4 | Size: (79.48 MB)
FileName :7 Use Case Combine Information.mp4 | Size: (302.83 MB)
FileName :8 SET Operators Summary.mp4 | Size: (23.57 MB)
FileName :1 Intro - What is Data Aggregation.mp4 | Size: (48.78 MB)
FileName :2 Aggregate Functions.mp4 | Size: (41.22 MB)
FileName :3 Window Functions vs Group By.mp4 | Size: (299.18 MB)
FileName :4 Syntax of Window Functions.mp4 | Size: (100.54 MB)
FileName :5 Window Partition By.mp4 | Size: (233.82 MB)
FileName :6 Window Order By.mp4 | Size: (39.65 MB)
FileName :7 Window Frame.mp4 | Size: (777.22 MB)
FileName :8 Window Function Rules.mp4 | Size: (129.53 MB)
FileName :9 Window Basic Summary.mp4 | Size: (35.7 MB)
FileName :1 Introduction to Window Aggregate Functions.mp4 | Size: (32.42 MB)
FileName :2 Window COUNT.mp4 | Size: (284.21 MB)
FileName :3 Window SUM.mp4 | Size: (438.04 MB)
FileName :4 Window AVG.mp4 | Size: (154.92 MB)
FileName :5 Window MIN & MAX.mp4 | Size: (231.96 MB)
FileName :6 Use Case Rolling & Running Total.mp4 | Size: (622.16 MB)
FileName :7 Use Case Moving Average.mp4 | Size: (287.33 MB)
FileName :8 Window Aggregate Functions Summary.mp4 | Size: (38.33 MB)
FileName :1 Introduction to Ranking Functions.mp4 | Size: (67.66 MB)
FileName :2 Window ROW NUMBER.mp4 | Size: (116.97 MB)
FileName :3 Window RANK.mp4 | Size: (147.2 MB)
FileName :4 Window DENSE RANK.mp4 | Size: (76.58 MB)
FileName :5 ROW NUMBER vs RANK vs DENSE RANK.mp4 | Size: (19.42 MB)
FileName :6 Use Cases TopBottom N Analysis.mp4 | Size: (126.27 MB)
FileName :7 Use Cases Assign Unique IDs.mp4 | Size: (45.32 MB)
FileName :8 Use Cases Identify Duplicates.mp4 | Size: (160.83 MB)
FileName :9 Window CUME DIST.mp4 | Size: (88.18 MB)
FileName :10 Window PERCENT RANK.mp4 | Size: (136.43 MB)
FileName :11 Window NTILE.mp4 | Size: (216.26 MB)
FileName :12 Window Ranking Function Summary.mp4 | Size: (29 MB)
FileName :1 Introduction to Window Value Functions.mp4 | Size: (58.78 MB)
FileName :2 Window Lead & Lag.mp4 | Size: (576.76 MB)
FileName :3 Use Case Month-Over-Month (MoM).mp4 | Size: (113.03 MB)
FileName :4 Use Case Customer Retention.mp4 | Size: (143.5 MB)
FileName :5 Use Case Time Gap Analysis.mp4 | Size: (126.03 MB)
FileName :6 Window FIRST & LAST.mp4 | Size: (310.95 MB)
FileName :7 Window Value Functions Summary.mp4 | Size: (35.75 MB)
FileName :1 Intro - Advanced SQL Topics.mp4 | Size: (6.98 MB)
FileName :2 Challenges in Complex Projects.mp4 | Size: (471.77 MB)
FileName :3 What is Subquery.mp4 | Size: (29.15 MB)
FileName :4 Why Subquery.mp4 | Size: (27.63 MB)
FileName :5 Subquery Categories.mp4 | Size: (38.49 MB)
FileName :6 Subquery Result Types.mp4 | Size: (38.68 MB)
FileName :7 Subquery in FROM.mp4 | Size: (153.64 MB)
FileName :8 How DB Executes Subquery.mp4 | Size: (25.52 MB)
FileName :9 Subquery in SELECT.mp4 | Size: (108.31 MB)
FileName :10 Subquery in JOIN.mp4 | Size: (69.7 MB)
FileName :11 Subquery in WHERE.mp4 | Size: (188.86 MB)
FileName :12 Subquery using IN Operator.mp4 | Size: (230.01 MB)
FileName :13 Subquery using ALL & ANY Operators.mp4 | Size: (154.65 MB)
FileName :14 Correlated Subquery.mp4 | Size: (132.26 MB)
FileName :15 Subquery using Exists.mp4 | Size: (260.09 MB)
FileName :16 Subquery Summary.mp4 | Size: (20.26 MB)
FileName :1 Introduction to CTE.mp4 | Size: (74.88 MB)
FileName :2 Why CTE.mp4 | Size: (85.77 MB)
FileName :3 How DB Executes CTE.mp4 | Size: (28.84 MB)
FileName :4 CTE Types.mp4 | Size: (10.55 MB)
FileName :5 Standalone CTE.mp4 | Size: (125.31 MB)
FileName :6 Multiple Standalone CTE.mp4 | Size: (58.27 MB)
FileName :7 Nested CTE.mp4 | Size: (293.09 MB)
FileName :8 CTE Best Practices.mp4 | Size: (90.18 MB)
FileName :9 Recursive CTE.mp4 | Size: (784.91 MB)
FileName :10 CTE Summary.mp4 | Size: (31.24 MB)
FileName :1 Introduction to EDA Project.mp4 | Size: (12.14 MB)
FileName :3 Get Project Resources.mp4 | Size: (132.57 MB)
FileName :4 Data Analytics Project Roadmap.mp4 | Size: (14.8 MB)
FileName :5 Dimensions vs Measures.mp4 | Size: (163.51 MB)
FileName :6 Database Exploration.mp4 | Size: (97.27 MB)
FileName :7 Dimensions Exploration.mp4 | Size: (118.54 MB)
FileName :8 Date Exploration.mp4 | Size: (118.38 MB)
FileName :9 Measure Exploration.mp4 | Size: (196.64 MB)
FileName :10 Magnitude Analysis.mp4 | Size: (518.42 MB)
FileName :11 Ranking Analysis.mp4 | Size: (171.08 MB)
FileName :1 Introduction to SQL Advanced Analytics.mp4 | Size: (4.78 MB)
FileName :2 Change Over Time Analysis.mp4 | Size: (168.99 MB)
FileName :3 Cumulative Analysis.mp4 | Size: (355.08 MB)
FileName :4 Performance Analysis.mp4 | Size: (184.9 MB)
FileName :5 Part to Whole Analysis.mp4 | Size: (197.94 MB)
FileName :6 Data Segmentation.mp4 | Size: (237.01 MB)
FileName :7 Build Customers Report.mp4 | Size: (470.06 MB)
FileName :8 Build Products Report.mp4 | Size: (55.48 MB)
FileName :9 Document Your Work in GIT.mp4 | Size: (14.47 MB)
FileName :1 Congratulations & THANK YOU.mp4 | Size: (37.7 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