Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Scrimba

Intro to SQL

via Scrimba

Overview

Want to work with data efficiently? SQL is the key!

SQL allows you to retrieve, analyze, and manage data—making it an essential skill for modern developers.

What is SQL?

SQL (Structured Query Language) is the standard language for working with relational databases. It allows you to store, query, and manipulate data with simple yet powerful commands.

With SQL, you can quickly find the information you need, filter large datasets, and even automate complex data tasks—all while keeping your data structured and accessible.

What are the use cases for SQL?

SQL is perfect for:

  • Querying databases to retrieve specific data

  • Analyzing trends and patterns in datasets

  • Managing and updating records in real time

  • Handling data for web apps, dashboards, and reports

  • Automating workflows with stored procedures and scripts

What you'll build

This course is designed for beginners looking for a clear, hands-on introduction to SQL.

As always on Scrimba, this course is interactive! You’ll write SQL queries for the database of a retro car store, all the while solving practical coding challenges and gaining the skills you need to work confidently with databases.

Learning objectives

By the end of the course, you will be able to:

  • Use SELECT to retrieve specific columns from a table

  • Filter results using the WHERE clause

  • Apply comparison operators including =, !=, <, and >

  • Combine filters with AND, OR, and NOT

  • Use LIKE, IN, and BETWEEN for advanced filtering

  • Sort results using ORDER BY

  • Limit output with the LIMIT clause

  • Aggregate data using COUNT, SUM, MAX, MIN, and AVG

  • Group results with GROUP BY and filter groups with HAVING

  • Insert, update, and delete records using INSERT INTO, UPDATE, and DELETE

...and loads more!

Prerequisites

This course is designed for absolute beginners—no prior experience with SQL or databases required.

However, it helps if you’re already comfortable with writing or reading a bit of code (e.g., JavaScript or Python)

If you've taken Scrimba's Learn JavaScript course, you’ll feel right at home. But even if you're brand new to programming, you’ll be able to follow along just fine!

Syllabus

  • Fundamentals of SQL
  • Creating and Joining Tables
  • Advanced Logic and Conditions

Reviews

Start your review of Intro to SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.