Skip to main content

Course

Learn SQL Basics

Learn SQL, a standard data management language to manage, manipulate, and analyze large datasets.

  • Level: Beginner
  • Duration: 1 month
  • Type: Interactive
  • Language: English
  • Practice Problems: 60+
  • Quizzes: 30+
Enroll for FREE

Course Content

  • 1.1 Getting Started
  • 1.2 SQL SELECT

  • 2.1 Filtering in SQL
  • 2.2 SELECT WHERE
  • 2.3 AND, OR, and NOT
  • 2.4 IN and BETWEEN
  • 2.5 LIKE
  • 2.6 Wildcards
  • 2.7 LIMIT
  • 2.8 Recap: Filter Records

  • 3.1 SQL Aggregate Functions
  • 3.2 MIN() and MAX()
  • 3.3 COUNT()
  • 3.4 SUM() and AVG()
  • 3.5 Recap: SQL Aggregate Functions

  • 4.1 Organizing in SQL
  • 4.2 ORDER BY
  • 4.3 GROUP BY
  • 4.4 HAVING
  • 4.5 SQL CASE
  • 4.6 Recap: Organize Records

  • 5.1 SQL JOINs
  • 5.2 INNER JOIN
  • 5.3 LEFT JOIN
  • 5.4 RIGHT JOIN
  • 5.5 FULL JOIN
  • 5.6 Recap: SQL JOINs

  • 6.1 Subquery
  • 6.2 Recap: SQL Subquery

  • 7.1 INSERT INTO
  • 7.2 UPDATE
  • 7.3 DELETE FROM
  • 7.4 Recap: Insert, Update, and Delete

  • 8.1 Working With Tables
  • 8.2 CREATE TABLE
  • 8.3 ALTER TABLE
  • 8.4 DROP TABLE
  • 8.5 Recap: Working With Tables

  • 9.1 Constraints
  • 9.2 NOT NULL Constraint
  • 9.3 UNIQUE Constraint
  • 9.4 PRIMARY KEY
  • 9.5 FOREIGN KEY
  • 9.6 Recap: Constraints

  • 10.1 SQL Window Functions
  • 10.2 Aggregate Window Functions
  • 10.3 Ranking Window Functions
  • 10.4 Analytic Window Functions
  • 10.5 Recap: SQL Window Functions

  • 11.1 SQL Views
  • 11.2 SQL Commands
  • 11.3 What's next?

SQL CERTIFICATION

Get SQL certified

Get your skills verified with our certification.

Showcase your expertise on LinkedIn and stand out from the crowd. Impress your potential employers.

Start this Course
Get Certified

Learn SQL by Doing

Build hands-on projects that mirror real developer challenges. Apply what you learn immediately — so you can learn by doing, not just watching.

A woman smiling at her desk

Looking to break into tech?

Landing your first job is difficult, but you don't have to figure it out alone.

Build real projects for your portfolio, earn certificates you can share, and follow a learning path that takes you from the basics to job-ready skills.

Frequently asked questions

You can start Learn SQL Basics with a 7-day free trial. Click "Enroll for FREE" to begin.

About 1 month. The course has 11 chapters.

No. Learn SQL Basics has no prerequisites. Level: Beginner.

Yes. Complete Learn SQL Basics to earn an SQL certificate with your name on it, which you can download or share on LinkedIn. Certificates are included with your subscription.