Intro to SQL

Overview

Discover how to build efficient, data-driven applications using SQL, the essential database language. In this interactive Scrimba course, you'll write SQL queries against the database of a retro car store, solving practical coding challenges and improving your muscle memory as you go. In Section One, you’ll discover the core building blocks of SQL by writing real queries against real data. You’ll cover everything from SELECT statements and filtering with WHERE, to sorting, grouping, and basic data manipulation with INSERT, UPDATE, and DELETE. Section Two goes beyond single-table queries. You’ll learn how to work with relational data, including creating and modifying tables, populating them with data, and using different types of joins to combine data across tables. Finally, Section Three introduces more advanced logic, showing you how to use ANY, ALL, and EXISTS for powerful subqueries, and how to apply CASE expressions in SELECT, WHERE, and UPDATE clauses to create dynamic, flexible queries. By the end, you’ll have built a solid foundation in SQL and developed the skills to work effectively with real-world databases.

Syllabus

SQL Basics & Data Selection

Learn the fundamentals of SQL and how to select, filter, and combine data using a variety of logical and comparison operators.

Sorting, Aggregation & Data Manipulation

Advance your SQL skills by mastering sorting, aggregating, and modifying data, and wrapping up with practical challenges and a course recap.

Creating and Joining Tables

Go beyond single-table queries and learn how to work with relational data. This module covers creating and modifying tables, populating them with data, and using different types of joins to combine data across tables.

Advanced Logic and Conditions

In this module, you’ll learn how to use ANY, ALL, and EXISTS for powerful subqueries, and apply CASE expressions in SELECT, WHERE, and UPDATE clauses to create dynamic, flexible queries.