Topic Sub Topic Plan
1. Introduction to Snowflake
1.1 Key Concepts & Architecture Day 1
1.2 Snowflake Editions & Regions Day 1
1.3 Overview of Key Features Day 1
1.4 Overview of the Data Lifecycle Day 1
1.5 Continuous Data Protection Day 1
2. Connecting to Snowflake
2.1 Overview of the Ecosystem Day 2
2.2 Snowflake CLI Client (SnowSQL) Day 2
2.3 Snowflake Connector for Python Day 2
2.4 Snowflake JDBC Driver Day 2
2.5 Snowflake ODBC Driver Day 2
2.6 Diagnosing Common Connectivity Issues Day 2
3. Using Snowflake
3.1 Using the Web Interface Day 3
3.2 Overview of Warehouses Day 3
3.3 Virtual Warehouses Day 3
3.4 Multi-cluster Warehouses Day 3
3.5 Warehouse Considerations Day 4
3.6 Working with Warehouses Day 4
3.7 Monitoring Warehouse Load Day 4
4. Working with Tables, Views & Structures
4.1 Understanding Snowflake Table Structures Day 5
4.2 Working with Temporary and Transient Tables Day 5
4.3 Working with Secure Views Day 5
4.4 Cloning Considerations Day 5
4.5 Data Storage Considerations Day 5
Link to Material
https://docs.snowflake.net/manuals/user-guide/intro-key-concepts.html
https://docs.snowflake.net/manuals/user-guide/intro-editions.html
https://docs.snowflake.net/manuals/user-guide/intro-supported-features.html
https://docs.snowflake.net/manuals/user-guide/data-lifecycle.html
https://docs.snowflake.net/manuals/user-guide/data-cdp.html
https://docs.snowflake.net/manuals/user-guide/ecosystem.html
https://docs.snowflake.net/manuals/user-guide/snowsql.html
https://docs.snowflake.net/manuals/user-guide/python-connector.html
https://docs.snowflake.net/manuals/user-guide/jdbc.html
https://docs.snowflake.net/manuals/user-guide/odbc.html
https://docs.snowflake.net/manuals/user-guide/ecosystem-diagnose-connectivity-issues.html
https://docs.snowflake.net/manuals/user-guide/ui-using.html
https://docs.snowflake.net/manuals/user-guide/warehouses-overview.html
https://docs.snowflake.net/manuals/user-guide/warehouses.html
https://docs.snowflake.net/manuals/user-guide/warehouses-multicluster.html
https://docs.snowflake.net/manuals/user-guide/warehouses-considerations.html
https://docs.snowflake.net/manuals/user-guide/warehouses-tasks.html
https://docs.snowflake.net/manuals/user-guide/warehouses-load-monitoring.html
https://docs.snowflake.net/manuals/user-guide/tables-micro-partitions.html
https://docs.snowflake.net/manuals/user-guide/tables-temp-transient.html
https://docs.snowflake.net/manuals/user-guide/views-secure.html
https://docs.snowflake.net/manuals/user-guide/object-clone.html
https://docs.snowflake.net/manuals/user-guide/tables-storage-considerations.html
Topic Sub Topic
5. SQL Reference
5.1 Summary of Supported SQL
5.2 Data Types
5.3 Parameters
5.4 SQL Format for conversion of numeric and date/time values to and from text strings
5.5 Rules for resolving object names used in SQL statements.
5.6 Constraints
5.7 Query Constructs
5.8 Query Operators
5.9 Subqueries and Subquery Operators
5.95 SQL Variables
5.96 Transactions
5.97 Table Literals and Functions
5.98 Information Schema
5.99 User Defined Functions
6. Command Reference
6.1 Alphabetical List of Commands
6.2 Overview of DDL Commands
6.3 Database, Schema, & Share DDL
6.4 Table, View & Sequence DDL
6.5 Stage & File Format DDL
6.6 User-Defined Function DDL
6.7 Overview of DML Commands
7. Function Reference
7.1 Operators
7.2 Bitwise Expression Functions
7.3 Conditional Expression Functions
7.4 Context Functions
7.5 Numeric Functions
7.6 String & Binary Functions
7.7 Regular Expression (String) Functions
7.8 Date & Time Functions
7.9 Conversion Functions
7.91 Aggregate Functions
7.92 Analytic/Window Functions
7.93 Miscellaneous Functions
7.94 Alphabetical List of Functions
Plan
Day 6
Day 6
Day 6
Day 6
Day 6
Day 7
Day 7
Day 7
Day 7
Day 7
Day 8
Day 8
Day 8
Day 8
Day 9
Day 9
Day 9
Day 10
Day 10
Day 10
Day 10
Day 11
Day 11
Day 11
Day 11
Day 11
Day 11
Day 12
Day 12
Day 12
Day 12
Day 12
Day 12
Day 12
Link to Material
https://docs.snowflake.net/manuals/sql-reference/intro-summary-sql.html
https://docs.snowflake.net/manuals/sql-reference/data-types.html
https://docs.snowflake.net/manuals/sql-reference/parameters.html
https://docs.snowflake.net/manuals/sql-reference/sql-format-models.html
https://docs.snowflake.net/manuals/sql-reference/name-resolution.html
https://docs.snowflake.net/manuals/sql-reference/constraints.html
https://docs.snowflake.net/manuals/sql-reference/constructs.html
https://docs.snowflake.net/manuals/sql-reference/operators-query.html
https://docs.snowflake.net/manuals/sql-reference/operators-subquery.html
https://docs.snowflake.net/manuals/sql-reference/session-variables.html
https://docs.snowflake.net/manuals/sql-reference/transactions.html
https://docs.snowflake.net/manuals/sql-reference/functions-table.html
https://docs.snowflake.net/manuals/sql-reference/info-schema.html
https://docs.snowflake.net/manuals/sql-reference/user-defined-functions.html
https://docs.snowflake.net/manuals/sql-reference/sql-all.html
https://docs.snowflake.net/manuals/sql-reference/sql-ddl-summary.html
https://docs.snowflake.net/manuals/sql-reference/ddl-database.html
https://docs.snowflake.net/manuals/sql-reference/ddl-table.html
https://docs.snowflake.net/manuals/sql-reference/ddl-stage.html
https://docs.snowflake.net/manuals/sql-reference/ddl-udf.html
https://docs.snowflake.net/manuals/sql-reference/sql-dml.html
https://docs.snowflake.net/manuals/sql-reference/functions-operators.html
https://docs.snowflake.net/manuals/sql-reference/expressions-byte-bit.html
https://docs.snowflake.net/manuals/sql-reference/expressions-conditional.html
https://docs.snowflake.net/manuals/sql-reference/functions-context.html
https://docs.snowflake.net/manuals/sql-reference/functions-numeric.html
https://docs.snowflake.net/manuals/sql-reference/functions-string.html
https://docs.snowflake.net/manuals/sql-reference/functions-regexp.html
https://docs.snowflake.net/manuals/sql-reference/functions-date-time.html
https://docs.snowflake.net/manuals/sql-reference/functions-conversion.html
https://docs.snowflake.net/manuals/sql-reference/functions-aggregation.html
https://docs.snowflake.net/manuals/sql-reference/functions-analytic.html
https://docs.snowflake.net/manuals/sql-reference/functions-other.html
https://docs.snowflake.net/manuals/sql-reference/functions-all.html
Topic Sub Topic
8. Data Loading
8.1 Overview of Data Loading
8.2 Loading Data Using the Web Interface
8.3 Loading Data Using SnowSQL
8.4 Transforming Data During a Load
8.5 Data Loading Considerations
8.6 Loading Basic CSV Files Using SnowSQL
8.7 Loading Data from an Internal Stage
8.8 Loading Data from an External Amazon S3 Location
9. Data Unloading
9.1 Overview of Data Unloading
9.2 Required Information and Metadata for Data Unloading
9.3 Data Unloading Considerations
9.4 Unloading into Snowflake Locations
9.5 Unloading into External Locations
10. Dates & Timestamps
10.1 Date and Time Input / Output
10.2 Using Dates and Timestamps
Plan
Day 14
Day 14
Day 14
Day 14
Day 14
Day 14
Day 14
Day 14
Day 15
Day 15
Day 15
Day 15
Day 15
Day 15
Day 15
Link to Material
https://docs.snowflake.net/manuals/user-guide/data-load-overview.html
https://docs.snowflake.net/manuals/user-guide/data-load-web-ui.html
https://docs.snowflake.net/manuals/user-guide/data-load-cli.html
https://docs.snowflake.net/manuals/user-guide/data-load-transform.html
https://docs.snowflake.net/manuals/user-guide/data-load-considerations.html
https://docs.snowflake.net/manuals/user-guide/data-load-basic-tutorial-sql.html
https://docs.snowflake.net/manuals/user-guide/data-load-internal-tutorial.html
https://docs.snowflake.net/manuals/user-guide/data-load-external-tutorial.html
https://docs.snowflake.net/manuals/user-guide/data-unload-overview.html
https://docs.snowflake.net/manuals/user-guide/data-unload-requirements-metadata.html
https://docs.snowflake.net/manuals/user-guide/data-unload-considerations.html
https://docs.snowflake.net/manuals/user-guide/data-unloading-internal-location.html
https://docs.snowflake.net/manuals/user-guide/data-unloading-external-location.html
https://docs.snowflake.net/manuals/user-guide/date-time-input-output.html
https://docs.snowflake.net/manuals/user-guide/date-time-examples.html
Sr# Topic
1 Architecture & Key Concepts
2 Introduction to Snowflake
3 Introduction to Virtual Warehouses
4 Introduction to Databases & Querying
5 Introduction to Data Loading
6 Accelerating BI Queries with Caching in Snowflake
7 Easily Loading and Analyzing Semi-Structured Data in Snowflake
8 Eliminating Concurrency Issues with Snowflake Virtual Warehouses
9 Data Protection with Time Travel in Snowflake
10 A Quick Look at Zero-copy Cloning
11 Query Multiple Databases Within Snowflake
12 Tackling High Concurrency with Multi-Cluster Warehouses
13 Easily Sharing Data with Snowflake
Video
https://www.youtube.com/embed/j6Gr935erwU
https://www.youtube.com/embed/8vDqf1Nd0Hk
https://www.youtube.com/embed/9EFwBFxYx2c
https://www.youtube.com/embed/i4zify54Vys
https://www.youtube.com/embed/T2SsL5KbAJY
https://www.youtube.com/embed/lcO8CRT5EMc?list=PL4IM5KTx_T7hBvbHgLKEqWp75CumkicJI
https://www.youtube.com/embed/H0sbMDqdYQ8?list=PL4IM5KTx_T7hBvbHgLKEqWp75CumkicJI
https://www.youtube.com/embed/jxSwxVSalPw?list=PL4IM5KTx_T7hBvbHgLKEqWp75CumkicJI
https://www.youtube.com/embed/F1pevMhm7lg?list=PL4IM5KTx_T7hBvbHgLKEqWp75CumkicJI
https://www.youtube.com/embed/yQIMmXg7Seg?list=PL4IM5KTx_T7hBvbHgLKEqWp75CumkicJI
https://www.youtube.com/embed/iPC4jA8NxoA?list=PL4IM5KTx_T7hBvbHgLKEqWp75CumkicJI
https://www.youtube.com/embed/6TLnlDTDFBo?list=PL4IM5KTx_T7hBvbHgLKEqWp75CumkicJI
https://www.youtube.com/embed/fbNMf3h6Oh0?list=PL4IM5KTx_T7hBvbHgLKEqWp75CumkicJI
