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

Created by: Tom Bailey
Instructor • AWS, Kafka & Snowflake Certified Developer

What Will I 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

Requirements

• 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.

Target audience

• 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.