English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 96 lectures (6h 2m) | 1.72 GB
All-in-one course for mastering SQL syntax and features with Snowflake, designed for the modern data landscape!
Welcome to The Ultimate Modern SQL Course! The only course you need to learn one of the most in-demand data skills in today’s workplace.
If we look at our modern data landscape we can see SQL everywhere, powering relational databases like MySQL and Postgres, enabling cloud-based analytics through platforms like BigQuery and Snowflake and even serving as interfaces for Big Data tools like Spark and Hadoop.
This course offers a one-stop shop for students of any skill level to learn all the essential SQL syntax and features, grounded in a deep understanding of how SQL has evolved to meet modern demands, such as cloud computing and Big Data.
Using the powerful cloud-native data platform Snowflake, we’ll analyse synthetic and real-world data through a combination of bite-sized theory lectures and hands-on exercises — equipping you with everything you need to become a SQL expert fit for the modern world!
What you’ll learn
- The SQL language’s history and context in current data landscape
- Data Definition Language (DDL) commands: CREATE, USE, SHOW, DESCRIBE, DROP & ALTER
- Experience working with and understanding both synthetic and real-world data
- Data Manipulation Language (DML) commands: INSERT, UPDATE, DELETE, TRUNCATE & MERGE
- Learn how to analyse data with a variety of beginner to advanced SQL features
- Learn to optimize SQL queries for faster execution and efficient resource usage
- Scalar & Aggregate Functions: SUM, AVG, RANDOM, ABS, COUNT, YEAR and many more
- Introduction to Snowflake, Cloud-Based SQL, and the Lakehouse Data Architecture
- Advanced SQL concepts: Window Functions, Collation, Transactions and many more
- Foundational Database / Data Engineering concepts: Character Encoding, Access Control, Data Lifecycle and more
- Custom functions: User-defined Functions and Stored Procedures
- Intermediate Querying topics: Subqueries, Joining, Set Operators and many more
Table of Contents
Course Setup
1 Course Syllabus
2 Course Code Download & Learning Tips
3 Snowflake Trial Account Setup – Hands-on
Introduction to SQL and Snowflake
4 What is SQL Part 1
5 What is SQL Part 2
6 What is Snowflake Data Platform
7 What is Snowflake Cloud Native
8 What is Snowflake Software as a service (SAAS)
9 Snowflake Architecture Overview
10 SQL Language Anatomy – Hands-on
11 Object Model
12 Access Control
Data Definition Language (DDL)
13 CREATE Statement
14 USE Statement & Worksheet Context – Hands-on
15 CREATE Statement Account-level Objects – Hands-on
16 CREATE Statement Schema-level Objects – Hands-on
17 SQL Data Types Overview
18 Numeric Data Types
19 String Data Types
20 Logical Data Types
21 Date & Time Data Types
22 Semi-structured Data Types
23 Geospatial Data Types
24 SQL Constraints
25 ALTER Statement & Parameters
26 Alter Statement & Parameters – Hands-on
27 SHOW Statement – Hands-on
28 DESCRIBE Statement – Hands-on
29 DROP Statement – Hands-on
30 SQL Language Standard and Best Practises
Data Manipulation Language (DML)
31 INSERT Statement – Hands-on
32 UPDATE Statement – Hands-on
33 DELETE Statement – Hands-on
34 TRUNCATE Statement – Hands-on
35 MERGE Statement – Hands-on
36 Snowflake Data Loading Introduction
37 Data Loading Stage Object
38 Data Loading COPY INTO table Statement
39 Data Loading File Format Object
40 Data Loading – Hands-on
Query Fundamentals
41 SELECT Clause
42 FROM Clause – Hands-on
43 WHERE Clause
44 WHERE Clause – Hands-on
45 ORDER BY Clause – Hands-on
46 Scalar Functions
47 Aggregate Functions
48 User-defined Functions (UDFs)
49 GROUP BY Clause – Hands-on
50 HAVING Clause – Hands-on
Intermediate Querying
51 Loading Real-world Dataset
52 Subqueries Introduction
53 Subquery Types
54 Subqueries Correlated vs. Uncorrelated
55 Subqueries – Hands-on
56 Joining – Part 1
57 Joining – Part 2
58 Set Operators
59 Set Operators – Hands-on
60 Conditional Expressions Introduction
61 Conditional Expressions CASE Statement
62 Conditional Expressions IFNULL & COALESCE
63 Conditional Expressions – Hands-on
64 View Object
65 Functions Conversion
SQL Performance Tuning
66 Query Performance Analysis Tools
67 Database Order of Execution and Filtering
68 Joining Best Practises
69 ORDER BY & LIMIT Best Practises
70 GROUP BY Best Practises
71 EXPLAIN Statement, Pruning and Clustering
72 Caching
73 Materialized Views
Advanced SQL Features
74 Window Functions Introduction
75 Window Functions Order-sensitive
76 Window Functions Order-insensitive
77 Window Frames Cumulative & Sliding
78 Window Functions – Hands-on
79 Common Table Expressions (CTE)
80 Common Table Expressions (CTE) – Hands-on
81 Recursive CTEs
82 Transactions Introduction
83 Transactions Implementation
84 Collation Introduction
85 Collation Implementation
86 Collation Specifiers
87 Collation Precedence
88 User-defined Functions (UDFs)
89 Stored Procedures
Processing Semi-structured Data
90 Semi-structured Data Introduction
91 Loading Semi-structured Data
92 Accessing Semi-structured Data
93 Functions Semi-structured Data
94 Semi-structured Data – Hands-on
95 Semi-structured Binary File Formats – Hands-on
Congratulations & Thank You!
96 Congratulations & Thank You
Resolve the captcha to access the links!