The Complete SQL Bootcamp: Master Modern SQL with Snowflake

سرفصل های دوره

Master SQL syntax, SQL optimization, and SQL data modeling with Snowflake in this complete course for all skill levels

1 - Course Setup

1 -Course Syllabus

2 -Course Code Download & Learning Tips

2 -The Ultimate Modern SQL Course Code Folder.zip

3 -Snowflake Trial Account Setup - Hands-on

2 - Introduction to SQL and Snowflake

1 -What is SQL Part 1

2 -What is SQL Part 2

3 -What is Snowflake Data Platform

4 -What is Snowflake Cloud Native

5 -What is Snowflake Software as a service (SAAS)

6 -Snowflake Architecture Overview

7 -SQL Language Anatomy - Hands-on

8 -Object Model

9 -Access Control

3 - Data Definition Language (DDL)

1 -CREATE Statement

2 -USE Statement & Worksheet Context - Hands-on

3 -CREATE Statement Account-level Objects - Hands-on

4 -CREATE Statement Schema-level Objects - Hands-on

5 -SQL Data Types Overview

6 -Numeric Data Types

7 -String Data Types

8 -Logical Data Types

9 -Date & Time Data Types

10 -Semi-structured Data Types

11 -Geospatial Data Types

12 -SQL Constraints

13 -ALTER Statement & Parameters

14 -Alter Statement & Parameters - Hands-on

15 -SHOW Statement - Hands-on

16 -DESCRIBE Statement - Hands-on

17 -DROP Statement - Hands-on

18 -SQL Language Standard and Best Practises

4 - Data Manipulation Language (DML)

1 -INSERT Statement - Hands-on

2 -UPDATE Statement - Hands-on

3 -DELETE Statement - Hands-on

4 -TRUNCATE Statement - Hands-on

5 -MERGE Statement - Hands-on

6 -Snowflake Data Loading Introduction

7 -Data Loading Stage Object

8 -Data Loading COPY INTO table Statement

9 -Data Loading File Format Object

10 -Data Loading - Hands-on

5 - Query Fundamentals

1 -SELECT Clause

2 -FROM Clause - Hands-on

3 -WHERE Clause

4 -WHERE Clause - Hands-on

5 -ORDER BY Clause - Hands-on

6 -Scalar Functions

7 -Aggregate Functions

8 -User-defined Functions (UDFs)

9 -GROUP BY Clause - Hands-on

10 -HAVING Clause - Hands-on

6 - Intermediate Querying

1 -Loading Real-world Dataset

2 -Subqueries Introduction

3 -Subquery Types

4 -Subqueries Correlated vs. Uncorrelated

5 -Subqueries - Hands-on

6 -Joining - Part 1

7 -Joining - Part 2

8 -Set Operators

9 -Set Operators - Hands-on

10 -Conditional Expressions Introduction

11 -Conditional Expressions CASE Statement

12 -Conditional Expressions IFNULL & COALESCE

13 -Conditional Expressions - Hands-on

14 -View Object

15 -Functions Conversion

7 - SQL Performance Tuning

1 -Query Performance Analysis Tools

2 -Database Order of Execution and Filtering

3 -Joining Best Practises

4 -ORDER BY & LIMIT Best Practises

5 -GROUP BY Best Practises

6 -EXPLAIN Statement, Pruning and Clustering

7 -Caching

8 -Materialized Views

8 - Advanced SQL Features

1 -Window Functions Introduction

2 -Window Functions Order-sensitive

3 -Window Functions Order-insensitive

4 -Window Frames Cumulative & Sliding

5 -Window Functions - Hands-on

6 -Common Table Expressions (CTE)

7 -Common Table Expressions (CTE) - Hands-on

8 -Recursive CTEs

9 -Transactions Introduction

10 -Transactions Implementation

11 -Collation Introduction

12 -Collation Implementation

13 -Collation Specifiers

14 -Collation Precedence

15 -User-defined Functions (UDFs)

16 -Stored Procedures

9 - Processing Semi-structured Data

1 -Semi-structured Data Introduction

2 -Loading Semi-structured Data

3 -Accessing Semi-structured Data

4 -Functions Semi-structured Data

5 -Semi-structured Data - Hands-on

6 -Semi-structured Binary File Formats - Hands-on

10 - Congratulations & Thank You!

1 -Congratulations & Thank You

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy