Back to Courses
Intermediate Database Administration en

Learn Intermediate SQL

Educative
Platform · Washington, USA

About this course

In this intermediate SQL course, you’ll explore Structured Query Language (SQL) through hands-on, project-based lessons. You’ll start with core SQL queries such as SELECT, WHERE, AND, OR, NOT, and string handling, then progress to DISTINCT, ORDER BY, GROUP BY, and aggregate functions. You’ll learn to create, describe, insert into, update, delete, and alter tables, use aliases, and minimize data redundancy with foreign keys. Finally, you’ll master joins, subqueries, and cartesian products to extract and manipulate data across multiple tables and generate comprehensive reports.

Prerequisite Skills

Skills you should have before taking this course

Basic programming concepts Basic SQL Basic relational database concepts

Skills Gained

Skills you will develop by completing this course

SQL SQL joins SQL subqueries Relational databases SQL querying SQL aggregate functions SQL data modeling with foreign keys SQL table design and manipulation

Related Courses