Real Time Experts
4.9 out of 5 based on 337 Reviews
Chapter 1: Snowflake Fundamentals
• How
different from traditional DB like Oracle.
• Quick
start to Snowflake and accessing trial account
• Creating
warehouse, DB, Schema, and tables
• Accessing
different roles and using it
• Working
with worksheets
• Understanding
different type of accounts
Chapter 2:
Understanding cloud platforms
• AWS and
understanding S3 storage
• Snowflake
architecture and caching.
• AZURE and
understanding blob storage
• GCP and
understanding Bucket storage
Chapter 3: Data Loading and unloading data using
snowflake
• File
formats Internal and external
storage
• Copy into
usage
• Snowflake
internal storage
•
Accessing Cloud storage data into Snowflake(GCP, AZURE and AWS)
• Data
unloading
Chapter 4: Snow pipe
• File
formats
• Internal
and external storage
• Copy into
usage
• Snowflake
internal storage
• Accessing
Cloud storage data into Snowflake(GCP, AZURE and AWS)
• Data
unloading
Chapter 5: Partner connect with Snowflake
• Snowflake
Connector and use cases Python
• BI
connectors use cases.,
• Other
connectors hands-on
Chapter 6: Handling JSON
• Variant
Datatype
• File
format options
• Creating
stages
• Loading
JSON semi-structured data into SF tables
• Accessing
JSON with select statement
Chapter 7:
Scheduling with Snowflake
• Creating
Tasks
•
Streams
• Accessing
procedures with tasks
• Scheduling
as per time with Different time zones
• Automate
loading process Daily and Weekly
Chapter 8: Securing data sharing
• Usage of
sharing data
• Sharing
data with different accounts
• Sharing
data with non-SF accounts using reader accounts
• Importance
of reader accounts
• Privileges
in data sharing
• Challenges
with cross-region sharing and understanding replication
• Connecting
shared objects with BI tools like POWER BI
•
Limitations with Data sharing
Chapter 9: Cloning in snowflake
• Access
Control Privileges for Cloned Objects
• Cloning
and Snowflake Objects
• Impact
of DDL on Cloning
• Impact of
DML and Data Retention on Cloning
Chapter
10:Clustering and performance techniques
• Creating
multi clusters on large tables
• Performance
techniques
Chapter 11:
Conclusion
• Summarize
all the points discussed.
Chapter 12: Practice test and interview questions
• At Real
time experts, we provide end of the course , community question and answers,
mock interview sessions, also Snowflake
interview questions and Sample Resumes to crack the interview.