Master SQL & Snowflake: Complete 2024 Data Bootcamp
Focused View
6:02:05
1 -Course Syllabus.mp4
03:16
2 -Course Code Download & Learning Tips.mp4
03:22
2 -The Ultimate Modern SQL Course Code Folder.zip
3 -Snowflake Trial Account Setup - Hands-on.mp4
05:05
1 -What is SQL Part 1.mp4
06:27
2 -What is SQL Part 2.mp4
05:12
3 -What is Snowflake Data Platform.mp4
04:32
4 -What is Snowflake Cloud Native.mp4
01:26
5 -What is Snowflake Software as a service (SAAS).mp4
01:59
6 -Snowflake Architecture Overview.mp4
04:32
7 -SQL Language Anatomy - Hands-on.mp4
06:16
8 -Object Model.mp4
03:01
9 -Access Control.mp4
05:27
1 -CREATE Statement.mp4
03:31
2 -USE Statement & Worksheet Context - Hands-on.mp4
02:37
3 -CREATE Statement Account-level Objects - Hands-on.mp4
05:06
4 -CREATE Statement Schema-level Objects - Hands-on.mp4
02:50
5 -SQL Data Types Overview.mp4
02:05
6 -Numeric Data Types.mp4
04:36
7 -String Data Types.mp4
02:57
8 -Logical Data Types.mp4
02:06
9 -Date & Time Data Types.mp4
02:07
10 -Semi-structured Data Types.mp4
02:54
11 -Geospatial Data Types.mp4
02:10
12 -SQL Constraints.mp4
04:08
13 -ALTER Statement & Parameters.mp4
04:36
14 -Alter Statement & Parameters - Hands-on.mp4
04:23
15 -SHOW Statement - Hands-on.mp4
05:01
16 -DESCRIBE Statement - Hands-on.mp4
02:12
17 -DROP Statement - Hands-on.mp4
04:02
18 -SQL Language Standard and Best Practises.mp4
03:06
1 -INSERT Statement - Hands-on.mp4
04:49
2 -UPDATE Statement - Hands-on.mp4
04:11
3 -DELETE Statement - Hands-on.mp4
04:30
4 -TRUNCATE Statement - Hands-on.mp4
02:19
5 -MERGE Statement - Hands-on.mp4
04:10
6 -Snowflake Data Loading Introduction.mp4
02:57
7 -Data Loading Stage Object.mp4
04:36
8 -Data Loading COPY INTO table Statement.mp4
02:57
9 -Data Loading File Format Object.mp4
02:38
10 -Data Loading - Hands-on.mp4
03:22
1 -SELECT Clause.mp4
02:21
2 -FROM Clause - Hands-on.mp4
04:45
3 -WHERE Clause.mp4
04:14
4 -WHERE Clause - Hands-on.mp4
04:01
5 -ORDER BY Clause - Hands-on.mp4
04:33
6 -Scalar Functions.mp4
03:34
7 -Aggregate Functions.mp4
02:54
8 -User-defined Functions (UDFs).mp4
01:45
9 -GROUP BY Clause - Hands-on.mp4
06:09
10 -HAVING Clause - Hands-on.mp4
02:55
1 -Loading Real-world Dataset.mp4
03:00
2 -Subqueries Introduction.mp4
02:00
3 -Subquery Types.mp4
02:06
4 -Subqueries Correlated vs. Uncorrelated.mp4
02:16
5 -Subqueries - Hands-on.mp4
05:32
6 -Joining - Part 1.mp4
06:16
7 -Joining - Part 2.mp4
05:13
8 -Set Operators.mp4
05:05
9 -Set Operators - Hands-on.mp4
04:44
10 -Conditional Expressions Introduction.mp4
01:48
11 -Conditional Expressions CASE Statement.mp4
03:13
12 -Conditional Expressions IFNULL & COALESCE.mp4
02:40
13 -Conditional Expressions - Hands-on.mp4
03:38
14 -View Object.mp4
03:42
15 -Functions Conversion.mp4
03:59
1 -Query Performance Analysis Tools.mp4
05:42
2 -Database Order of Execution and Filtering.mp4
02:11
3 -Joining Best Practises.mp4
01:58
4 -ORDER BY & LIMIT Best Practises.mp4
02:04
5 -GROUP BY Best Practises.mp4
01:53
6 -EXPLAIN Statement, Pruning and Clustering.mp4
05:59
7 -Caching.mp4
03:55
8 -Materialized Views.mp4
03:01
1 -Window Functions Introduction.mp4
04:12
2 -Window Functions Order-sensitive.mp4
03:57
3 -Window Functions Order-insensitive.mp4
02:56
4 -Window Frames Cumulative & Sliding.mp4
05:20
5 -Window Functions - Hands-on.mp4
06:17
6 -Common Table Expressions (CTE).mp4
04:07
7 -Common Table Expressions (CTE) - Hands-on.mp4
01:57
8 -Recursive CTEs.mp4
05:34
9 -Transactions Introduction.mp4
04:31
10 -Transactions Implementation.mp4
07:57
11 -Collation Introduction.mp4
04:08
12 -Collation Implementation.mp4
02:20
13 -Collation Specifiers.mp4
04:09
14 -Collation Precedence.mp4
02:22
15 -User-defined Functions (UDFs).mp4
05:05
16 -Stored Procedures.mp4
03:54
1 -Semi-structured Data Introduction.mp4
03:25
2 -Loading Semi-structured Data.mp4
04:32
3 -Accessing Semi-structured Data.mp4
03:31
4 -Functions Semi-structured Data.mp4
03:38
5 -Semi-structured Data - Hands-on.mp4
05:29
6 -Semi-structured Binary File Formats - Hands-on.mp4
05:35
1 -Congratulations & Thank You.mp4
00:32
More details
Course Overview
Become a SQL expert with this comprehensive bootcamp covering everything from basic syntax to advanced Snowflake features. Learn through hands-on exercises with both synthetic and real-world datasets in this cloud-based learning environment.
What You'll Learn
- Master SQL DDL and DML commands for database management
- Optimize queries for performance and efficient resource usage
- Work with advanced features like Window Functions and CTEs
Who This Is For
- Data professionals (Engineers, Scientists, Analysts) upgrading skills
- Career-changers seeking in-demand SQL expertise
- Students learning database fundamentals
Key Benefits
- No prior experience needed - complete beginner to pro journey
- Free Snowflake account setup included
- Practical skills for immediate workplace application
Curriculum Highlights
- Snowflake architecture & SQL foundations
- Data definition & manipulation techniques
- Advanced query optimization strategies
Focused display
Category
- language english
- Training sessions 96
- duration 6:02:05
- Release Date 2025/06/03
