The Complete SQL Bootcamp: Master Modern SQL with Snowflake

Focused View

Tom Bailey

6:02:05

0 View

1 - Course Setup

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

2 - Introduction to SQL and Snowflake

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

3 - Data Definition Language (DDL)

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

4 - Data Manipulation Language (DML)

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

5 - Query Fundamentals

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

6 - Intermediate Querying

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

7 - SQL Performance Tuning

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

8 - Advanced SQL Features

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

9 - Processing Semi-structured Data

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

10 - Congratulations & Thank You!

1 -Congratulations & Thank You.mp4

00:32

Description

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

What You'll Learn?

The SQL language's history and context in the current data landscape
SQL Data Definition Language (DDL) commands: CREATE, USE, SHOW, DESCRIBE, DROP & ALTER
Experience working with and understanding both synthetic and real-world data
SQL 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
SQL 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
SQL Custom functions: User-defined Functions and Stored Procedures
Intermediate SQL Querying topics: Subqueries, Joining, Set Operators and many more

Who is this for?

This course is ideal for anyone looking to learn SQL to enhance their current job performance or pursue new career opportunities. SQL remains one of the most sought-after skills in today's job market.

Experienced technology professionals in the fields of Data Engineering, Data Science & Data Analysis looking to take their Cloud and SQL skills to the next level.

Professionals in data steward roles e.g. Project Managers. Getting closer to the technology can help make data-driven decisions and improve communication with technical team members.

University & high school students studying SQL for the first time.

What You Need to Know?

No prior programming experience required. Everything you need to become a SQL expert is contained in this all-in-one course.

No Snowflake experience required. A short crash course will be provided, along with a detailed hands-on getting you set up with a FREE account.

All you need is a browser for this course. Mac, PC and Linux users are all welcome.

More details

Description
Welcome to The Complete SQL Bootcamp: Master Modern SQL with Snowflake! 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!
We accomplish this using a FREE trial account provided by Snowflake, which takes just a few minutes to set up!

Why Choose This Course?
6+ hours of high-quality content comprised of bite-sized videos of around 5 minutes, so you get what you need without the fluff!
Theory lectures that include architectural diagrams, graphics, code snippets, and overview slides to bookmark and study.
Interactive hands-on content in the Snowflake UI with a focus on ANSI-standard SQL code.
Experience working with and understanding both synthetic and real-world data.
A folder full of SQL code to accompany hands-on videos that you can run, edit and share!
A review quiz at the end of each section to reinforce the practical and theoretical concepts you've just studied.
Learn SQL in the context of modern data challenges like Big Data and the Cloud.
The perspective of a SQL professional instructor through the Q&A section.
Earn a certificate of completion when you complete the course to showcase your expertise.

What Will You Cover?
1. Course Setup
Create a free Snowflake trial account.
Download the hands-on SQL code.
Learn study methods to help it all go in and stay in!
2. Introduction to SQL and Snowflake
Learn about SQL's historical context and how it fits into the modern data landscape.
Have a crash course on Snowflake, the cloud-native data platform we'll be using for the course.
Have an introduction to the technical aspects of the SQL language.
Additional database concepts like the object model and access control.
3. Data Definition Language (DDL)
Learn SQL statements used to create and modify objects: CREATE, USE, SHOW, DESCRIBE, DROP & ALTER.
Learn about Data Types.
Learn about Constraints.
Have an introduction to SQL Syntax Best Practices.
4. Data Manipulation Language (DML)
Learn about SQL statements to generate and modify data: INSERT, UPDATE, DELETE, TRUNCATE & MERGE.
Learn the process of loading large amounts of data with Snowflake features: Stages, File Formats, COPY INTO
.
5. Query Fundamentals
Learn the many individual clauses of the select statement in detail: SELECT, FROM, WHERE, ORDER BY, GROUP BY & HAVING.
Learn about scalar and aggregate SQL functions.
Have an introduction to User-defined functions.
6. Intermediate Querying
Learn to combine table attributes with the JOIN clause.
Learn to modularise our SQL code with Subqueries.
Learn about Set Operators to compare result sets.
Learn about Conditional Expressions to control the flow of our data.
Learn about the View database object.
Learn about how to convert from one data type to another with Casting.
7. SQL Query Performance
Learn about the database Order Of Execution to help conceptualise how the database engine processes statements.
Learn about best practices when using different SQL clauses:Â JOIN, ORDER BY, WHERE and GROUP BY.
Learn how to use the EXPLAIN command and Snowflake's Query Profile Tool.
Learn about Snowflake-specific features for improving query performance: Caching and Materialized Views.
8. Advanced SQL Features
Learn about Window Functions and Window Frames.
Learn about Common Table Expressions (CTEs) and Recursive CTEs.
Learn about Transactions.
Learn about Collation.
Learn about User-defined Functions (UDFs) and Stored Procedures.
9. Processing Semi-structured Data
Have a crash course into what semi-structured data is.
Learn how to load semi-structured data and what their unique considerations are.
Learn how to query and access semi-structured data.
Learn what functions are unique for accessing semi-structured data.
Learn what are the unique considerations for loading binary semi-structured data.Â

One last thing - I'd love to hear from you! Share your experience taking the course by messaging me on Udemy or through LinkedIn. You can find me by searching 'Tom Bailey â€¢ Udemy Instructor'.

Ready to transform your SQL skills? Enrol now to get lifetime access to this comprehensive course and start mastering SQL for the modern data landscape today!
Who this course is for:
This course is ideal for anyone looking to learn SQL to enhance their current job performance or pursue new career opportunities. SQL remains one of the most sought-after skills in today's job market.
Experienced technology professionals in the fields of Data Engineering, Data Science & Data Analysis looking to take their Cloud and SQL skills to the next level.
Professionals in data steward roles e.g. Project Managers. Getting closer to the technology can help make data-driven decisions and improve communication with technical team members.
University & high school students studying SQL for the first time.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Tom Bailey

Instructor's Courses

Hi! My name is Tom Bailey. Thanks for checking out my ‘About me’ section.I’ve worked in technology consulting for nearly a decade, helping a diverse range of clients in industries from automotive to consumer goods transform their business needs into robust technical solutions. I’ve assumed many roles during that time, but I’m primarily interested in cloud data & software engineering!As a consultant I’ve had to move from project to project, which always brings with it the necessity and opportunity to learn. This is one aspect of my job that I've always loved, picking up new technologies, learning their ins and outs and delivering a creative and practical solution.I’ve worked with early big data systems like Cloudera, HorntonWorks, HBase and Spark and more recently streaming & cloud technologies like Amazon Web Services, Apache Kafka and Snowflake. I’ve been fortunate enough to earn: - the AWS Certified Developer Associate certification, - the Confluent Certified Developer for Apache Kafka certification, - Snowflake’s SnowPro Core certification and - Snowflake’s SnowPro Advanced Data Engineer certification.Learning coupled with regularly hosting demonstrations and brown-bag sessions really ignited in me a passion for teaching. My personal teaching methodology leans more towards emphasising and building real-world skills, not just reciting facts.It brings me a lot of joy to help others excel in their career and see them thrive, so please reach out if you’ve taken one of my courses, I’d love to hear from you. The best way to do that is to message me on LinkedIn or tag me in a post telling me about your experience with the course or the result of a certification you’re going for.Thanks for taking the time to get to know me. If you’d like to get in touch, please do not hesitate.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.