Udemy - The Complete SQL Bootcamp (30 Hours) Go from Zero to Hero (6.2025)
    
    File List
    
        
            
                
                    - 24. Copilot & ChatGPT for SQL/6. ChatGPT Prompts for SQL Developers.mp4  434.5 MB
- 17. Common Table Expression (CTE)/9. Recursive CTE.mp4  429.6 MB
- 21. Indexes/21. Execution Plan.mp4  382.6 MB
- 25. SQL Data Warehouse Project/24. Silver Layer Load Script 2.mp4  292.1 MB
- 13. Window Aggregate Functions/2. Window COUNT.mp4  283.1 MB
- 25. SQL Data Warehouse Project/26. Silver Layer Load Script 4.mp4  278.5 MB
- 22. Partitions/2. The Process of Partitions.mp4  257.7 MB
- 27. SQL Advanced Data Analytics Project/7. Build Customers Report.mp4  256.9 MB
- 16. Subqueries/1. Challenges in Complex Projects.mp4  250.2 MB
- 25. SQL Data Warehouse Project/31. Gold Layer Build Dimension Customers.mp4  246.0 MB
- 27. SQL Advanced Data Analytics Project/6. Data Segmentation.mp4  239.7 MB
- 18. Views/7. CREATE, ALTER, DROP Views.mp4  237.4 MB
- 25. SQL Data Warehouse Project/25. Silver Layer Load Script 3.mp4  233.3 MB
- 04. Data Manipulation (DML)/1. INSERT.mp4  224.5 MB
- 12. Window Functions Basics/6. Window Frame.mp4  222.9 MB
- 14. Window Ranking Functions/11. Window NTILE.mp4  214.9 MB
- 15. Window Value Functions/5. Window FIRST & LAST.mp4  211.4 MB
- 17. Common Table Expression (CTE)/7. Nested CTE.mp4  210.4 MB
- 21. Indexes/16. Monitor Usage.mp4  208.1 MB
- 09. Date & Time Functions/12. FORMAT.mp4  206.5 MB
- 25. SQL Data Warehouse Project/23. Silver Layer Load Script 1.mp4  205.8 MB
- 12. Window Functions Basics/2. Window Functions vs Group By.mp4  204.9 MB
- 10. NULL Functions/2. COALESC vs ISNULL.mp4  204.0 MB
- 24. Copilot & ChatGPT for SQL/7. ChatGPT Prompts for SQL Learning.mp4  197.2 MB
- 25. SQL Data Warehouse Project/21. Silver Layer Exploring Data.mp4  195.7 MB
- 06. SQL Joins/3. INNER JOIN.mp4  189.0 MB
- 01. Introduction to SQL/9. Setup & Install SQL Server, SSMS & Databases.mp4  187.8 MB
- 16. Subqueries/14. Subquery using Exists.mp4  184.2 MB
- 25. SQL Data Warehouse Project/19. Bronze Layer Build Stored Procedure.mp4  183.5 MB
- 27. SQL Advanced Data Analytics Project/4. Performance Analysis.mp4  182.0 MB
- 07. SQL SET Operators/2. SET Rules & Syntax.mp4  179.1 MB
- 13. Window Aggregate Functions/6. Use Case Rolling & Running Total.mp4  178.2 MB
- 06. SQL Joins/12. Multiple Table Joins.mp4  178.1 MB
- 23. Performance Best Practices/9. Performance Tipcs Summary.mp4  166.6 MB
- 23. Performance Best Practices/4. Performance Tips for Joining.mp4  166.6 MB
- 12. Window Functions Basics/4. Window Partition By.mp4  162.2 MB
- 09. Date & Time Functions/16. DATEDIFF.mp4  159.8 MB
- 07. SQL SET Operators/7. Use Case Combine Information.mp4  158.9 MB
- 25. SQL Data Warehouse Project/11. Draw DWH Architecture.mp4  158.6 MB
- 15. Window Value Functions/2. Window MIN & MAX.mp4  157.6 MB
- 16. Subqueries/6. Subquery in FROM.mp4  156.0 MB
- 13. Window Aggregate Functions/5. Window MIN & MAX.mp4  155.6 MB
- 13. Window Aggregate Functions/4. Window AVG.mp4  154.4 MB
- 21. Indexes/12. How to Create Coluimnstore Index.mp4  153.8 MB
- 11. CASE WHEN Statement/5. Use Case Handling Nulls.mp4  153.6 MB
- 18. Views/9. Use Case Hide Complexity.mp4  152.4 MB
- 26. Exploratory Data Analysis Project/9. Magnitude Analysis.mp4  150.4 MB
- 15. Window Value Functions/4. Use Case Customer Retention.mp4  150.2 MB
- 05. Filtering Data/1. Comparison operators.mp4  147.3 MB
- 05. Filtering Data/7. LIKE Operators.mp4  147.2 MB
- 11. CASE WHEN Statement/4. Use Case Mapping Values.mp4  147.0 MB
- 21. Indexes/7. How to Create INDEX.mp4  146.9 MB
- 13. Window Aggregate Functions/7. Use Case Moving Average.mp4  146.0 MB
- 10. NULL Functions/8. IS NULL & IS NOT NULL.mp4  144.7 MB
- 20. Stored Procedures/1. Introduction to Stored Procedures.mp4  138.4 MB
- 16. Subqueries/13. Correlated Subquery.mp4  136.4 MB
- 26. Exploratory Data Analysis Project/8. Measure Exploration.mp4  136.2 MB
- 14. Window Ranking Functions/10. Window PERCENT_RANK.mp4  135.9 MB
- 10. NULL Functions/10. Handling NULL Data Policies.mp4  135.7 MB
- 20. Stored Procedures/10. Triggers Use Case.mp4  135.0 MB
- 02. SELECT Query/5. ORDER BY.mp4  134.4 MB
- 25. SQL Data Warehouse Project/5. ETL Methods.mp4  133.1 MB
- 12. Window Functions Basics/7. Window Function Rules.mp4  132.9 MB
- 17. Common Table Expression (CTE)/6. Multiple Standalone CTE.mp4  132.4 MB
- 21. Indexes/19. Update Statistics.mp4  131.0 MB
- 17. Common Table Expression (CTE)/5. Standalone CTE.mp4  129.8 MB
- 02. SELECT Query/3. SELECT & FROM.mp4  129.3 MB
- 14. Window Ranking Functions/6. Use Cases TopBottom N Analysis.mp4  126.2 MB
- 16. Subqueries/11. Subquery using IN Operator.mp4  126.0 MB
- 13. Window Aggregate Functions/3. Window SUM.mp4  125.6 MB
- 11. CASE WHEN Statement/1. Introduction to CAST Statements.mp4  124.9 MB
- 26. Exploratory Data Analysis Project/10. Ranking Analysis.mp4  120.1 MB
- 27. SQL Advanced Data Analytics Project/2. Change Over Time Analysis.mp4  119.5 MB
- 02. SELECT Query/6. GROUP BY.mp4  119.3 MB
- 09. Date & Time Functions/7. DATETRUNC.mp4  118.8 MB
- 06. SQL Joins/1. Introduction to JOINs.mp4  117.7 MB
- 19. CTAS & TEMP Tables/15. Compare All Methods.mp4  117.5 MB
- 15. Window Value Functions/3. Use Case Month-Over-Month (MoM).mp4  117.4 MB
- 06. SQL Joins/4. LEFT JOIN.mp4  116.7 MB
- 21. Indexes/6. Clustered vs NonClustered Index.mp4  116.6 MB
- 25. SQL Data Warehouse Project/18. Bronze Layer Load Scripts.mp4  115.0 MB
- 25. SQL Data Warehouse Project/29. Gold Layer Data Modelling.mp4  114.1 MB
- 10. NULL Functions/5. Handling NULL Joining Data.mp4  113.9 MB
- 25. SQL Data Warehouse Project/7. Notion for Project Management.mp4  113.5 MB
- 16. Subqueries/8. Subquery in SELECT.mp4  111.2 MB
- 22. Partitions/3. Create Partitioned Tables.mp4  110.9 MB
- 16. Subqueries/12. Subquery using ALL & ANY Operators.mp4  110.1 MB
- 03. Data Definition (DDL)/1. CREATE.mp4  109.7 MB
- 21. Indexes/11. Columnstore vs Rowstore Index.mp4  109.1 MB
- 20. Stored Procedures/5. Variables.mp4  108.7 MB
- 04. Data Manipulation (DML)/2. UPDATE.mp4  108.5 MB
- 25. SQL Data Warehouse Project/9. Data Architecture Approaches.mp4  108.3 MB
- 09. Date & Time Functions/13. CONVERT.mp4  106.6 MB
- 02. SELECT Query/7. HAVING.mp4  106.2 MB
- 27. SQL Advanced Data Analytics Project/5. Part to Whole Analysis.mp4  106.2 MB
- 25. SQL Data Warehouse Project/10. Design the Data Warehouse Layers.mp4  106.1 MB
- 27. SQL Advanced Data Analytics Project/3. Cumulative Analysis.mp4  105.7 MB
- 20. Stored Procedures/6. Control Flow IF ELSE.mp4  105.3 MB
- 21. Indexes/3. Heap Structure.mp4  102.8 MB
- 01. Introduction to SQL/2. sql-ultimate-course.zip  101.8 MB
- 16. Subqueries/10. Subquery in WHERE.mp4  101.5 MB
- 25. SQL Data Warehouse Project/13. Define The Naming Conventions.mp4  101.2 MB
- 20. Stored Procedures/3. Parameters.mp4  100.8 MB
- 08. String Functions/8. SUBSTRING.mp4  100.7 MB
- 19. CTAS & TEMP Tables/10. TEMP Syntax & Example.mp4  100.4 MB
- 10. NULL Functions/7. NULLIF.mp4  100.0 MB
- 12. Window Functions Basics/1. Aggregate Functions.mp4  99.0 MB
- 25. SQL Data Warehouse Project/32. Gold Layer Build Dimension Products.mp4  99.0 MB
- 23. Performance Best Practices/7. Performance Tips for Table DDL.mp4  98.8 MB
- 18. Views/10. Use Case Data Security.mp4  98.5 MB
- 21. Indexes/22. SQL hints.mp4  98.2 MB
- 21. Indexes/20. Fragmentations.mp4  97.3 MB
- 06. SQL Joins/9. FULL ANTI JOIN.mp4  96.8 MB
- 10. NULL Functions/4. Handling NULL Mathematic Operations.mp4  96.7 MB
- 25. SQL Data Warehouse Project/36. Gold Layer Document The Work.mp4  96.2 MB
- 21. Indexes/10. Process of Building Columnstore Index.mp4  95.9 MB
- 11. CASE WHEN Statement/2. Use Case Categorizing Data.mp4  93.9 MB
- 25. SQL Data Warehouse Project/34. Gold Layer Draw The Data Model.mp4  93.1 MB
- 21. Indexes/14. Filter Index.mp4  92.9 MB
- 24. Copilot & ChatGPT for SQL/4. How to Use Copilot.mp4  92.5 MB
- 02. SELECT Query/4. WHERE.mp4  92.1 MB
- 25. SQL Data Warehouse Project/3. Intro to Data Warehouse (DWH).mp4  90.9 MB
- 21. Indexes/13. Unique Index.mp4  90.6 MB
- 25. SQL Data Warehouse Project/27. Silver Layer Build Stored Procedure.mp4  90.5 MB
- 09. Date & Time Functions/5. DATEPART.mp4  90.0 MB
- 09. Date & Time Functions/11. Intro to Formatting & Casting.mp4  89.6 MB
- 10. NULL Functions/6. Handling NULL Sorting Data.mp4  89.6 MB
- 25. SQL Data Warehouse Project/20. Bronze Layer Document The Work.mp4  89.4 MB
- 25. SQL Data Warehouse Project/17. Bronze Layer DDL Create Tables.mp4  88.7 MB
- 25. SQL Data Warehouse Project/16. Bronze Layer Analyze Source Systems.mp4  88.3 MB
- 17. Common Table Expression (CTE)/2. Why CTE.mp4  87.2 MB
- 21. Indexes/8. Composite Index.mp4  87.1 MB
- 21. Indexes/4. Clustered Index.mp4  86.6 MB
- 10. NULL Functions/9. NULL vs Empty vs Blank.mp4  85.7 MB
- 14. Window Ranking Functions/9. Window CUME_DIST.mp4  84.7 MB
- 07. SQL SET Operators/3. UNION.mp4  84.4 MB
- 20. Stored Procedures/7. Error Handling TRY & CATCH.mp4  84.0 MB
- 02. SELECT Query/9. TOP.mp4  83.8 MB
- 14. Window Ranking Functions/8. Use Cases Identify Duplicates.mp4  83.8 MB
- 08. String Functions/4. TRIM.mp4  83.4 MB
- 07. SQL SET Operators/5. EXCEPT.mp4  83.2 MB
- 26. Exploratory Data Analysis Project/7. Date Exploration.mp4  83.2 MB
- 25. SQL Data Warehouse Project/15. Create The Database.mp4  82.2 MB
- 26. Exploratory Data Analysis Project/4. Dimensions vs Measures.mp4  82.1 MB
- 18. Views/1. Database Structure & Views.mp4  81.6 MB
- 25. SQL Data Warehouse Project/33. Gold Layer Build Fact Sales.mp4  81.1 MB
- 19. CTAS & TEMP Tables/3. CTAS vs Views.mp4  79.5 MB
- 09. Date & Time Functions/9. Use Cases Date Extraction.mp4  78.4 MB
- 14. Window Ranking Functions/2. Window ROW_NUMBER.mp4  78.3 MB
- 09. Date & Time Functions/14. CAST.mp4  78.1 MB
- 06. SQL Joins/6. FULL JOIN.mp4  76.4 MB
- 14. Window Ranking Functions/4. Window DENSE_RANK.mp4  76.4 MB
- 02. SELECT Query/11. Cool SQL Stuff.mp4  76.0 MB
- 24. Copilot & ChatGPT for SQL/3. ChatGPT vs Copliot.mp4  74.7 MB
- 17. Common Table Expression (CTE)/1. Introduction to CTE.mp4  74.2 MB
- 23. Performance Best Practices/6. Performance Tips for Subquiers.mp4  74.1 MB
- 16. Subqueries/9. Subquery in JOIN.mp4  73.7 MB
- 04. Data Manipulation (DML)/3. DELETE.mp4  73.4 MB
- 23. Performance Best Practices/3. Performance Tips for Filtering.mp4  73.0 MB
- 09. Date & Time Functions/6. DATENAME.mp4  72.9 MB
- 14. Window Ranking Functions/3. Window RANK.mp4  72.7 MB
- 07. SQL SET Operators/8. Use Case Delta Detection.mp4  72.4 MB
- 25. SQL Data Warehouse Project/30. Gold Layer Analysis.mp4  72.3 MB
- 09. Date & Time Functions/15. DATEADD.mp4  72.0 MB
- 25. SQL Data Warehouse Project/14. Prepare Your GIT Repo.mp4  70.6 MB
- 06. SQL Joins/5. RIGHT JOIN.mp4  70.1 MB
- 08. String Functions/1. Introduction to SQL Functions.mp4  69.5 MB
- 12. Window Functions Basics/3. Syntax of Window Functions.mp4  69.3 MB
- 05. Filtering Data/2. AND Operator.mp4  69.1 MB
- 12. Window Functions Basics/5. Window Order By.mp4  68.3 MB
- 21. Indexes/5. NonClustered Index.mp4  67.7 MB
- 20. Stored Procedures/2. Basics of Stored Procedures.mp4  67.4 MB
- 25. SQL Data Warehouse Project/4. What is ETL.mp4  65.9 MB
- 14. Window Ranking Functions/1. Introduction to Ranking Functions.mp4  65.9 MB
- 05. Filtering Data/5. BETWEEN Operator.mp4  65.7 MB
- 06. SQL Joins/8. RIGHT ANTI JOIN.mp4  65.4 MB
- 26. Exploratory Data Analysis Project/3. Get Project Resources.mp4  64.3 MB
- 18. Views/13. Use Case Data Warehouse.mp4  63.1 MB
- 09. Date & Time Functions/10. Compare Extract Functions.mp4  62.7 MB
- 07. SQL SET Operators/4. UNION ALL.mp4  61.9 MB
- 05. Filtering Data/6. IN Operator.mp4  61.7 MB
- 24. Copilot & ChatGPT for SQL/5. ChatGPT Prompt Structure.mp4  61.3 MB
- 25. SQL Data Warehouse Project/28. Silver Layer Document The Work.mp4  60.7 MB
- 15. Window Value Functions/1. Introduction to Window Value Functions.mp4  60.5 MB
- 26. Exploratory Data Analysis Project/6. Dimensions Exploration.mp4  60.0 MB
- 09. Date & Time Functions/1. What is Date & Time.mp4  59.7 MB
- 10. NULL Functions/3. Handling NULL Data Aggregation.mp4  59.4 MB
- 03. Data Definition (DDL)/2. ALTER.mp4  59.4 MB
- 25. SQL Data Warehouse Project/22. Silver Layer DDL Create Tables.mp4  59.3 MB
- 21. Indexes/15. Choose Right Index.mp4  59.2 MB
- 17. Common Table Expression (CTE)/8. CTE Best Practices.mp4  58.5 MB
- 08. String Functions/5. REPLACE.mp4  58.3 MB
- 19. CTAS & TEMP Tables/1. Introduction to Tables.mp4  57.6 MB
- 22. Partitions/1. Introduction to Partitions.mp4  57.5 MB
- 09. Date & Time Functions/8. EOMONTH.mp4  57.2 MB
- 26. Exploratory Data Analysis Project/5. Database Exploration.mp4  56.2 MB
- 27. SQL Advanced Data Analytics Project/8. Build Products Report.mp4  55.3 MB
- 08. String Functions/9. Number Functions.mp4  55.0 MB
- 22. Partitions/4. The Performance of Partitions.mp4  54.9 MB
- 02. SELECT Query/10. Coding & Execution Order.mp4  54.6 MB
- 02. SELECT Query/8. DISTINCT.mp4  54.1 MB
- 09. Date & Time Functions/17. ISDATE.mp4  53.7 MB
- 18. Views/2. 3 Levels Architecture.mp4  53.3 MB
- 06. SQL Joins/7. LEFT ANTI JOIN.mp4  53.1 MB
- 05. Filtering Data/4. NOT Operator.mp4  52.8 MB
- 18. Views/5. Use Case Central Logic.mp4  50.0 MB
- 25. SQL Data Warehouse Project/8. Understand Project Requirements.mp4  49.7 MB
- 20. Stored Procedures/4. Multi-Queries in Stored Procedure.mp4  49.3 MB
- 08. String Functions/7. LEFT & RIGHT.mp4  49.3 MB
- 15. Window Value Functions/6. Window Value Functions Summary.mp4  48.1 MB
- 21. Indexes/17. Monitor Missing Indexes.mp4  47.9 MB
- 06. SQL Joins/10. CROSS JOIN.mp4  47.9 MB
- 08. String Functions/2. CONCAT.mp4  47.5 MB
- 09. Date & Time Functions/4. DAY, MONTH, YEAR.mp4  46.9 MB
- 20. Stored Procedures/8. Styling Stored Procedures.mp4  44.4 MB
- 18. Views/14. View Summary.mp4  44.3 MB
- 19. CTAS & TEMP Tables/12. TEMP Table Use Cases.mp4  44.0 MB
- 01. Introduction to SQL/4. What is SQL and Databases.mp4  44.0 MB
- 14. Window Ranking Functions/7. Use Cases Assign Unique IDs.mp4  43.8 MB
- 19. CTAS & TEMP Tables/2. CTAS vs CREATEINSERT.mp4  43.5 MB
- 13. Window Aggregate Functions/8. Window Aggregate Functions Summary.mp4  41.6 MB
- 05. Filtering Data/3. OR Operator.mp4  41.5 MB
- 07. SQL SET Operators/6. INTERSECT.mp4  40.8 MB
- 18. Views/11. Use Case Flexibility.mp4  40.5 MB
- 24. Copilot & ChatGPT for SQL/2. What is ChatGPT & Copilot.mp4  40.4 MB
- 16. Subqueries/4. Subquery Categories.mp4  39.6 MB
- 19. CTAS & TEMP Tables/8. Use Case Data Warehouse.mp4  39.4 MB
- 08. String Functions/3. UPPER & LOWER.mp4  39.3 MB
- 18. Views/12. Use Case Multi-Language.mp4  39.3 MB
- 23. Performance Best Practices/2. Performance Tips for Fetching Data.mp4  39.2 MB
- 12. Window Functions Basics/8. Window Basic Summary.mp4  39.1 MB
- 21. Indexes/18. Monitor Duplicate Indexes.mp4  38.9 MB
- 23. Performance Best Practices/5. Performance Tips for Aggregation.mp4  38.9 MB
- 18. Views/8. How DB Executes View.mp4  38.8 MB
- 09. Date & Time Functions/2. Overview Date & Time Functions.mp4  38.8 MB
- 23. Performance Best Practices/8. Performance Tips for Indexing.mp4  38.4 MB
- 17. Common Table Expression (CTE)/10. CTE Summary.mp4  37.6 MB
- 16. Subqueries/5. Subquery Result Types.mp4  37.6 MB
- 02. SELECT Query/1. Components of SQL.mp4  37.5 MB
- 25. SQL Data Warehouse Project/35. Gold Layer Create Data Catalog.mp4  37.1 MB
- 27. SQL Advanced Data Analytics Project/9. Document Your Work in GIT.mp4  36.8 MB
- 19. CTAS & TEMP Tables/14. Table Summary.mp4  36.3 MB
- 19. CTAS & TEMP Tables/4. CTAS Syntax.mp4  35.8 MB
- 19. CTAS & TEMP Tables/5. Use Case Optimize Performance.mp4  35.8 MB
- 18. Views/6. Views vs CTEs.mp4  34.2 MB
- 20. Stored Procedures/9. What are Triggers.mp4  33.6 MB
- 01. Introduction to SQL/5. What is DBMS and SQL Server.mp4  33.6 MB
- 01. Introduction to SQL/8. Why Learn SQL.mp4  33.4 MB
- 10. NULL Functions/1. Introduction to NULLs.mp4  33.3 MB
- 01. Introduction to SQL/7. Types of SQL Commands.mp4  33.2 MB
- 13. Window Aggregate Functions/1. Introduction to Window Aggregate Functions.mp4  32.6 MB
- 19. CTAS & TEMP Tables/9. Introduction to TEMP Tables.mp4  32.6 MB
- 07. SQL SET Operators/9. SET Operators Summary.mp4  32.1 MB
- 21. Indexes/1. Introduction Indexes.mp4  31.0 MB
- 01. Introduction to SQL/6. Types of Databases.mp4  30.9 MB
- 14. Window Ranking Functions/12. Window Ranking Function Summary.mp4  30.9 MB
- 03. Data Definition (DDL)/3. DROP.mp4  30.6 MB
- 16. Subqueries/2. Introduction to Subquery.mp4  30.3 MB
- 08. String Functions/6. LEN.mp4  29.1 MB
- 19. CTAS & TEMP Tables/7. Use Case Snapshots.mp4  29.1 MB
- 21. Indexes/9. What is Columnstore Index.mp4  28.9 MB
- 17. Common Table Expression (CTE)/3. How DB Executes CTE.mp4  28.8 MB
- 23. Performance Best Practices/1. Introduction to Performance Tips.mp4  28.5 MB
- 16. Subqueries/3. Why Subquery.mp4  27.8 MB
- 11. CASE WHEN Statement/6. CASE Statement Summary.mp4  27.5 MB
- 02. SELECT Query/2. What is SQL Query.mp4  26.9 MB
- 21. Indexes/2. Types of Indexes.mp4  26.8 MB
- 11. CASE WHEN Statement/3. CASE Rules.mp4  25.8 MB
- 16. Subqueries/7. How DB Executes Subquery.mp4  24.8 MB
- 18. Views/3. What is View.mp4  24.5 MB
- 10. NULL Functions/11. NULL Summary.mp4  24.4 MB
- 06. SQL Joins/2. NO JOIN.mp4  24.2 MB
- 16. Subqueries/15. Subquery Summary.mp4  23.4 MB
- 18. Views/4. Views vs Tables.mp4  20.3 MB
- 21. Indexes/23. Indexing Strategy.mp4  19.9 MB
- 09. Date & Time Functions/18. Date & Time Summary.mp4  19.3 MB
- 19. CTAS & TEMP Tables/11. How DB Executes TEMP Tables.mp4  19.3 MB
- 24. Copilot & ChatGPT for SQL/1. Introduction to AI & SQL.mp4  18.6 MB
- 14. Window Ranking Functions/5. ROW_NUMBER vs RANK vs DENSE_RANK.mp4  17.1 MB
- 01. Introduction to SQL/3. Course Roadmap & Structure.mp4  17.0 MB
- 25. SQL Data Warehouse Project/2. SQL Project Types.mp4  17.0 MB
- 06. SQL Joins/11. How to Choose The Correct Join.mp4  16.7 MB
- 01. Introduction to SQL/2. sql-data-analytics-project.zip  16.5 MB
- 26. Exploratory Data Analysis Project/1. sql-data-analytics-project.zip  16.5 MB
- 25. SQL Data Warehouse Project/12. Refine the Project Plan.mp4  14.2 MB
- 01. Introduction to SQL/2. sql-data-warehouse-project.zip  13.4 MB
- 25. SQL Data Warehouse Project/1. sql-data-warehouse-project.zip  13.4 MB
- 01. Introduction to SQL/1. Introduction.mp4  12.8 MB
- 19. CTAS & TEMP Tables/6. How DB Executes CTAS.mp4  11.7 MB
- 17. Common Table Expression (CTE)/4. CTE Types.mp4  10.8 MB
- 27. SQL Advanced Data Analytics Project/1. Introduction to the Project.mp4  10.3 MB
- 25. SQL Data Warehouse Project/6. Get Project Resources.mp4  9.7 MB
- 19. CTAS & TEMP Tables/13. My opinion about TEMP Tables.mp4  9.2 MB
- 07. SQL SET Operators/1. Introduction to SET Operators.mp4  8.9 MB
- 28. THANK YOU/1. Congratulations & THANK YOU Video.mp4  6.4 MB
- 26. Exploratory Data Analysis Project/2. Introduction to EDA.mp4  3.4 MB
- 24. Copilot & ChatGPT for SQL/6. ChatGPT Prompts for SQL Developers.vtt  40.7 KB
- 17. Common Table Expression (CTE)/9. Recursive CTE.vtt  38.4 KB
- 21. Indexes/21. Execution Plan.vtt  34.6 KB
- 25. SQL Data Warehouse Project/24. Silver Layer  Load Script 2.vtt  30.1 KB
- 02. SELECT Query/12.2 Quiz  SELECT Query.html  28.7 KB
- 25. SQL Data Warehouse Project/26. Silver Layer  Load Script 4.vtt  27.9 KB
- 27. SQL Advanced Data Analytics Project/7. Build Customers Report.vtt  27.8 KB
- 13. Window Aggregate Functions/2. Window COUNT.vtt  26.7 KB
- 25. SQL Data Warehouse Project/25. Silver Layer  Load Script 3.vtt  25.7 KB
- 22. Partitions/2. The Process of Partitions.vtt  24.5 KB
- 25. SQL Data Warehouse Project/31. Gold Layer  Build Dimension Customers.vtt  24.4 KB
- 16. Subqueries/1. Challenges in Complex Projects.vtt  23.6 KB
- 27. SQL Advanced Data Analytics Project/6. Data Segmentation.vtt  22.3 KB
- 12. Window Functions Basics/6. Window Frame.vtt  21.9 KB
- 25. SQL Data Warehouse Project/23. Silver Layer  Load Script 1.vtt  21.8 KB
- 04. Data Manipulation (DML)/4.4 Quiz  DML.html  21.3 KB
- 04. Data Manipulation (DML)/1. INSERT.vtt  21.0 KB
- 06. SQL Joins/12. Multiple Table Joins.vtt  20.8 KB
- 14. Window Ranking Functions/11. Window NTILE.vtt  20.3 KB
- 09. Date & Time Functions/12. FORMAT.vtt  20.1 KB
- 01. Introduction to SQL/10.1 Quiz  Intro to SQL.html  19.9 KB
- 12. Window Functions Basics/2. Window Functions vs Group By.vtt  19.9 KB
- 06. SQL Joins/3. INNER JOIN.vtt  19.3 KB
- 03. Data Definition (DDL)/4.3 Quiz  DDL.html  19.2 KB
- 25. SQL Data Warehouse Project/21. Silver Layer  Exploring Data.vtt  19.0 KB
- 25. SQL Data Warehouse Project/19. Bronze Layer  Build Stored Procedure.vtt  18.9 KB
- 21. Indexes/16. Monitor Usage.vtt  18.7 KB
- 15. Window Value Functions/5. Window FIRST & LAST.vtt  18.6 KB
- 07. SQL SET Operators/2. SET Rules & Syntax.vtt  18.3 KB
- 24. Copilot & ChatGPT for SQL/7. ChatGPT Prompts for SQL Learning.vtt  18.2 KB
- 17. Common Table Expression (CTE)/7. Nested CTE.vtt  18.1 KB
- 27. SQL Advanced Data Analytics Project/4. Performance Analysis.vtt  18.0 KB
- 05. Filtering Data/7. LIKE Operators.vtt  17.5 KB
- 01. Introduction to SQL/9. Setup & Install SQL Server, SSMS & Databases.vtt  17.5 KB
- 18. Views/7. CREATE, ALTER, DROP Views.vtt  17.5 KB
- 16. Subqueries/14. Subquery using Exists.vtt  17.4 KB
- 10. NULL Functions/2. COALESC vs ISNULL.vtt  17.3 KB
- 26. Exploratory Data Analysis Project/9. Magnitude Analysis.vtt  16.6 KB
- 15. Window Value Functions/2. Window MIN & MAX.vtt  16.1 KB
- 23. Performance Best Practices/4. Performance Tips for Joining.vtt  15.8 KB
- 23. Performance Best Practices/9. Performance Tipcs Summary.vtt  15.8 KB
- 16. Subqueries/6. Subquery in FROM.vtt  15.5 KB
- 13. Window Aggregate Functions/6. Use Case Rolling & Running Total.vtt  15.4 KB
- 12. Window Functions Basics/4. Window Partition By.vtt  15.3 KB
- 09. Date & Time Functions/16. DATEDIFF.vtt  15.0 KB
- 16. Subqueries/13. Correlated Subquery.vtt  14.9 KB
- 13. Window Aggregate Functions/5. Window MIN & MAX.vtt  14.8 KB
- 21. Indexes/12. How to Create Coluimnstore Index.vtt  14.8 KB
- 18. Views/9. Use Case Hide Complexity.vtt  14.6 KB
- 05. Filtering Data/1. Comparison operators.vtt  14.3 KB
- 13. Window Aggregate Functions/4. Window AVG.vtt  14.1 KB
- 07. SQL SET Operators/7. Use Case Combine Information.vtt  14.1 KB
- 02. SELECT Query/5. ORDER BY.vtt  14.0 KB
- 10. NULL Functions/8. IS NULL & IS NOT NULL.vtt  14.0 KB
- 13. Window Aggregate Functions/7. Use Case Moving Average.vtt  13.8 KB
- 20. Stored Procedures/1. Introduction to Stored Procedures.vtt  13.6 KB
- 19. CTAS & TEMP Tables/15. Compare All Methods.vtt  13.5 KB
- 11. CASE WHEN Statement/4. Use Case Mapping Values.vtt  13.4 KB
- 25. SQL Data Warehouse Project/11. Draw DWH Architecture.vtt  13.2 KB
- 06. SQL Joins/1. Introduction to JOINs.vtt  13.1 KB
- 15. Window Value Functions/4. Use Case Customer Retention.vtt  13.1 KB
- 02. SELECT Query/3. SELECT & FROM.vtt  13.0 KB
- 02. SELECT Query/6. GROUP BY.vtt  12.9 KB
- 11. CASE WHEN Statement/5. Use Case Handling Nulls.vtt  12.8 KB
- 02. SELECT Query/7. HAVING.vtt  12.5 KB
- 20. Stored Procedures/10. Triggers Use Case.vtt  12.3 KB
- 10. NULL Functions/10. Handling NULL Data Policies.vtt  12.2 KB
- 27. SQL Advanced Data Analytics Project/2. Change Over Time Analysis.vtt  12.2 KB
- 16. Subqueries/11. Subquery using IN Operator.vtt  12.1 KB
- 26. Exploratory Data Analysis Project/8. Measure Exploration.vtt  12.1 KB
- 17. Common Table Expression (CTE)/5. Standalone CTE.vtt  12.0 KB
- 21. Indexes/7. How to Create INDEX.vtt  11.9 KB
- 25. SQL Data Warehouse Project/7. Notion for Project Management.vtt  11.9 KB
- 14. Window Ranking Functions/10. Window PERCENT_RANK.vtt  11.8 KB
- 12. Window Functions Basics/7. Window Function Rules.vtt  11.8 KB
- 09. Date & Time Functions/7. DATETRUNC.vtt  11.8 KB
- 23. Performance Best Practices/7. Performance Tips for Table DDL.vtt  11.7 KB
- 20. Stored Procedures/5. Variables.vtt  11.7 KB
- 21. Indexes/19. Update Statistics.vtt  11.7 KB
- 27. SQL Advanced Data Analytics Project/3. Cumulative Analysis.vtt  11.6 KB
- 13. Window Aggregate Functions/3. Window SUM.vtt  11.5 KB
- 17. Common Table Expression (CTE)/6. Multiple Standalone CTE.vtt  11.5 KB
- 11. CASE WHEN Statement/1. Introduction to CAST Statements.vtt  11.4 KB
- 25. SQL Data Warehouse Project/18. Bronze Layer  Load Scripts.vtt  11.3 KB
- 06. SQL Joins/4. LEFT JOIN.vtt  11.3 KB
- 09. Date & Time Functions/17. ISDATE.vtt  11.2 KB
- 25. SQL Data Warehouse Project/5. ETL Methods.vtt  11.1 KB
- 26. Exploratory Data Analysis Project/10. Ranking Analysis.vtt  11.0 KB
- 14. Window Ranking Functions/6. Use Cases TopBottom N Analysis.vtt  10.8 KB
- 25. SQL Data Warehouse Project/10. Design the Data Warehouse Layers.vtt  10.8 KB
- 21. Indexes/6. Clustered vs NonClustered Index.vtt  10.7 KB
- 27. SQL Advanced Data Analytics Project/5. Part to Whole Analysis.vtt  10.6 KB
- 15. Window Value Functions/3. Use Case Month-Over-Month (MoM).vtt  10.5 KB
- 06. SQL Joins/9. FULL ANTI JOIN.vtt  10.4 KB
- 10. NULL Functions/5. Handling NULL Joining Data.vtt  10.4 KB
- 25. SQL Data Warehouse Project/32. Gold Layer  Build Dimension Products.vtt  10.3 KB
- 25. SQL Data Warehouse Project/29. Gold Layer  Data Modelling.vtt  10.3 KB
- 03. Data Definition (DDL)/1. CREATE.vtt  10.3 KB
- 16. Subqueries/8. Subquery in SELECT.vtt  10.2 KB
- 20. Stored Procedures/3. Parameters.vtt  10.1 KB
- 19. CTAS & TEMP Tables/10. TEMP Syntax & Example.vtt  10.0 KB
- 12. Window Functions Basics/1. Aggregate Functions.vtt  10.0 KB
- 04. Data Manipulation (DML)/2. UPDATE.vtt  9.9 KB
- 21. Indexes/11. Columnstore vs Rowstore Index.vtt  9.8 KB
- 25. SQL Data Warehouse Project/3. Intro to Data Warehouse (DWH).vtt  9.8 KB
- 22. Partitions/3. Create Partitioned Tables.vtt  9.7 KB
- 25. SQL Data Warehouse Project/9. Data Architecture Approaches.vtt  9.6 KB
- 02. SELECT Query/4. WHERE.vtt  9.6 KB
- 16. Subqueries/10. Subquery in WHERE.vtt  9.6 KB
- 25. SQL Data Warehouse Project/13. Define The Naming Conventions.vtt  9.5 KB
- 09. Date & Time Functions/13. CONVERT.vtt  9.5 KB
- 18. Views/10. Use Case Data Security.vtt  9.5 KB
- 20. Stored Procedures/6. Control Flow IF ELSE.vtt  9.5 KB
- 08. String Functions/8. SUBSTRING.vtt  9.4 KB
- 10. NULL Functions/9. NULL vs Empty vs Blank.vtt  9.0 KB
- 10. NULL Functions/4. Handling NULL Mathematic Operations.vtt  8.9 KB
- 01. Introduction to SQL/3. Course Roadmap & Structure.vtt  8.8 KB
- 21. Indexes/10. Process of Building Columnstore Index.vtt  8.8 KB
- 16. Subqueries/12. Subquery using ALL & ANY Operators.vtt  8.7 KB
- 10. NULL Functions/7. NULLIF.vtt  8.7 KB
- 25. SQL Data Warehouse Project/33. Gold Layer  Build Fact Sales.vtt  8.7 KB
- 07. SQL SET Operators/3. UNION.vtt  8.6 KB
- 17. Common Table Expression (CTE)/1. Introduction to CTE.vtt  8.5 KB
- 21. Indexes/20. Fragmentations.vtt  8.5 KB
- 25. SQL Data Warehouse Project/36. Gold Layer  Document The Work.vtt  8.5 KB
- 25. SQL Data Warehouse Project/17. Bronze Layer  DDL Create Tables.vtt  8.5 KB
- 24. Copilot & ChatGPT for SQL/4. How to Use Copilot.vtt  8.5 KB
- 09. Date & Time Functions/5. DATEPART.vtt  8.4 KB
- 10. NULL Functions/6. Handling NULL Sorting Data.vtt  8.4 KB
- 21. Indexes/22. SQL hints.vtt  8.4 KB
- 25. SQL Data Warehouse Project/27. Silver Layer  Build Stored Procedure.vtt  8.4 KB
- 14. Window Ranking Functions/8. Use Cases Identify Duplicates.vtt  8.3 KB
- 08. String Functions/1. Introduction to SQL Functions.vtt  8.3 KB
- 02. SELECT Query/9. TOP.vtt  8.3 KB
- 25. SQL Data Warehouse Project/15. Create The Database.vtt  8.3 KB
- 07. SQL SET Operators/5. EXCEPT.vtt  8.3 KB
- 25. SQL Data Warehouse Project/16. Bronze Layer  Analyze Source Systems.vtt  8.2 KB
- 08. String Functions/4. TRIM.vtt  8.1 KB
- 09. Date & Time Functions/11. Intro to Formatting & Casting.vtt  8.1 KB
- 12. Window Functions Basics/3. Syntax of Window Functions.vtt  8.0 KB
- 11. CASE WHEN Statement/2. Use Case Categorizing Data.vtt  8.0 KB
- 23. Performance Best Practices/3. Performance Tips for Filtering.vtt  7.9 KB
- 21. Indexes/3. Heap Structure.vtt  7.8 KB
- 18. Views/1. Database Structure & Views.vtt  7.8 KB
- 20. Stored Procedures/7. Error Handling TRY & CATCH.vtt  7.7 KB
- 09. Date & Time Functions/14. CAST.vtt  7.7 KB
- 25. SQL Data Warehouse Project/34. Gold Layer  Draw The Data Model.vtt  7.7 KB
- 06. SQL Joins/8. RIGHT ANTI JOIN.vtt  7.6 KB
- 21. Indexes/4. Clustered Index.vtt  7.5 KB
- 26. Exploratory Data Analysis Project/7. Date Exploration.vtt  7.5 KB
- 09. Date & Time Functions/9. Use Cases Date Extraction.vtt  7.4 KB
- 14. Window Ranking Functions/9. Window CUME_DIST.vtt  7.4 KB
- 25. SQL Data Warehouse Project/20. Bronze Layer  Document The Work.vtt  7.3 KB
- 21. Indexes/13. Unique Index.vtt  7.3 KB
- 02. SELECT Query/11. Cool SQL Stuff.vtt  7.3 KB
- 06. SQL Joins/5. RIGHT JOIN.vtt  7.2 KB
- 21. Indexes/14. Filter Index.vtt  7.2 KB
- 06. SQL Joins/6. FULL JOIN.vtt  7.2 KB
- 14. Window Ranking Functions/4. Window DENSE_RANK.vtt  7.1 KB
- 04. Data Manipulation (DML)/3. DELETE.vtt  7.1 KB
- 14. Window Ranking Functions/1. Introduction to Ranking Functions.vtt  7.1 KB
- 16. Subqueries/9. Subquery in JOIN.vtt  7.0 KB
- 23. Performance Best Practices/6. Performance Tips for Subquiers.vtt  7.0 KB
- 09. Date & Time Functions/6. DATENAME.vtt  7.0 KB
- 05. Filtering Data/2. AND Operator.vtt  7.0 KB
- 17. Common Table Expression (CTE)/2. Why CTE.vtt  6.9 KB
- 09. Date & Time Functions/15. DATEADD.vtt  6.9 KB
- 14. Window Ranking Functions/2. Window ROW_NUMBER.vtt  6.8 KB
- 12. Window Functions Basics/5. Window Order By.vtt  6.8 KB
- 25. SQL Data Warehouse Project/14. Prepare Your GIT Repo.vtt  6.7 KB
- 26. Exploratory Data Analysis Project/4. Dimensions vs Measures.vtt  6.7 KB
- 22. Partitions/1. Introduction to Partitions.vtt  6.7 KB
- 05. Filtering Data/6. IN Operator.vtt  6.7 KB
- 05. Filtering Data/5. BETWEEN Operator.vtt  6.6 KB
- 14. Window Ranking Functions/3. Window RANK.vtt  6.6 KB
- 19. CTAS & TEMP Tables/3. CTAS vs Views.vtt  6.4 KB
- 18. Views/2. 3 Levels Architecture.vtt  6.4 KB
- 20. Stored Procedures/2. Basics of Stored Procedures.vtt  6.3 KB
- 24. Copilot & ChatGPT for SQL/3. ChatGPT vs Copliot.vtt  6.3 KB
- 06. SQL Joins/7. LEFT ANTI JOIN.vtt  6.3 KB
- 02. SELECT Query/10. Coding & Execution Order.vtt  6.2 KB
- 21. Indexes/5. NonClustered Index.vtt  6.2 KB
- 07. SQL SET Operators/4. UNION ALL.vtt  6.2 KB
- 08. String Functions/9. Number Functions.vtt  6.2 KB
- 25. SQL Data Warehouse Project/30. Gold Layer  Analysis.vtt  6.1 KB
- 21. Indexes/8. Composite Index.vtt  6.1 KB
- 26. Exploratory Data Analysis Project/6. Dimensions Exploration.vtt  5.8 KB
- 26. Exploratory Data Analysis Project/3. Get Project Resources.vtt  5.8 KB
- 25. SQL Data Warehouse Project/4. What is ETL.vtt  5.7 KB
- 15. Window Value Functions/1. Introduction to Window Value Functions.vtt  5.7 KB
- 07. SQL SET Operators/8. Use Case Delta Detection.vtt  5.6 KB
- 08. String Functions/5. REPLACE.vtt  5.6 KB
- 25. SQL Data Warehouse Project/22. Silver Layer  DDL Create Tables.vtt  5.5 KB
- 03. Data Definition (DDL)/2. ALTER.vtt  5.5 KB
- 02. SELECT Query/8. DISTINCT.vtt  5.5 KB
- 25. SQL Data Warehouse Project/28. Silver Layer  Document The Work.vtt  5.5 KB
- 09. Date & Time Functions/10. Compare Extract Functions.vtt  5.5 KB
- 09. Date & Time Functions/8. EOMONTH.vtt  5.5 KB
- 22. Partitions/4. The Performance of Partitions.vtt  5.4 KB
- 05. Filtering Data/4. NOT Operator.vtt  5.3 KB
- 27. SQL Advanced Data Analytics Project/8. Build Products Report.vtt  5.3 KB
- 10. NULL Functions/3. Handling NULL Data Aggregation.vtt  5.2 KB
- 06. SQL Joins/10. CROSS JOIN.vtt  5.1 KB
- 26. Exploratory Data Analysis Project/5. Database Exploration.vtt  5.0 KB
- 08. String Functions/2. CONCAT.vtt  5.0 KB
- 21. Indexes/15. Choose Right Index.vtt  5.0 KB
- 15. Window Value Functions/6. Window Value Functions Summary.vtt  4.9 KB
- 09. Date & Time Functions/1. What is Date & Time.vtt  4.9 KB
- 08. String Functions/7. LEFT & RIGHT.vtt  4.9 KB
- 25. SQL Data Warehouse Project/8. Understand Project Requirements.vtt  4.9 KB
- 01. Introduction to SQL/4. What is SQL and Databases.vtt  4.8 KB
- 19. CTAS & TEMP Tables/1. Introduction to Tables.vtt  4.8 KB
- 24. Copilot & ChatGPT for SQL/5. ChatGPT Prompt Structure.vtt  4.8 KB
- 21. Indexes/17. Monitor Missing Indexes.vtt  4.6 KB
- 18. Views/13. Use Case Data Warehouse.vtt  4.6 KB
- 05. Filtering Data/3. OR Operator.vtt  4.6 KB
- 18. Views/5. Use Case Central Logic.vtt  4.6 KB
- 02. SELECT Query/1. Components of SQL.vtt  4.4 KB
- 09. Date & Time Functions/4. DAY, MONTH, YEAR.vtt  4.4 KB
- 21. Indexes/18. Monitor Duplicate Indexes.vtt  4.4 KB
- 20. Stored Procedures/4. Multi-Queries in Stored Procedure.vtt  4.4 KB
- 25. SQL Data Warehouse Project/35. Gold Layer  Create Data Catalog.vtt  4.4 KB
- 07. SQL SET Operators/6. INTERSECT.vtt  4.3 KB
- 08. String Functions/3. UPPER & LOWER.vtt  4.2 KB
- 19. CTAS & TEMP Tables/12. TEMP Table Use Cases.vtt  4.1 KB
- 18. Views/8. How DB Executes View.vtt  4.1 KB
- 09. Date & Time Functions/2. Overview Date & Time Functions.vtt  4.0 KB
- 23. Performance Best Practices/2. Performance Tips for Fetching Data.vtt  4.0 KB
- 13. Window Aggregate Functions/8. Window Aggregate Functions Summary.vtt  4.0 KB
- 16. Subqueries/2. Introduction to Subquery.vtt  3.9 KB
- 20. Stored Procedures/8. Styling Stored Procedures.vtt  3.9 KB
- 10. NULL Functions/1. Introduction to NULLs.vtt  3.9 KB
- 19. CTAS & TEMP Tables/4. CTAS Syntax.vtt  3.8 KB
- 19. CTAS & TEMP Tables/5. Use Case Optimize Performance.vtt  3.8 KB
- 14. Window Ranking Functions/7. Use Cases Assign Unique IDs.vtt  3.8 KB
- 09. Date & Time Functions/3. Date-Time-Functions.zip  3.7 KB
- 19. CTAS & TEMP Tables/2. CTAS vs CREATEINSERT.vtt  3.7 KB
- 17. Common Table Expression (CTE)/8. CTE Best Practices.vtt  3.7 KB
- 12. Window Functions Basics/8. Window Basic Summary.vtt  3.6 KB
- 18. Views/14. View Summary.vtt  3.5 KB
- 16. Subqueries/5. Subquery Result Types.vtt  3.4 KB
- 14. Window Ranking Functions/12. Window Ranking Function Summary.vtt  3.4 KB
- 17. Common Table Expression (CTE)/3. How DB Executes CTE.vtt  3.4 KB
- 01. Introduction to SQL/7. Types of SQL Commands.vtt  3.4 KB
- 01. Introduction to SQL/5. What is DBMS and SQL Server.vtt  3.3 KB
- 19. CTAS & TEMP Tables/9. Introduction to TEMP Tables.vtt  3.3 KB
- 07. SQL SET Operators/9. SET Operators Summary.vtt  3.3 KB
- 01. Introduction to SQL/6. Types of Databases.vtt  3.2 KB
- 13. Window Aggregate Functions/1. Introduction to Window Aggregate Functions.vtt  3.2 KB
- 01. Introduction to SQL/8. Why Learn SQL.vtt  3.2 KB
- 27. SQL Advanced Data Analytics Project/9. Document Your Work in GIT.vtt  3.1 KB
- 18. Views/11. Use Case Flexibility.vtt  3.1 KB
- 19. CTAS & TEMP Tables/8. Use Case Data Warehouse.vtt  3.1 KB
- 17. Common Table Expression (CTE)/10. CTE Summary.vtt  3.1 KB
- 23. Performance Best Practices/5. Performance Tips for Aggregation.vtt  3.1 KB
- 16. Subqueries/3. Why Subquery.vtt  3.0 KB
- 20. Stored Procedures/9. What are Triggers.vtt  3.0 KB
- 08. String Functions/6. LEN.vtt  3.0 KB
- 16. Subqueries/4. Subquery Categories.vtt  2.9 KB
- 18. Views/12. Use Case  Multi-Language.vtt  2.9 KB
- 24. Copilot & ChatGPT for SQL/2. What is ChatGPT & Copilot.vtt  2.8 KB
- 18. Views/3. What is View.vtt  2.7 KB
- 23. Performance Best Practices/8. Performance Tips for Indexing.vtt  2.7 KB
- 10. NULL Functions/11. NULL Summary.vtt  2.7 KB
- 19. CTAS & TEMP Tables/14. Table Summary.vtt  2.6 KB
- 11. CASE WHEN Statement/6. CASE Statement Summary.vtt  2.6 KB
- 03. Data Definition (DDL)/3. DROP.vtt  2.6 KB
- 06. SQL Joins/2. NO JOIN.vtt  2.6 KB
- 02. SELECT Query/2. What is SQL Query.vtt  2.5 KB
- 21. Indexes/9. What is Columnstore Index.vtt  2.5 KB
- 06. SQL Joins/11. How to Choose The Correct Join.vtt  2.5 KB
- 18. Views/4. Views vs Tables.vtt  2.3 KB
- 21. Indexes/2. Types of Indexes.vtt  2.3 KB
- 01. Introduction to SQL/1. Introduction.vtt  2.3 KB
- 16. Subqueries/7. How DB Executes Subquery.vtt  2.2 KB
- 18. Views/6. Views vs CTEs.vtt  2.2 KB
- 23. Performance Best Practices/1. Introduction to Performance Tips.vtt  2.2 KB
- 11. CASE WHEN Statement/3. CASE Rules.vtt  2.1 KB
- 19. CTAS & TEMP Tables/11. How DB Executes TEMP Tables.vtt  2.0 KB
- 25. SQL Data Warehouse Project/2. SQL Project Types.vtt  2.0 KB
- 21. Indexes/1. Introduction Indexes.vtt  2.0 KB
- 16. Subqueries/15. Subquery Summary.vtt  1.9 KB
- 19. CTAS & TEMP Tables/7. Use Case Snapshots.vtt  1.9 KB
- 25. SQL Data Warehouse Project/1. Project Resources.html  1.7 KB
- 21. Indexes/23. Indexing Strategy.vtt  1.7 KB
- 01. Introduction to SQL/2. Course Resources.html  1.6 KB
- 09. Date & Time Functions/18. Date & Time Summary.vtt  1.6 KB
- 14. Window Ranking Functions/5. ROW_NUMBER vs RANK vs DENSE_RANK.vtt  1.5 KB
- 26. Exploratory Data Analysis Project/1. Project Resources.html  1.4 KB
- 24. Copilot & ChatGPT for SQL/1. Introduction to AI & SQL.vtt  1.3 KB
- 25. SQL Data Warehouse Project/12. Refine the Project Plan.vtt  1.3 KB
- 19. CTAS & TEMP Tables/6. How DB Executes CTAS.vtt  1.2 KB
- 27. SQL Advanced Data Analytics Project/1. Introduction to the Project.vtt  1.1 KB
- 25. SQL Data Warehouse Project/6. Get Project Resources.vtt  959 bytes
- 07. SQL SET Operators/1. Introduction to SET Operators.vtt  945 bytes
- 17. Common Table Expression (CTE)/4. CTE Types.vtt  753 bytes
- 28. THANK YOU/1. Congratulations & THANK YOU Video.vtt  566 bytes
- 19. CTAS & TEMP Tables/13. My opinion about TEMP Tables.vtt  518 bytes
- 26. Exploratory Data Analysis Project/2. Introduction to EDA.vtt  446 bytes
- 09. Date & Time Functions/3. Date & Time Scripts.html  389 bytes
 
    Download Torrent
    
    Related Resources
    
    Copyright Infringement
    
        If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.