Data Engineering: Complete Hands-On Snowflake Sql & Features

Snowflake, SQL, database, Datawarehouse, Cloud computing, Data loading, Snowpipe, Snowsql, ETL, ELT,AWS S3, IAM, SQS,EC2

What you'll learn

Will get complete knowledge on cloud database.

Will get complete SQL with on Snowflake database.

will give assignment for each topic to practice to get more experience on different queries.

Will get interview questions and answers for each topic.

Requirements

No Programming is required, Basic English understand is fine.

Description

Welcome to " DATA ENGINEERING: Complete Hands-On Snowflake SQL and Advanced Features"  This Course helpful for students who is looking to move on or learn cloud data warehouse even you're a beginner or experienced with SQL.What You'll Learn:Introduction to database, data warehouse, Snowflake cloud:Introduction to data, database, data warehouse, RDBMS, ETL, ELT.Introduction to cloud computing, Overview on AWS, On-Premise Vs Cloud.Snowflake Free Trail Account Creation and ways to connect Snowflake cloud.SQL Topics:All SQL concepts will be covered.SQL Statements (DDL, DML, DCL, TCL, DRL).Tables, Data Types, Constraints.Clauses: SELECT, FROM, WHERE, GROUP, HAVING, LIMIT, WITH, ORDER BY.SQL FUNCTIONS ( STRING, NUMBER, DATE, WINDOW, ANALYTICAL, AGGREGATE).JOINS, SUB QUERIES.VIEWS, MATERIALIZED VIEWS.SET OPERATORS, SEQUENCES and etc.Snowflake's Unique Features:Snowflake Architecture.Snowflake Virtual warehouse.Zero-Copy Cloning.Streams & Tasks.Time Travel.External Tables.Handling semi-structured file formats (parquet, json).Data Loading & Unloading:Snowpipe for continuous data loading.Hands-on data loading from AWS S3.Performance Tuning & Cost Optimization.Data Security & Access Control:Creating and Managing users, roles, and permissions.RBAC, DAC.Course Designed For:Freshers, Database Developers, DBAs, SQL Developers, ETL Developers, Data analysts and data engineers looking to learn SQL and SNOWFLAKE CLOUD DATA WAREHOUSE FEATURES.Prerequisites:NO PRIOR EXPERIENCE REQUIRED.BY END OF THIS COURSE WILL GET COMPLETE KNOWLEDGE ON DATABASE, DATAWAREHOUSE, SQL AND SNOWFLAKE FEATURES AND HAND-ON ON EACH TOPIC WHICH CAN HELP TO WORK IN REAL WORLD PROJECTS.

Overview

Section 1: SQL Snowflake Course Intro

Lecture 1 SQL Snowflake Course Intro

Section 2: Database & DWH (Data Warehousing) Concepts

Lecture 2 SQL Snowflake Data Database DBMS RDBMS

Lecture 3 SQL Snowflake Data Metadata ACID Properties

Lecture 4 SQL Snowflake Data warehouse stages ETL

Lecture 5 SQL_Snowflake_Normalization

Lecture 6 SQL Snowflake ER Data model - Dimension modeling

Lecture 7 SQL Snowflake SCD Types

Section 3: Cloud Computing: AWS

Lecture 8 Intro Cloud Computing and On-Premise vs Cloud

Section 4: Introduction to Snowflake

Lecture 9 Snowflake Introduction

Lecture 10 Snowflake Free Trail Account Creation

Lecture 11 Ways to Connect Snowflake Account

Lecture 12 Snowflake Snowsight UI Overview

Lecture 13 Snowflake Editions Key Features

Lecture 14 Snowflake Objects

Section 5: Snowflake Architecture

Lecture 15 Snowflake Architecture

Section 6: Snowflake Virtual Warehouse

Lecture 16 Snowflake Virtual warehouse Part-1

Lecture 17 Snowflake Virtual warehouse Part-2

Lecture 18 Snowflake Virtual warehouse Part-3

Section 7: SQL Statements

Lecture 19 SQL Statements Overview

Lecture 20 SQL CREATE/INSERT/SELECT

Lecture 21 SQL INSERT

Lecture 22 SQL Data Types: VARCHAR and NUMBER

Lecture 23 SQL Data Types: FLOAT

Lecture 24 SQL Data Types: Boolean

Lecture 25 SQL Data Types: Date Time Timestamp

Lecture 26 SQL STATEMENTS: ALTER COMMENT

Lecture 27 SQL STATEMENTS: DROP UNDROP

Lecture 28 SQL STATEMENTS: TCL: COMMIT ROLLBACK

Lecture 29 SQL STATEMENTS: DELETE TRUNCATE

Lecture 30 SQL STATEMENTS: UPDATE

Lecture 31 SQL SNOWFLAKE CONTEXT FUNCTIONS

Section 8: SQL SNOWFLAKE CONSTRAINTS

Lecture 32 SQL SNOWFLAKE TABLES CONSTRAINTS 1

Lecture 33 SQL SNOWFLAKE TABLES CONSTRAINTS 2

Freshers, Data Engineers, ETL/ELT Developers, Database Developers, Software Engineers.