The Ultimate Modern SQL Course – 2024/25
Free Download The Ultimate Modern SQL Course - 2024/25
Published 10/2024
Created by Tom Bailey
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 96 Lectures ( 6h 2m ) | Size: 1.72 GB
All-in-one course for mastering SQL syntax and features with Snowflake, designed for the modern data landscape!
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
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.
Description:
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!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 SetupCreate 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 SnowflakeLearn 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 dаta: INSERT, UPDATE, DELETE, TRUNCATE & MERGE.Learn the process of loading large amounts of data with Snowflake features: Stages, File Formats, COPY INTO
