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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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