Data Engineering: Complete Hands-On Snowflake Sql & Features
 

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.