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

Boot.dev

Learn SQL

via Boot.dev

Overview

Stuck in Tutorial Hell? Learn Backend Dev the Right Way
Boot.dev teaches Python, SQL & Go through projects you won't want to stop. 25% off with code CLASSCENTRAL.
Get 25% Off
Learn SQL by querying real relational data. Practice SELECT, joins, filters, aggregations, table design, and database fundamentals.

Syllabus

  • Introduction
    • Learn about the basics of SQL and how it came to be
  • Tables
    • Create new tables and learn how to structure data efficiently
  • Constraints
    • Learn how to keep data accurate and up to date
  • CRUD
    • Create, read, update and delete information from a SQL database
  • Basic Queries
    • Practice additional clauses and features that SQL offers for more flexible querying
  • Structuring
    • Learn how to order and limit the data returned in large query sets
  • Aggregations
    • Learn how to run powerful calculations on entire datasets
  • Subqueries
    • Practice the advanced technique of nesting queries inside one another
  • Normalization
    • Learn how to normalize a database in order to keep it's data consistent and accurate
  • Joins
    • Practice joining multiple tables together in order to power real world usecases
  • Performance
    • Learn how to keep databases running fast and efficient in production

Reviews

4.8 rating at Boot.dev based on 1692 ratings

Start your review of Learn 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.