This Snowflake training is designed for working professionals who have minimum sql knoweldge, and minimum python background. In this Snowflake course we will be explaining fundamental concepts like cloud warehouse, stages and advanced concepts like performance, Dbt, Snowpark and money saving steps. It’s best suitable for freshers and experienced professionals to implement end to end projects. SQL and python basic knowledge is mandatory to learn snowflake. Snowpro certification, different usecases, mock interviews helps to get a placement after this snowflake training.
- Snowflake training syllabus
- Traditional datawarehouse vs Cloud datawarehouse
Snowflake architecture
Snowflake Vs other datawarehouse
Internal vs external stages.
Get data from AWS S3, Azure blob storage.
Querying Data in Staged Files
Querying Metadata for Staged Files
Transforming Data During a Load
Sharing data security
managing snowflake account
extending data lake using external table.
managing cost
managing governance in snowflake
create udf in snowflake.
Loading JSON Data into a Relational Table
best practice:
Roles and Access Control
Virtual Warehouses
Table Design
Data Storage
Data Loading
Data Unloading
Semi-structured Data
Snowflake Marketplace
Understanding & Using Time Travel
Snowpark using python
Snowpark end to end project.
Snowsight vs Snowflake SQL Worksheet
Loading Data into Snowflake
Bulk Loading Using COPY
Loading Continuously Using Snowpipe
|
|