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

Batch Date: May 5th @10:00PM

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

Duration : 45 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 SNOWFLAKE

Mastering Snowflake: Fundamentals

1. How to Create Snowflake and DBT Account and How to Setup Snowflake with DBT
2. Introduction to Data Warehousing and Snowflake
3. Snowflake Architecture
4. How to Create Databases, Schema, Table and Insert data into Tables in Snowflake
5. SnowSQL Installation and Configuration on Windows and Create Connection with Snowflake

SQL for Snowflake

1. SQL for Snowflake - What is SQL and SQL Basics (Language Intro: DDL, DML, DCL, TCL)
2. SQL for Snowflake - DDL (Data Definition Language)
3. SQL for Snowflake - DML (Data Manipulation Language)
4. SQL for Snowflake - DQL (Data Retrieval Language or DQL Query Language)
5. SQL for Snowflake - TCL (Transactional Control Language)
6. SQL for Snowflake - DCL (Data Control Language)
7. SQL for Snowflake - Filtering and Sorting Commands

AWS for Snowflake

1. AWS for Snowflake - What is AWS; History of AWS
2. AWS for Snowflake - Step-by-Step Guide to Creating Your AWS Account
3. AWS for Snowflake - What is AWS Free Tier & How to Use It
4. AWS for Snowflake - AWS Global Infrastructure Overview
5. AWS for Snowflake - Step-by-Step Guide to Create AWS EC2 instance and Launch Snowflake on EC2
6. AWS for Snowflake - AWS S3 (Simple Storage Service)
7. AWS for Snowflake - AWS IAM (Identity and Access Management)

Mastering Snowflake : Advanced Concepts, Performance & Best Practices

1. Master Snowflake - Types of tables in Snowflake
2. Master Snowflake - What is Snowflake Time Travel and FailSafe with Practical Examples
3. Master Snowflake - Snowflake Internal & External Stages (Introduction and Types of Stages)
4. Master Snowflake - Internal Stages
5. Master Snowflake - External Stages
6. Master Snowflake - Snowflake Cloning
7. Master Snowflake - Snowflake Zero-Copy Cloning in Snowflake
8. Master Snowflake - Snowflake Roles
9. Master Snowflake - Stored Procedures in Snowflake
10. Master Snowflake - User Defined Functions in Snowflake
11. Role Hierarchy in Snowflake
12. Master Snowflake - Snowflake Architecture (Snowflake Editions, Snowflake Pricing etc.)
13. Master Snowflake - Snowflake Pricing for Virtual Warehouses
14. Master Snowflake - Snowflake Virtual Warehouse
15. Master Snowflake - Snowflake Resource Monitoring
16. Master Snowflake - Snowflake Query Profiling

Mastering Snowflake : Project & Real-World Scenarios

1. Design a Data Warehouse with Real Business Use Case
2. Load Raw Data → Transform → Automate with Tasks
3. Configure Security, Time Travel, and Share Cleaned Data
4. Monitor Billing, Warehouse Usage, and Performance
5. Optimize for Performance and Cost