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