Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: July 1st @9:00PM

Faculty: Mr. A. Sreenivasa (15+ Yrs of Exp,.. & Real Time Expert)

Duration : 30 Days

Venue :
DURGA SOFTWARE SOLUTIONS,
Flat No : 202, 2nd Floor,
HUDA Maitrivanam,
Ameerpet, Hyderabad - 500038

Ph.No: +91 - 9246212143, 80 96 96 96 96

Syllabus:

MASTERING DBT (DATA BUILD TOOL)
for SNOWFLAKE

Mastering DBT for Snowflake Syllabus

DBT Introduction

1. What is DBT
2. Why DBT
3. Advantages of DBT
4. Pre-Requisites for DBT
5. How to Work with DBT

DBT Cloud Setup

6. DBT Cloud Setup Introduction.
7. Snowflake Free Account Creation.
8. DBT Free Cloud Account Creation
9. Create Connection Between DBT Cloud and Snowflake
10. Creating DBT Project in DBT Cloud and Run default DBT Models.

DBT Core Setup in VSCode on Windows

11. DBT Core Introduction
12. Python Installation
13. VSCode Installation
14. DBT Core Installation
15. Creating DBT Project in VSCode and Run default DBT Models.

DBT Models

16. What are DBT Models
17. Write First DBT Models
18. How to Run DBT Models
19. How to Specify Models as View or Table in DBT
20. Create Tables in Snowflake and Create Corresponding Models in DBT
21. Access different Schema Tables of Snowflake and Create Models in DBT
22. Combined DBT Models or Joins in DBT Models
23. Define Our Own Schema and Write DBT Models and Transform Data with DBT Models.

Jinja in DBT

24. Jinja Basics in DBT
25. Materialization using Jinja in DBT
26. Different DBT Jinja Examples

DBT Macros

27. What are DBT Tests.
28. How to Write DBT Test cases
29. Different DBT Testcases Examples

DBT Snapshots

30. What are DBT Tests.
31. How to Write DBT Test cases
32. Different DBT Testcases Examples

Hooks in DBT

33. What are DBT Tests.
34. How to Write DBT Test cases
35. Different DBT Testcases Examples

DBT Tests

36. What are DBT Tests.
37. How to Write DBT Test cases
38. Different DBT Testcases Examples