Conquer the waves of the technology world!!
Snowflake Course Content
A Snowflake course focuses on learning how to work with a modern cloud-based data warehouse developed by Snowflake Inc..
- 4.8
- 4.7
- 4.5
Course Features
- Real-time Use cases
- 24/7 Lifetime Support
- Certification Based Curriculum
- Flexible Schedules
- One-on-one doubt clearing
- Career path guidance
Snowflake Course Content
A Snowflake course focuses on learning how to work with a modern cloud-based data warehouse developed by Snowflake Inc.. The training typically begins with an introduction to cloud data warehousing concepts and Snowflake architecture, including key components such as databases, schemas, tables, virtual warehouses, and storage layers. Learners understand how Snowflake separates compute and storage, enabling scalability, flexibility, and high performance.
Snowflake Course Content
Topics – SQL
Section 1:
- Introduction
- Day Database, Schema, Database objects
- DDL, DML, DCL, TCL, DQL
- Aliasing Order of execution of clauses in SELECT
- SQL clauses
- Basic CASE statements
- COALESCE() function
- NULL handling and Wildcard search
- Aggregate, System and Window functions
Section 2:
- Operators
- Views, CTEs and Inline views
- IN/NOT IN, BETWEEN…AND…
- Operators
- SET Operators
- Joins
- Creating and maintaining indexes
- Stored Procedures in SQL
- Difference between UDF and Stored procedures
- Miscellaneous (commit, rollback, save)
Topics – Snowflake
Section 1:
- Introduction
- What is a data warehouse?
- What is cloud?
- Advantages of cloud computing?
- Types of cloud services
- The Snowflake Story
Section 2:
- Getting Started with Snowflake
- Signup for Snowflake
- Using Snowflake UI
- Understanding Database objects
- Container hierarchy Creating our first Database, Schema & Table
- Load Data into our first table
- Setting up command line interface – Snow sql
- Assignment: Create, load & query a table
Section 3:
- Snowflake Warehouse for Compute
- Creating our first Virtual Warehouse
- Virtual Warehouse sizes & Scalability
- Warehouse Credits
- Warehouse Suspend & Resume
- Warehouse – Maximized vs Auto Scale
- Multi-Cluster Warehouse Scaling policy’s
- Multi-cluster virtual warehouse or Scaling Out
- Assignment: Creating a new Virtual Warehouse
Section 4:
- Architecture, Features & Pricing
- Key Concepts & Features
- Shared disk vs Shared Nothing Architecture
- Columnar storage & Micro Partitions
- Multi Cluster Shared Data Architecture
- Snowflake 3 layer Architecture
- Supported Cloud Platforms & Regions
- Snowflake Editions
- Snowflake Releases
- Snowflake Pricing
- Data Integration configurations
- Data Integration with ETL tools
- Data Integration with reporting tools
- Integration with Programming
- Quiz: Snowflake Concepts
Section 5:
- Loading & Unloading Structured Data
- Ingestion / Loading Methods
- Steps to Managing Loads
- Preparing data for loading
- File Format Object
- Staging your data
- Copy options & ON_ERROR
- Loading data from an Internal stage
- Working with rejected records
- Different types of Internal stages
- Unloading of data
Section 6:
- Loading from AWS
- Creating S3 bucket
- Upload files in S3
- Creating policy
- Creating integration object
- Loading from S3
Section 7:
- Continuous Data Loading
- What is Snowpipe?
- Loading data via Snowpipe – high level steps
- Storage Integration
Section 8:
- Stage data transformations
- Querying Data in Staged Files
- Querying Metadata for Staged Files
- Transforming Data During a Load
Section 9:
- Semi Structured Data
- File Formats
- Loading JSON data
- Handling nested data, array data, hierarchy data
- Analytics on JSON data
Section 10:
- Databases, Tables & Views
- Working with Temporary, Transient & Permanent Tables
- Working with External Tables
- Overview of Views
- Working with Materialized Views
- Table Design Considerations
Section 11:
- Time Travel, Failsafe & Zero Copy Clones
- How Time Travel works
- Travel to a specific time or before through a query
- Undrop databases, schema & tables
- Failsafe in Snowflake
- Lab: View storage used by Fail-safe
- Zero Copy Cloning
- How cloning is different from copying
- Cloning with Time Travel
Section 12:
- Query & Cache Management
- Types of Cache
- Maximize Cache usage
- Lab: Query Caching in Action
- Query Profile
- Query History
- Query profile & Disk Spilling
- Information Schema
- Account Usage Schema
Section 13:
- Performance Considerations
- Impact of Data distribution in Micro-partitions
- Clustering Keys
- Clustering Depth
- Clustering large tables & improve partition elimination
- Lab: Cluster keys for large tables
- Search Optimization
- Benefits and Cost of Search Optimization
Section 14:
- Secure Data Sharing
- Secure Data Sharing in Snowflake
- Sharing with other Snowflake users
- Sharing – who’s compute is used?
- Sharing – Data always up-to date
- Sharing with non-Snowflake Users
Section 15:
- Snowflake Access Management
- Snowflake Approach to Access Control & Key Concepts
- Role Hierarchy in Snowflake
- ACCOUNTADMIN role
- SECURITYADMIN role
- SYSADMIN role
- Custom roles
- PUBLIC role
Section 16:
- Miscellaneous
- Table Constraints
- Maintaining referential integrity
- Working with Resource Monitors
- Change Tracking Using Table Streams
- Schedule Using Tasks
- Data Marketplace
Request more information
Hear From Our Learners
What Our Learners Say About Conquer Waves.
"Thank you Sujith for great training on Mule-soft. Great presentation style with lots of opportunities to ask questions. Course content got well covered. Thanks for such an informative and concept clearing training session. Overall a very informative training
"Sugith is an amazing trainer, he takes every effort to make sure the concepts are very well understood. I enjoyed the course very very much. "
"Excellent sessions and very interactive. Helps to understand concepts from basics, Which helps one to clear certifications soon. "
"Good trainer. Documentation present with him helps me a lot to learn the course quickly and easily. Thank you. "
"Very good training and we learn a lot. We are getting lot of documents and information so that after training also it is very helpful. "
"The way of teaching is good teaching experience. Friendly nature. Taking care of the students personally. Thank you so much for your support. Highly recommended to all. Has good grip in the concept. "
"His way of teaching is very good, experienced & knowledgeable faculty , Quality classes in every aspects. "
"Great explanation of concepts through live examples, this helped me to link the topics and understand the connect between various topics of Mulesoft . Excellent. Great learning experience. Thanks a lot . The classes were informative and effective. the Trainer Sujith was very helpful. I would recommend this Classes. Sujith was very good and he explained all the concepts of mulesoft training with real time scenario. Overall My experience in Mulesoft is very good. "
"Learnt new concepts from sujith sessions. Which are not available in you tube & other training. Thank you. Thank you so much for your support. Highly recommended to all. Has good grip in the concept. "
"Training was excellent with good interaction. Knowledge sharing is good. Recording facility is excellent for revising. Course was practically and informative.sugith Sir is enthusiastic and really aware of what he is explaining. The course helped to build confidence, Valuable experiences and learning. "
"Very thorough! He's a great instructor who simplifies complex concepts, uses plenty of examples, and provides practical tips for success. A perfect blend of lecture and practice. Thank you for sharing your knowledge. I highly recommend Sugith if anyone wants to take Mulesoft Training even if they are from Non-IT background. "
"Well versed explanation along with described notes in materials to to practices. Very good sessions to get prepare for certification perspective. "
"Sugith Kumar has excellent teaching skills, he is fantastic Trainer, very friendly and encouraging.He explained topics clearly with good examples and responded well to questions during the sessions and exercises.By far the best class in usefulness and hands-on experience that I have had technically.All of the exercises were on a scale of good to excellent and well explained. "
"I am BTech graduate but I am not in to software even I don't about basis. When I came to MuleSoft training his explains very grateful and I got to know how to work on it. I can suggest him for even those who are not belong to Non IT background also. "
I've taken mulesoft training under Sugith Kumar Kopparthi sir I felt that this is one of the best trainings I've had where I gained a lot of knowledge on my current working domain Thank you
I had the opportunity to attend MuleSoft training with Sugith Kumar Kopparthi. The sessions were very informative, practical, and easy to understand. It helped me strengthen my understanding of MuleSoft concepts. I recommend this training for anyone interested in MuleSoft.
I took training from Mr. Sugith on Mulesoft, it was very intensive and interactive training, He guided us through the hurdles and led to complete the POC projects and I am ready to take the certification exam with ease.
Training sessions have been incredibly helpful and easily understandable. At CWT ability to explain complex concepts in different ways was really unique and made a huge difference to my learning.
We got much knowledge in Mulesoft under your guidance .we have learnt many optimised structures in the Mulesoft.
Please fill out the enquiry form with your details.
Our team will review your request and get back to you shortly with the best possible solution.
If you have any specific questions or project requirements, feel free to mention them in the message section. We look forward to assisting you.
Our team will respond to your enquiry as soon as possible.
