Udemy - Learn to master DBT data build tool online course

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size2 GB
  • Uploaded Byfreecoursewb
  • Downloads19
  • Last checkedDec. 07th '21
  • Date uploadedDec. 04th '21
  • Seeders 3
  • Leechers6

Infohash : FE40FF6ED528687FCA8BB3CA69957EDE846293C2

Learn to master DBT data build tool online course



https://DevCourseWeb.com

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 48 lectures (4h 11m) | Size: 1.92 GB
hands-on, examples, case study, homework and more
What you'll learn:
DBT building blocks
DBT environment – yml files and structure
Develop transformations from staging to DWH schema
concepts of macro, Jinja and hooks
Test your code and transformations
Case study – DVD rental chain from stg to dwh
Deploy DBT to remote ubuntu server and DBT cloud

Requirements
SQL
GIT
relational database and analytics schema - nice to have

Description
this course will teach you the fundamentals of DBT data build tool. you will learn the structure of DBT data build tool, the main components:

· Install DBT data build tool

Files:

[ DevCourseWeb.com ] Udemy - Learn to master DBT data build tool online course
  • Get Bonus Downloads Here.url (0.2 KB)
  • ~Get Your Files Here ! 1. Introduction
    • 1. introduction.mp4 (46.2 MB)
    • 2. hello word example.mp4 (98.4 MB)
    • 3. what is DBT.mp4 (15.9 MB)
    • 4. hello word - dim date example 2.mp4 (37.6 MB)
    • 5. materials - zip file attached.mp4 (4.2 MB)
    • materials
      • dates.sql (2.2 KB)
      • dbt environment installs.txt (2.0 KB)
      • postgres-sakila-insert-data.sql (7.6 MB)
      • sakila_dbt
        • README.md (0.6 KB)
        • analysis
          • example.sql (0.1 KB)
          • gitkeep (0.0 KB)
          data
          • gitkeep (0.0 KB)
        • dbt_project.yml (1.7 KB)
        • gitignore (0.0 KB)
        • macros
          • concat_it.sql (0.1 KB)
          • delete_from_table.sql (0.1 KB)
          • generate_schema_name.sql (0.3 KB)
          • gitkeep (0.0 KB)
          • logit.sql (0.1 KB)
          models dimensions
          • dim_customer.sql (1.6 KB)
          • dim_date.sql (2.1 KB)
          • dim_film.sql (2.1 KB)
          • dim_staff.sql (0.5 KB)
          • dim_store.sql (1.3 KB)
          • schema.yml (1.3 KB)
          example
          • customer_test.sql (0.2 KB)
          • customer_test_macro.sql (0.3 KB)
          • dim_date_inc.sql (0.2 KB)
          • film_test.sql (0.1 KB)
          • hello_world.sql (0.7 KB)
          • my_first_dbt_model.sql (0.5 KB)
          • my_second_dbt_model.sql (0.1 KB)
          • payment_inc.sql (0.3 KB)
          • schema.yml (1.3 KB)
          facts
          • fact_payment.sql (0.3 KB)
          • fact_rental.sql (2.5 KB)
          • schema.yml (0.6 KB)
        • packages.yml (0.1 KB)
        • snapshots
          • gitkeep (0.0 KB)
          tests
          • film_cost_30.sql (0.1 KB)
          • gitkeep (0.0 KB)
        • sakila_postgres_schema.sql (51.2 KB)
        • sql_used_for_examples.txt (0.6 KB)
        • star_schema_design.jpg (212.2 KB)
        • utils.txt (0.1 KB)
        • 10. deploy DBT
          • 1. deployment - remote server ubuntu.mp4 (106.1 MB)
          • 2. DBT cloud - getdbt.mp4 (62.7 MB)
          • 3. congratulations.mp4 (1.0 MB)
          2. Installation
          • 1. Installation overview.mp4 (9.4 MB)
          • 2. GIT install.mp4 (20.5 MB)
          • 3. Dbeaver install.mp4 (38.7 MB)
          • 4. Postgres and Sakila install.mp4 (79.5 MB)
          • 5. Python and DBT install.mp4 (84.6 MB)
          3. DBT main components
          • 1. YAML files.mp4 (65.2 MB)
          • 2. materialization table view.mp4 (19.0 MB)
          • 3. incremental.mp4 (127.0 MB)
          • 4. tests.mp4 (121.6 MB)
          • 5. ephemeral.mp4 (18.4 MB)
          4. advance components
          • 1. variables.mp4 (22.8 MB)
          • 2. alias.mp4 (12.7 MB)
          • 3. custom schema.mp4 (40.7 MB)
          • 4. macros and packages.mp4 (80.5 MB)
          • 5. hooks.mp4 (82.3 MB)
          5. The project
          • 1. project overview.mp4 (37.4 MB)
          • 2. clear DWH homework.mp4 (41.1 MB)
          • 3. dim date.mp4 (10.3 MB)
          • 4. arrange hw.mp4 (8.8 MB)
          6. dim customer
          • 1. dim customer overview.mp4 (13.1 MB)
          • 2. dim customer base.mp4 (44.2 MB)
          • 3. dim customer conflict.mp4 (6.1 MB)
          • 4. dim customer source.mp4 (69.5 MB)
          • 5. dim customer minus one.mp4 (10.9 MB)
          7. dim staff store film
          • 1. dim staff.mp4 (43.0 MB)
          • 2. dim staff consideration.mp4 (58.3 MB)
          • 3. dim store.mp4 (72.1 MB)
          • 4. dim film explain.mp4 (34.0 MB)
          • 5. dim film result.mp4 (74.2 MB)
          • 6. dimensions schema yml.mp4 (16.4 MB)
          8. fact rental payment
          • 1. fact rental hw prepare.mp4 (4.4 MB)
          • 2. fact rental prepare solve.mp4 (9.0 MB)
          • 3. fact rental solve additional.mp4 (6.3 MB)
          • 4. fact rental explain.mp4 (56.9 MB)
          • 5. fact rental model.mp4 (54.0 MB)
          • 6. fact rental incremental.mp4 (80.4 MB)
          • 7. fact payment homework.mp4 (9.2 MB)
          • 8. fact payment solution.mp4 (20.5 MB)
          9. project finalize
          • 1. project final and homework.mp4 (5.6 MB)
          • 2. project final incremental solution.mp4 (50.8 MB)
          • Bonus Resources.txt (0.3 KB)

Code:

  • udp://tracker.torrent.eu.org:451/announce
  • udp://tracker.tiny-vps.com:6969/announce
  • http://tracker.foreverpirates.co:80/announce
  • udp://tracker.cyberia.is:6969/announce
  • udp://exodus.desync.com:6969/announce
  • udp://explodie.org:6969/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://9.rarbg.to:2780/announce
  • udp://tracker.internetwarriors.net:1337/announce
  • udp://ipv4.tracker.harry.lu:80/announce
  • udp://open.stealth.si:80/announce
  • udp://9.rarbg.to:2900/announce
  • udp://9.rarbg.me:2720/announce
  • udp://opentor.org:2710/announce