Course Content Snowflake Overview and key featuresSecurity and Data ProtectionStandard and Extended SQL SupportTools and In...
Course Content
❖ Snowflake Overview and key features
● Security and Data Protection
● Standard and Extended SQL Support
● Tools and Interfaces
● Connectivity
● Data Import and Export
● Data Sharing
● Database Replication and Failover
● Snowflake Overview
● Multi clustered shared Architecture
● Local region
● Availability zones
● Snowflake editions
● Standard
● Premier
● Enterprise
● Enterprise for sensitive data
● Virtual private snowflake
● Connectivity
● Data import and export
● Data sharing
● Data life cycle
● Continuous data protection
● Data encryption
● Parameters
● Data types
● SQL format models
● Object identifiers
● Information schema
❖ Snowflake Architecture
● Data storage
● Compute layer
● Storage layer
❖ Virtual warehouses in Snowflake
● Concept
● How to determine appropriate size
● Resizing or multi clustered VW to fix
● Snowflake credits
❖ Databases and Querying
● Databases
● Accessing databases
● Accessing database via roles
● Custom roles
● Querying
❖ Summary of Data Types
● Numeric Data Types
● String & Binary Data Types
● Logical Data Types
● Date & Time Data Types
● Semi-structured Data Types
❖ Data loading
● Data loading
● Staging
● Loading using SQL
● Loading using Web interface
❖ Demonstration
● Create warehouse
● Create database
● Create schema
● Create table
● Temporary Tables
● Transient Tables
● Permanent Tables
● Load table – ware house
● Load table – source files
● Load table – file format
● Load table – Load options
● Load table – Load results
● Query data – preview
● Query data – SQL query
● Query data – Export results
● Query data – SQL script
● Query data – Information schema
● Suspended Warehouse
● Drop ware house
● Drop table
● Drop schema
● Drop database
❖ Snowflake Overview and Architecture
● Snowflake procedures
● Task scheduling for snowflake procedures
❖ Snowflake Overview and Architecture
● Industries
● Traditional data warehousing
● Datawarehouse as a service
● Multi clustered shared architecture
● Data storage
● Compute layer
● Service layer
● Local region availability zones
● Cloning
● Time travel
● Snowflake editions
● When not to use snowflake
● Security and data protection
● Virtual warehouse in snowflake
● How to determine appropriate size
● Snowflake credits
❖ Snowflake Project explanation
● Project ● Roles and responsibilities
❖ Snowflake Resume preparation
❖ Snowflake Interview questions
