Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Data Engineering: Complete Hands-On Snowflake Sql & Features

    Posted By: ELK1nG
    Data Engineering: Complete Hands-On Snowflake Sql & Features

    Data Engineering: Complete Hands-On Snowflake Sql & Features
    Published 5/2025
    MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
    Language: English | Size: 7.46 GB | Duration: 11h 52m

    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.