Snowflake Training Demo Class - fkp.iai.analytics@gmail.com - +91 7396553033 (India)

This Video is to share the knowledge on Data Engineering & Snowflake -
https://www.fkpinstituteofai.com/course/snowflake

+91 7396553033 (India)
contact@fkpinstituteofai.com
fkp.iai.analytics@gmail.com

Contact Us for the syllabus and details -

1. Snowflake Basics
a. Types of Databases OLTP, OLAP & No SQL
b. Need of a Cloud Data warehouse MPP, On Premise MPP, Cloud MPP
c. Snowflake High level architecture
• Snowflake Layers
• Snowflake Editions
d. Snowflake work environment setup
e. Snowflake Ecosystem & Client Connectivity
g. Working with ODBC | JDBC | Python | Spark Connectors
h. SnowSQL CLI: Configuring & SnowSQL Commands hands on
i. Snowflake Web GUI
j. Working with config file
k. Working with multiple snowflake accounts
l. Preview & active features
2. Snowflake Architecture
a. Virtual Warehouses
• Introduction to Virtual Warehouses
• Components and functions of virtual warehouse
• Types of Virtual Warehouses
• Auto/manual suspends and resume
• Multi-cluster Warehouses
• Auto resizing
• Auto scaling policies
• Warehouse Caching
• Understanding Warehouse load and maintenance the workloads
• Optimal usage of Warehouses and Guidelines
• Resource monitors
• Warehouse Billing procedure
b. Storage
• Introduction to Columnar storage
• Micro-partitions
• Query Pruning
• Data Clustering
• Understanding Data Clustering
• Clustering Depth, Micro-partitions overlapping, Clustering ratio
• Choosing Clustering keys
• Auto and manual clustering
• Billing criteria
c. Cloud Services
• Functions and Billing criterion
• Cache
• SQLs - Metadata operations
3. Snowflake Data Dictionary
a. Information schema
b. Snowflake database
c. Limitations
4. Snowflake Table functions
a. Table function and uses
b. Creating a table function
c. Default table functions
d. Querying dictionary data using table functions

5. Snowflake SQL Optimization
a. General query Issues
b. Query Profiler
c. Understanding the query plan
d. Steps to improve query performance
6. Snowflake Database Objects
a. Database
b. Schema
c. Snowflake tables
• Temporary tables
• Transient tables
• External tables
d. Types of Views
i. Regular views
ii. Secured Views
iii. Materialized views
e. Synonyms
f. Materialized views vs Cached Results
g. Managing storage cost
7. Snowflake Data recovery features
a. Time travel
b. Fail safe
c. Database replication
d. Billing procedure
Page 3 of 6
8. AWS CLI
a. Installing and Configuring AWS CLI
b. AWS Storage Service
c. Learning AWS CLI Commands
d. Billing criteria for storage and notification services
9. Snowflake specific database objects
a. Stages
i. Internal stage
ii. External stage
iii. Querying stage files
b. File format
c. Data shares
d. Reader accounts
e. Warehouses and Snowflake Reader accounts
f. Streams and tasks
g. Data pipeline concept in Data engineering

10. Data loading
a. COPY, PUT, INSERT
b. File format and copying options
c. Validation mode
d. Error handing
e. Data loading considerations
f. Optimizing data loads
g. Data loading Practical framework
i. Split
ii. Compress
iii. Move
11. Data unloading
a. Basics of Data exporting
b. File format and export options
c. Understanding threads
d. Corresponding Dictionary objects and Table functions
12. Snow pipe
a. Snow pipe basics
b. Snow pipe consideration and guidelines
c. Creating a Snow pipe
d. AWS Storage Integration, ARN
e. AWS Notification Services and billing
f. Snow pipe billing criterion

Page 4 of 6
13. Snowflake SQL
a. Snowflake Basic SQL
b. MERGE statement
c. String functions
d. Aggregate functions
e. Pivoting
f. Data and Time functions
g. Collation
h. Time Zone
i. Window functions
j. Multi table inserts
k. Cloning Objects
l. Tags
14. Processing Semi-structured Data
a. Snowflake Supported file formats
b. JSON data processing hands on
c. Flattening functions
d. Loading JSON data
e. Synonyms and normalized tables
15. Snowflake Functions, Parameters and Variables
a. Snowflake functions and uses
b. Creating a function
c. Limitations
d. System parameters
• Account level parameters
• Session level parameters
• Object level parameters
e. Variables and uses
• Define variables and use
• list variables
16. Snowflake User management & Access Control
a. Roles
b. Hands on with System roles and responsibilities
• Account Admin
• Sysadmin
• Security Admin
b. Custom roles
c. Creating Users
d. Working with privileges

Page 5 of 6
e. Granting rights on future objects
f. Transfer of rights on cloned objects
17. Snowflake Credits, Billing & Guidelines
a. Snowflake credit
b. Understanding the snowflake bill
c. Compute billing process
d. Storage billing process
e. Cloud services billing process
18. Framework
a. ETL Scripts
b. Config tables
c. Log tables
d. Role of Unix
e. Role of Python
19. Data lake and Snowflake
a. Data Lake basics
b. Data lake and Data Warehouse
• Type of data: Raw, processed
• Readiness: Un-determined, Data ready
• Accessibility: Flexible, follows dimensional model
• Type of users: Analysts, Business Executives

Видео Snowflake Training Demo Class - fkp.iai.analytics@gmail.com - +91 7396553033 (India) канала fkp institute of AI