The Ultimate Modern SQL Course – 2024/25

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