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

Codecademy

Learn SQL

via Codecademy

Overview

Learn to communicate with databases using SQL, the standard data management language.

### Why Learn SQL?

We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for almost everyone.

### Take-Away Skills:

In this course, you'll learn how to communicate with relational databases through SQL. You'll learn—and practice with 4 projects—how to manipulate data and build queries that communicate with more than one table.

Syllabus

  • Manipulation: Learn how to use SQL to access, create, and update data stored in a database.
    • Lesson: Manipulation
    • Quiz: Manipulation
    • Project: Create a Table
    • Article: What is SQLite?
  • Queries: Perform more complex queries by learning essential query keywords and functionality
    • Lesson: Queries
    • Quiz: Queries
    • Project: New York Restaurants
  • Aggregate Functions: Learn powerful functions for performing complex database operations with ease.
    • Lesson: Aggregate Functions
    • Quiz: Aggregate Functions
    • Project: Trends in Startups
    • Project: Analyze Hacker News Trends
  • Multiple Tables: Expand your SQL skills by creating and manipulating databases with multiple related tables
    • Lesson: Multiple Tables
    • Project: Lyft Trip Data
    • Quiz: Multiple Tables

Taught by

Nik Stern

Reviews

4.6 rating at Codecademy based on 20480 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.