Sign Up
Course Content
1. Snowflake Getting Started
0/1
Snowflake Web Registration Introduction & Architecture of the Snowflake.
2. Loading Data from Multiple Sources in Snowflake
0/1
Options for Various Data Loading in Snowflake Using the COPY Command to Load Data in Bulk Fill the S3 bucket with data Snowflake’s JSON data loading Fast data loading and analysis thanks to the snow pipe.
3. Snowflake Time Travel and Some Other Features
0/1
Time travel is used while Snowflake Querying Historical Data No Copy, No Clone Time travel using Copy Clone Object Dropping and Restoring.
4. Snowflake Data Sharing
0/1
Sharing Snowflake Data Iceberg Secure Views Data Exchange with Users Other Than Snowflake Sharing Data Through Web UI.
5. Snowflake SQL: DDL AND DML Commands
0/1
Creating a database, a table, and inserting and selecting statements in Command for Truncate, Delete, and Drop SQL’s update command Following the SQL Table Command.
6. Snowflake SQL: String and Date Time Functions
0/1
Functionality for Left, Right, Char Index, and Substring in SQL SQL Concatenate, Repeat, and Replace Function Part 01: Date and Time Operations Part-02 of the date and time functions.
7. Snowflake SQL: Operators in SQL
0/1
Fundamental Overview of Operators PLUS Operator OR Operator Input Operator.
8. Snowflake SQL: Aggregate Functions
0/1
Aggregate Function Overview Sort by Statement Justification With Clause Aggregate Function Example.
9. Snowflake SQL: Joins
0/1
Inside Join Illustrations of Inner Join Beyond Join Illustrations of Outer Joins Self-Join Calculated Product.
10. Snowflake SQL: Subquery
0/1
Introduction to the subquery Select, From, and Where Clauses in a Subquery INSERT, UPDATE, and DELETE subquery Similar Subquery.
11. Snowflake SQL: Analytical Functions
0/1
Column Number Functions of Rank and Dense Rank Example of Rank and Dense Rank Part-1 Part-02 of the Rank and Dense Rank Example Moving Average and Cumulative Sum Examples: Moving average, moving count, and cumulative sum.
12. Snowflake SQL: Advanced Concepts
0/1
A case study and Coalesce Mechanism.
13. Snowflake SQL
0/1
Union and Union All.
14. Snowflake SQL Temp tables
0/1
Permanent Tables and Tables that glow.
Snowflake Training
About Lesson


Previous
Next