Complete Practical and Real-time Training on Snowflake. Snowflake Training course from SQL School will make you master the fundamentals of data warehousing capabilities as well as dealing with data and analytics. This Snowflake Video Training course teaches you all important concepts like snowflake objects, cloning, undrop, fail-safe and analytics solutions. At the end of this Snowflake Certification Training program, you will work on useful real-time projects.
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Snowflake | T-SQL, Snowflake |
T-SQL, Power BI, Snowflake |
|
Total Videos | 18 Videos | 30 Videos | 48 Videos |
Snowflake: DWH and ETL | ✔ | ✔ | ✔ |
Snowflake: Cloud Configurations | ✔ | ✔ | ✔ |
Snowflake: DWH Architecture | ✔ | ✔ | ✔ |
Snowflake: Database, Schemas | ✔ | ✔ | ✔ |
Snowflake: Constraints, SP, Tasks | ✔ | ✔ | ✔ |
Snowflake: Partitions & Tuning | ✔ | ✔ | ✔ |
Snowflake: Security Management | ✔ | ✔ | ✔ |
Snowflake: Automated Backups | ✔ | ✔ | ✔ |
Snowflake: SnowSQL Concepts | ✔ | ✔ | ✔ |
Snowflake: Variables & Tasks | ✔ | ✔ | ✔ |
Snowflake: File Formats, Stages | ✔ | ✔ | ✔ |
Snowflake: External Stages | ✔ | ✔ | ✔ |
Snowflake: Azure Integration | ✔ | ✔ | ✔ |
Snowflake: Snow Pipes & Upserts | ✔ | ✔ | ✔ |
Snowflake: Power BI Analytics | ✔ | ✔ | ✔ |
TSQL: Database Basics, T-SQL | ❌ | ✔ | ✔ |
TSQL : Constraints, Joins, Queries | ❌ | ✔ | ✔ |
TSQL: Views, Group By, Self Joins | ❌ | ✔ | ✔ |
TSQL: SPs, Udf, Transaction Basics | ❌ | ✔ | ✔ |
Power BI: Report Design, Visuals | ❌ | ❌ | ✔ |
Power BI: M Lang, DAX for ETL | ❌ | ❌ | ✔ |
Power BI: Cloud, Apps, Tenant | ❌ | ❌ | ✔ |
Power BI: Azure, Report Server | ❌ | ❌ | ✔ |
Total Course Fee
*
* Payable in Installments |
INR 15,000 USD 203 |
INR 19,000 USD 257 |
INR 27,000 USD 365 |
Trainer: Mr. Sai Phanindra T
All Session Are Completely Practical & Real Time
Snowflake Training Highlights :
✔ DWH & Snowflake Introduction | ✔ Snowflake Architecture |
✔ Snowflake Service Form | ✔ Snowflake Objects |
✔ Using SnowSQL CLI | ✔ Snowflake Data |
✔ Sequence in Snowflake | ✔ Snowflake Stream & Tasks |
✔ SnowSQL Operators | ✔ SnowSQL Concepts |
✔ Data Loads & Validations | ✔ Staging Operations with Snowflake |
✔ Unloading Data from Snowflake | ✔ Virtual Warehouse in Snowflake |
✔ Replication and Business Continuity | ✔ Security Management with Snowflake |
✔ Snowflake with Azure Data Factory | ✔ Managing Governance in Snowflake |
✔✔ End to End Real-time Project @ Resume |
Register Now for Snowflake Selfpaced Learning
Ch 1: SQL SERVER INTRODUCTION
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 9: JOINS, T-SQL QUERIES Level 3
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 6 : CONSTRAINTS,INDEXES Basics
|
Ch 10: VIEW, SPs, Function Basics
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 7: JOINS, T-SQL Queries : Level 1
|
Ch 11: Triggers & Transactions
|
Ch 4: SQL BASICS - 2
|
Ch 8: Group By, T-SQL Queries Level 2
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Real-time Case Study - 1 (Sales & Retail) Objective : Database Design, Table Design and Relations. Involves Purchases, Products, Customers and Time Data with Various Data Types. |
Real-time Case Study - 2 (Sales & Retail) Objective : Queries, Excel Integration Pivot Tables, Pivot Charts, ODC Connections |
Module 1: Snowflake Architecture, Basics |
Module 2: Snowflake Concepts, Admin |
Module 3: ETL, Stages & Pipes |
Ch 1: Introduction to Cloud & Snowflake
|
Ch 7: Constraints and Data Types
|
Ch 13: Snowflake Tasks, Partitions
|
Ch 2: Snowflake Account & Editions
|
Ch 8: Snowflake Cloning (Zero Copy)
|
Ch 14: SnowSQL and Variables
|
Ch 3: Architecture, Warehouse (DWH)
|
Ch 9: Snowflake Procedures
|
Ch 15: Snowflake Partitions, Stages
|
Ch 4: Snowflake Databases & Tables
|
Ch 10: Security Management
|
Ch 16: Azure & External Storage
|
Ch 5: Time Travel & Transient Tables
|
Ch 11: Snowflake Transactions
|
Ch 17: SnowPipes & Incremental Loads
|
Ch 6: Schemas and Session Context
|
Ch 12: Snowflake Streams & Audits
|
Ch 18 : REAL-TIME PROJECT
|
Part 1: Power BI Report Design |
Part 2: ETL, Data Modeling, DAX |
Part 3: Power BI Cloud, Admin |
Ch 1 : POWER BI BASICS
|
Ch 7 : POWER QUERY LEVEL 1
|
Ch 13 : POWER BI CLOUD - 1
|
Ch 2: BASIC REPORT DESIGN
|
Ch 8 : POWER QUERY LEVEL 2
|
Ch 14 : POWER BI CLOUD - 2
|
Ch 3 : Visual Sync, Grouping
|
Ch 9 : POWER QUERY LEVEL 3
|
Ch 15 : EXCEL & RLS
|
Ch 4 : Hierarchies, Filters
|
Ch 10 : DAX Functions - Level 1
|
Ch 16 : Report Server, RDL
|
Ch 5 : Bookmarks, Azure, Modeling
|
Ch 11 : DAX Functions - Level 2
|
Ch 17: MSBI Integrations
|
Ch 6 : Visualization Properties
|
Ch 12 : DAX FUNCTIONS Level 3
|
Ch 18 : REAL-TIME PROJECT
|