| 1 - Instructor introduction.mp4 | 34.2 MB | ||
| 10 - dbt Core vs dbt Cloud.mp4 | 23.2 MB | ||
| 11 - Section overview.mp4 | 8.2 MB | ||
| 12 - Creating a Gmail account.mp4 | 7.9 MB | ||
| 12 - Link to Google signup page.txt | 0 B | ||
| 13 - Link to Google BigQuery.txt | 0 B | ||
| 13 - Setting up a BigQuery project with billing.mp4 | 19.5 MB | ||
| 14 - Link to BigQuery UI.txt | 0 B | ||
| 14 - Link to Google Cloud Billing.txt | 0 B | ||
| 14 - Optional If you have issues with BigQuery billing.mp4 | 11.9 MB | ||
| 15 - Link to BigQuery UI.txt | 0 B | ||
| 15 - The BigQuery UI.mp4 | 35.4 MB | ||
| 16 - Link to the dataset well be using.txt | 102.4 B | ||
| 16 - The dataset youll be using.mp4 | 32.2 MB | ||
| 17 - Link to Python 310 download page.txt | 102.4 B | ||
| 17 - Mac Installing Python 310.mp4 | 13.2 MB | ||
| 18 - Link to Python 310 download page.txt | 102.4 B | ||
| 18 - Windows Installing Python 310.mp4 | 15.3 MB | ||
| 18 - Windows Python install instructions.txt | 102.4 B | ||
| 19 - Downloading VSCode and setting up shortcuts.mp4 | 43.1 MB | ||
| 19 - Link to VSCode download page.txt | 0 B | ||
| 19 - keybindings.json | 512 B | ||
| 19 - keyboard-shortcuts-macos.pdf | 202.4 KB | ||
| 19 - keyboard-shortcuts-windows.pdf | 142.3 KB | ||
| 2 - 1b-c.Course-outline-introduction.pdf | 35.5 KB | ||
| 2 - Course outline.mp4 | 30.1 MB | ||
| 20 - Creating a GitHub account.mp4 | 17 MB | ||
| 20 - Link to GitHub account creation page.txt | 0 B | ||
| 21 - 2i.Forking-vs.cloning.pdf | 157.6 KB | ||
| 21 - Forking vs cloning.mp4 | 22.2 MB | ||
| 22 - Forking the repository.mp4 | 16.2 MB | ||
| 22 - Link to the repository well be using for this course.txt | 102.4 B | ||
| 23 - Optional If you have issues syncing your forked repository.mp4 | 59.8 MB | ||
| 24 - Installing the recommended extensions in VSCode.mp4 | 3.5 MB | ||
| 25 - 2m.Whats-a-venv.pdf | 124.7 KB | ||
| 25 - Whats a virtual environment venv.mp4 | 25.3 MB | ||
| 26 - Adding Python to path in Windows.txt | 102.4 B | ||
| 26 - Python guide for Windows.txt | 0 B | ||
| 26 - Setting up our virtual environment and installing packages.mp4 | 22.5 MB | ||
| 27 - Link to dbt docs on BigQuery setup.txt | 102.4 B | ||
| 27 - Link to gcloud install page.txt | 0 B | ||
| 27 - Setting up dbt for BigQuery.mp4 | 21.6 MB | ||
| 28 - Lesson-notes-trialling-the-model-project.pdf | 70.8 KB | ||
| 28 - Trialling our model dbt project.mp4 | 46.4 MB | ||
| 29 - Link to the autocomplete repository.txt | 0 B | ||
| 29 - Setting up dbt autocomplete.mp4 | 22.7 MB | ||
| 3 - Course introduction.mp4 | 38.5 MB | ||
| 30 - Run through of how our final project will look.mp4 | 66.1 MB | ||
| 31 - Lesson-notes-dbt-init.pdf | 26.7 KB | ||
| 31 - The dbt init command.mp4 | 29 MB | ||
| 32 - Version control with GitHub.mp4 | 69.8 MB | ||
| 33 - Debugging-dbt-Power-User.pdf | 135.8 KB | ||
| 33 - Setting up dbt Power User.mp4 | 84.5 MB | ||
| 33 - keybindings.json | 512 B | ||
| 33 - settings.json | 1.3 KB | ||
| 34 - How well structure our project.mp4 | 56.1 MB | ||
| 35 - Creating our first source src yml file.mp4 | 48.2 MB | ||
| 35 - Lesson-notes-sources.pdf | 39.6 KB | ||
| 35 - Link to dbt documentation on version 2.txt | 0 B | ||
| 36 - Creating our first staging stg SQL model.mp4 | 73.2 MB | ||
| 36 - Lesson-notes-our-first-SQL-model.pdf | 40.8 KB | ||
| 37 - Lesson-notes-running-our-first-SQL-file.pdf | 32.3 KB | ||
| 37 - Running our first staging stg SQL model.mp4 | 41.3 MB | ||
| 38 - Creating our first model yml file.mp4 | 24.1 MB | ||
| 38 - Lesson-notes-generating-our-first-model-yml-file.pdf | 33.7 KB | ||
| 39 - Adding tests to our first model yml file.mp4 | 79.5 MB | ||
| 39 - Lesson-notes-adding-tests-to-our-first-model-yml-file.pdf | 27 KB | ||
| 4 - A brief history of the data stack.mp4 | 33.7 MB | ||
| 40 - Lesson-notes-default-materialisation.pdf | 26.2 KB | ||
| 40 - Setting up our models to materialise as tables instead of views.mp4 | 48.4 MB | ||
| 41 - Getting the rest of our staging stg SQL models set up.mp4 | 34.2 MB | ||
| 42 - Link the dbt clean command.txt | 0 B | ||
| 42 - Using dbt clean to get table materialisation working.mp4 | 16.6 MB | ||
| 43 - Getting the rest of the staging stg yml files set up.mp4 | 77.8 MB | ||
| 43 - Lesson-notes-other-staging-yml-files.pdf | 37.5 KB | ||
| 44 - Taking stock of our staging stg data models.mp4 | 43 MB | ||
| 45 - The target folder.mp4 | 66.3 MB | ||
| 46 - Getting our first intermediate int SQL model set up.mp4 | 55 MB | ||
| 46 - Lesson-notes-first-int-SQL-model.pdf | 41.8 KB | ||
| 47 - Getting our first intermediate int yml file set up.mp4 | 91.6 MB | ||
| 47 - Lesson-notes-first-int-yml-file.pdf | 34.8 KB | ||
| 48 - Getting our mart SQL model set up.mp4 | 88.8 MB | ||
| 48 - Lesson-notes-first-mart-SQL-model.pdf | 55.4 KB | ||
| 49 - Getting our mart yml file set up.mp4 | 56.6 MB | ||
| 49 - Lesson-notes-first-mart-yml-file.pdf | 30.2 KB | ||
| 5 - Benefits of dbt inferring dependencies.mp4 | 54.5 MB | ||
| 50 - Lesson-notes-basic-project-complete.pdf | 50.1 KB | ||
| 50 - Our basic dbt project is now complete.mp4 | 20.2 MB | ||
| 51 - Lesson-notes-default-severity.pdf | 30.2 KB | ||
| 51 - Setting default test severity in dbtprojectyml.mp4 | 49.6 MB | ||
| 52 - Link to dbt documentation on severity.txt | 102.4 B | ||
| 52 - Setting test severity and thresholds.mp4 | 107.4 MB | ||
| 53 - Link to dbt codegen repo.txt | 0 B | ||
| 53 - Link to dbt expectations repo.txt | 0 B | ||
| 53 - Link to dbt utils repo.txt | 0 B | ||
| 53 - The external dbt packages well be using.mp4 | 95.8 MB | ||
| 54 - Lesson-notes-dbt-utils-expectations.pdf | 28.4 KB | ||
| 54 - dbtutils and dbtexpectations.mp4 | 92.1 MB | ||
| 55 - Custom singular tests.mp4 | 72.2 MB | ||
| 55 - Lesson-notes-custom-singular-tests.pdf | 35.8 KB | ||
| 55 - Link to dbt documentation on tests.txt | 0 B | ||
| 56 - Custom generic tests.mp4 | 99.6 MB | ||
| 56 - Lesson-notes-custom-generic-tests.pdf | 46.2 KB | ||
| 56 - Link to dbt documentation on custom generic tests.txt | 102.4 B | ||
| 57 - Applying advanced tests to our whole project.mp4 | 45.7 MB | ||
| 57 - Lesson-notes-applying-advanced-tests-to-our-whole-project.pdf | 50.5 KB | ||
| 58 - Lesson-notes-source-freshness.pdf | 27.5 KB | ||
| 58 - Link to dbt documentation on source freshness.txt | 102.4 B | ||
| 58 - Source freshness tests.mp4 | 41.8 MB | ||
| 59 - Lesson-notes-the-doc-function.pdf | 34.3 KB | ||
| 59 - Link to dbt documentation on the doc function.txt | 102.4 B | ||
| 59 - The doc function.mp4 | 69.4 MB | ||
| 6 - Benefits of dbt documentation testing.mp4 | 52.8 MB | ||
| 60 - Lesson-notes-seeds.pdf | 33.1 KB | ||
| 60 - Link to dbt documentation on seeds.txt | 0 B | ||
| 60 - Seed files.mp4 | 51.4 MB | ||
| 61 - Lesson-notes-snapshots.pdf | 37.4 KB | ||
| 61 - Link to dbt documentation on snapshots.txt | 0 B | ||
| 61 - dbt snapshots.mp4 | 106 MB | ||
| 62 - 5d.Materialisation-strategies.pdf | 358.9 KB | ||
| 62 - Link to dbt documentation on materialisations.txt | 0 B | ||
| 62 - Materialisation types.mp4 | 30.9 MB | ||
| 63 - Lesson-notes-ephemeral-models.pdf | 49.2 KB | ||
| 63 - Materialisation ephemeral models.mp4 | 104.8 MB | ||
| 64 - Lesson-notes-incremental-models.pdf | 42.6 KB | ||
| 64 - Link to dbt documentation on incremental models.txt | 102.4 B | ||
| 64 - Link to dbt documentation on the this function.txt | 102.4 B | ||
| 64 - Materialisation incremental models.mp4 | 139.1 MB | ||
| 65 - Lesson-notes-partitioned-tables.pdf | 36.4 KB | ||
| 65 - More information on BigQuery partitioned tables.txt | 102.4 B | ||
| 65 - Optional Partitioning a table in BigQuery.mp4 | 43 MB | ||
| 66 - Commands for a clean dbt run.mp4 | 29.4 MB | ||
| 67 - Lesson-notes-using-different-profiles.pdf | 64.3 KB | ||
| 67 - Link to dbt documentation on profiles.txt | 102.4 B | ||
| 67 - Using different dbt profiles.mp4 | 39.4 MB | ||
| 68 - Lesson-notes-selectors.pdf | 40.1 KB | ||
| 68 - Link to dbt documentation on graph operators.txt | 102.4 B | ||
| 68 - Selectors.mp4 | 54.9 MB | ||
| 69 - Lesson-notes-tags.pdf | 28.8 KB | ||
| 69 - Link to dbt documentation on tags.txt | 102.4 B | ||
| 69 - Tags.mp4 | 22.8 MB | ||
| 7 - Benefits of dbt Pythonlike functionality.mp4 | 61.3 MB | ||
| 70 - Indirect test selection.mp4 | 75.1 MB | ||
| 70 - Lesson-notes-indirect-selection.pdf | 30 KB | ||
| 70 - Link to dbt documentation on test selection.txt | 102.4 B | ||
| 71 - dbt test with warnerror.mp4 | 29.1 MB | ||
| 72 - Lesson-notes-dbt-build.pdf | 27.2 KB | ||
| 72 - Link to dbt documentation on the build command.txt | 0 B | ||
| 72 - dbt build.mp4 | 18.7 MB | ||
| 73 - Link to dbt documentation on docs generate serve.txt | 0 B | ||
| 73 - dbt docs generate serve.mp4 | 32.3 MB | ||
| 74 - Jinja comments statements and expressions.mp4 | 32.3 MB | ||
| 74 - Lesson-notes-jinja.pdf | 33.1 KB | ||
| 74 - Link to dbt documentation on jinja macros.txt | 0 B | ||
| 75 - The 3 types of macro functions hooks operations.mp4 | 42.8 MB | ||
| 75 - macro-details.md | 1.6 KB | ||
| 76 - Lesson-notes-jinja-function-reference.pdf | 30.7 KB | ||
| 76 - Link to inbuilt dbt jinja functions.txt | 102.4 B | ||
| 76 - Optional dbt Jinja function reference.mp4 | 38.6 MB | ||
| 77 - Lesson-notes-operations.pdf | 37.4 KB | ||
| 77 - Link to dbt documentation on operations.txt | 0 B | ||
| 77 - Macros operations.mp4 | 104.7 MB | ||
| 78 - Lesson-notes-functions.pdf | 52.2 KB | ||
| 78 - Link to dbt documentation on why not to nest curly brackets.txt | 102.4 B | ||
| 78 - Link to dbt documentation on why you quote column names in Jinja.txt | 102.4 B | ||
| 78 - Macros functions building a basic macro.mp4 | 48.8 MB | ||
| 79 - Lesson-notes-hooks.pdf | 41.1 KB | ||
| 79 - Link to dbt documentation on hooks.txt | 102.4 B | ||
| 79 - Macros hooks.mp4 | 69.4 MB | ||
| 8 - How dbt has solved a lot of problems in the data stack.mp4 | 24.8 MB | ||
| 80 - Jinja statements for loops and setting variables.mp4 | 50.5 MB | ||
| 80 - Lesson-notes-for-loops-and-setting-variables.pdf | 38 KB | ||
| 81 - Lesson-notes-the-target-function.pdf | 49.3 KB | ||
| 81 - Link to dbt documentation on custom schemas.txt | 0 B | ||
| 81 - Link to dbt documentation on the target function.txt | 102.4 B | ||
| 81 - Optional Jinja using the target function.mp4 | 47.1 MB | ||
| 82 - Creating a dbt Cloud account.mp4 | 3.8 MB | ||
| 82 - Link to dbt Cloud setup.txt | 0 B | ||
| 83 - Link to dbt documentation on BigQuery connections.txt | 102.4 B | ||
| 83 - Setting up a service account.mp4 | 31.9 MB | ||
| 84 - Connecting GitHub to dbt Cloud.mp4 | 10.7 MB | ||
| 85 - The dbt Cloud IDE.mp4 | 46.5 MB | ||
| 86 - Deploying jobs on dbt Cloud.mp4 | 78.9 MB | ||
| 86 - Link to dbt documentation on deployments.txt | 0 B | ||
| 86 - Link to dbt documentation on environment variables.txt | 102.4 B | ||
| 9 - 1d-i.Introduction-to-dbt.pdf | 1.2 MB | ||
| 9 - How dbt fits in the data stack.mp4 | 52.5 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 189 total files | |||
Mastering Dbt (Data Build Tool) - From Beginner To Pro
https://DevCourseWeb.com
Published 4/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.98 GB | Duration: 6h 46m
Analytics Engineering Bootcamp to take you from beginner to advanced dbt, and get hands-on with dbt Cloud!
What you'll learn
How to build a complete dbt project from scratch
The main benefits of dbt, and a bit of background as to how it came about
All of the dbt fundamentals: sources, models, tests, documentation, snapshots, seeds, macros, hooks, and operations
How to structure a dbt project
How to version control changes to your code with GitHub
Advanced dbt testing - creating your own custom singular & generic tests, setting severity, and setting warn/error thresholds
Advanced dbt data modelling - including incremental and ephemeral models and what type to use (& when)
Advanced dbt commands - how to use different selectors, different profiles, tags, indirect test selection and building a local dbt documents site
Advanced dbt jinja & macros - creating your own macros to use in hooks / functions / operations, using jinja for loops and variables, and the target function
How to deploy your project on dbt Cloud, how to use the dbt Cloud UI, and using environment variables
How to use tests & macros from external packages to supercharge your dbt project
Best practises to use when running a dbt project (based on lots of experience!)
How to create a complete setup for Mac or Windows: installing all of the tools and getting a dbt specific VSCode setup!
Requirements
Basic SQL
No Python experience needed
Mac / Windows machine which is capable of installing Python, Git, and VSCode (we'll run through all of this in the course!)
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.1 GB | freecoursewb | 1 week | 65 | 6 | |
|
Udemy - Mastering CAN Network - Vector CANoe,CANalyzer, CAPL and Theory Posted by
freecoursewb in Other
|
1.4 GB | freecoursewb | 2 weeks | 0 | 0 |
| 1.2 GB | freecoursewb | 2 weeks | 0 | 0 | |
| 540.5 MB | freecoursewb | 2 weeks | 60 | 7 | |
| 2.7 GB | freecoursewb | 2 weeks | 0 | 0 |
All Comments