Back to catalog
ProgrammingBeginner

SQL from Scratch

SQL is the universal language of data. In this course you will learn how relational databases work and how to write queries with JOINs, filters, aggregations, and subqueries using PostgreSQL, one of the industry's most trusted engines.

13 lessonsCertificate includedFree
Create an account to start

Course syllabus

1

Introduction to databases

4 lessons
  • What is a database?
  • What is SQL?
  • Installing PostgreSQL
  • Your first table
2

SELECT - querying data

4 lessons
  • SELECT and FROM
  • WHERE - filtering data
  • ORDER BY and LIMIT
  • Aggregate functions
3

JOINs - connecting tables

3 lessons
  • INNER JOIN
  • LEFT and RIGHT JOIN
  • Multiple JOINs
4

Subqueries and final practice

2 lessons
  • Subqueries
  • Final project: Store analysis

What you will learn

SELECT and filtersJOINsAggregate functionsSubqueriesPostgreSQL

Certificate

SQL from Scratch Certificate - CumbreAcademy

Ready to start?

This course is free. You can access all of the material.

Create an account to start

Want access to every course?

Total Access gives you this course and all the others for $20/month.

This course: Free - Total Access: $20 USD/month (all courses)
See Total Access

What can you do after this course?

These are the recommended next steps for your learning path.

Programming

Python from Scratch

Beginner 路 6 weeks

FreeView course
Data

Data Analysis Foundations

Beginner 路 6 weeks

FreeView course
Data

SQL for Data Analysis

Intermediate 路 6 weeks

USD 5 (~ARS 5.000)View course

Enroll

Free
Create an account to start