Udemy - Build the Perfect Data Stack for Analytics Engineering

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - The Modern Data Stack From Business Need to Command-Line Execution
• 1 - Introduction.mp4 (28.9 MB)
• 2 - Understanding DBT Core Concepts Through a Practical Example.mp4 (30.7 MB)
• 3 - Running DBT Models Command-Line Execution and Dependencies.mp4 (44.9 MB)
10 - Query Cost Monitoring and Attribution
• 1 - Cost Monitoring Fundamentals Tracking Query Expenses.mp4 (104.4 MB)
• 2 - Implementing default SQL Headers with +sql_header.mp4 (30.3 MB)
• 3 - Complete Cost Tracking Using query_comment() for All DBT Operations - part_15__cost_5__bq_query.sql (1.2 KB)
• 3 - Complete Cost Tracking Using query_comment() for All DBT Operations - part_15__cost_5__query_comment.sql (1.6 KB)
• 3 - Complete Cost Tracking Using query_comment() for All DBT Operations.mp4 (79.9 MB)
11 - Incremental Models Optimization, Cost Control, and Schema Management
• 1 - Incremental Models Efficient Data Updates with insert_overwrite Strategy.mp4 (85.2 MB)
• 2 - Optimizing PR Job Costs Preventing Full Refreshes in CI.mp4 (97.7 MB)
• 3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy - part_16__incremental_11__default_incremental_filter.sql (0.6 KB)
• 3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy - part_16__incremental_12__revenue_daily.sql (1.7 KB)
• 3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy - part_16__incremental_13__dbt_project.yml (0.3 KB)
• 3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy - part_16__incremental_9__check_table_exists.sql (0.8 KB)
• 3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy.mp4 (92.5 MB)
12 - Data Quality Testing From Basic Validation to Automated Fix
• 1 - Introduction to DBT Tests Basic Tests in .yml Files.mp4 (81.5 MB)
• 2 - Custom Testing Example for Validating End-to-End Data Integrity - part_17__tests_4__data_tests.yml (0.9 KB)
• 2 - Custom Testing Example for Validating End-to-End Data Integrity - part_17__tests_4__test_date_equality_filtered.sql (2.0 KB)
• 2 - Custom Testing Example for Validating End-to-End Data Integrity.mp4 (96.9 MB)
• 3 - Automated Test Fix Self-Healing Data Pipelines - part_17__tests_5__list_dates_to_retry.sql (1.2 KB)
• 3 - Automated Test Fix Self-Healing Data Pipelines - part_17__tests_5__run_test_data_pipeline_daily_retry.py (4.4 KB)
• 3 - Automated Test Fix Self-Healing Data Pipelines.mp4 (51.5 MB)
13 - More DBT Features Seeds, Macros, and Snapshots
• 1 - DBT Seeds Managing Static Reference Data with CSV Files.mp4 (129.3 MB)
• 2 - DBT Macros Creating Reusable SQL Logic.mp4 (84.1 MB)
• 3 - DBT Snapshots Tracking Historical Changes with Changing Dimensions - part_20__snapshots__snapshot_stg_customers.sql (0.4 KB)
• 3 - DBT Snapshots Tracking Historical Changes with Changing Dimensions.mp4 (72.5 MB)
14 - Conclusion My Secrets
• 1 - Analytics Engineering Fundamentals Principles for Long-Term Success.mp4 (93.0 MB)
2 - How to set up your DBT project
• 1 - DBT init.mp4 (64.5 MB)
• 2 - Configuring Development and Production Environments in profiles.yml.mp4 (49.4 MB)
• 3 - Securing Credentials Moving Service Account Keys Outside Your Project - part_3_dbt_profiles_3__README.md (1.4 KB)
• 3 - Securing Credentials Moving Service Account Keys Outside Your Project - part_3_dbt_profiles_3__profiles.yml (0.6 KB)
• 3 - Securing Credentials Moving Service Account Keys Outside Your Project.mp4 (48.2 MB)
3 - Setting Up Git for Collaborative DBT Development
• 1 - Version Control Setup Configuring .gitignore for DBT Projects.mp4 (22.8 MB)
• 2 - Initializing Git and Pushing Your DBT Project to GitHub.mp4 (24.1 MB)
• 3 - Testing Your Git Workflow Creating Your First Pull Request.mp4 (17.6 MB)
4 - Environment Management with UV
• 1 - Initializing UV Why Isolated Environments Matter.mp4 (32.8 MB)
• 2 - Committing UV Configuration Files.mp4 (11.1 MB)
• 3 - Documenting UV Setup in README - part_5__uv_setup_4__README.md (1.1 KB)
• 3 - Documenting UV Setup in README.mp4 (12.0 MB)
5 - How DBT Compilation and Packages Work
• 1 - Understanding dbt_project.yml Configuration and Compilation.mp4 (71.0 MB)
• 2 - Installing DBT Packages Adding dbt_utils.mp4 (22.2 MB)
6 - Data Modeling Layers Staging, Intermediate, and Mart
• 1 - Staging Layer Conventions and Best Practices.mp4 (32.8 MB)
• 2 - Implementing Staging Models Sources, Files, and Configuration - part_8__model_2_staging_2__src.yml (0.2 KB)
• 2 - Implementing Staging Models Sources, Files, and Configuration.mp4 (96.7 MB)
• 3 - Intermediate Layer Conventions and Best Practices.mp4 (68.8 MB)
• 4 - Implementing Intermediate Models Dimensions, Facts and Naming Convention.mp4 (58.1 MB)
• 5 - Introduction to Data Modeling Layers.mp4 (40.8 MB)
• 6 - Mart Layer Conventions and Best Practices.mp4 (28.9 MB)
• 7 - Implementing Mart Models Final Tables for Analysis and External Tools.mp4 (50.4 MB)
• 8 - Global Conventions SQL Structure and Naming Standards - part_8__README.md (6.1 KB)
• 8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__dim_customer.sql (0.2 KB)
• 8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__ext_salesforce_customer.sql (0.2 KB)
• 8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__fct_revenue_daily.sql (0.3 KB)
• 8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__fct_revenue_event.sql (0.6 KB)
• 8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__revenue_daily.sql (0.2 KB)
• 8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__stg_gsheet_raw_data_customers.sql (0.2 KB)
• 8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__stg_gsheet_raw_data_purchases.sql (0.3 KB)
• 8 - Global Conventions SQL Structure and Naming Standards.mp4 (112.2 MB)
7 - Code Quality and Documentation Automation and Best Practices
• 1 - Showcasing Data Usage with Exposures - part_9__exposures.yml (0.8 KB)
• 1 - Showcasing Data Usage with Exposures.mp4 (31.7 MB)
• 2 - Code Quality with SQLFluff Automated SQL Linting - part_10__sqlfluff.yml (0.7 KB)
• 2 - Code Quality with SQLFluff Automated SQL Linting - part_10__sqlfluff__dbt_utils.py (0.1 KB)
• 2 - Code Quality with SQLFluff Automated SQL Linting - part_10__sqlfluff__settings.json (0.3 KB)
• 2 - Code Quality with SQLFluff Automated SQL Linting.mp4 (79.1 MB)
• 3 - Handling SQLFluff Macro Conflicts Advanced Configuration - part_10__sqlfluff_2__fct_revenue_daily.sql (0.9 KB)
• 3 - Handling SQLFluff Macro Conflicts Advanced Configuration - part_10__sqlfluff_2__macros.sql (0.3 KB)
• 3 - Handling SQLFluff Macro Conflicts Advanced Configuration - part_10__sqlfluff_2__sqlfluff.y (0.9 KB)
• 3 - Handling SQLFluff Macro Conflicts Advanced Configuration.mp4 (98.9 MB)
• 4 - Model Documentation with YAML File Generation - part_11__documentation__generate_model_yaml.py (10.3 KB)
• 4 - Model Documentation with YAML File Generation - part_11__documentation__generate_model_yaml.sql (1.6 KB)
• 4 - Model Documentation with YAML File Generation.mp4 (80.4 MB)
• 5 - Enforcing Code Quality with Pre-Commit Hooks SQLFluff Integration.mp4 (30.8 MB)
• 6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting - part_12__pre_commit__README.md (0.1 KB)
• 6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting - part_12__pre_commit__pre-commit-config.yaml (0.9 KB)
• 6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting - part_12__pre_commit__pre_commit_run_documentation.py (4.4 KB)
• 6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting - part_12__pre_commit__pre_commit_run_model.py (6.0 KB)
• 6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting.mp4 (62.9 MB)
8 - Production Deployment with DBT Cloud
• 1 - Introduction to DBT Cloud Setup and Data Warehouse Connection.mp4 (29.1 MB)
• 2 - Connecting Your GitHub Repository to DBT Cloud.mp4 (16.5 MB)
• 3 - Creating Production Jobs Scheduling Automated DBT Runs.mp4 (34.7 MB)
• 4 - CI Jobs with DBT Cloud.mp4 (55.8 MB)
• 5 - Merge Jobs with DBT Cloud.mp4 (25.8 MB)
• 6 - Generating and Hosting Documentation with DBT Cloud.mp4 (28.2 MB)
9 - Workflow Automation Makefiles and GitHub Actions
• 1 - Local Automation with Makefiles SQLFluff Fix - part_14__auto_1_sqlfluff_1__make_sqlfluff_fix.py (3.9 KB)
• 1 - Local Automation with Makefiles SQLFluff Fix.mp4 (61.1 MB)
• 2 - Fully Automated SQLFluff Fixes with GitHub Actions - part_14_auto_1__sqlfluff_fix.yml (0.5 KB)
• 2 - Fully Automated SQLFluff Fixes with GitHub Actions.mp4 (44.0 MB)
• 3 - Fully Automated Documentation of Production Models.mp4 (74.0 MB)
• 4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations - part_14__auto_3__cleaning_recommendation.yml (1.0 KB)
• 4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations - part_14__auto_3__list_tables_in_prod.sql (1.5 KB)
• 4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations - part_14__auto_3__make_cleaning_reco.py (5.1 KB)
• 4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations - part_14__auto_3__makefile.part-14-auto-3-makefile (0.3 KB)
• 4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations.mp4 (71.1 MB)
• Bonus Resources.txt (0.1 KB)