SQL Fundamentals

Engine-agnostic SQL — querying, complex joins, subqueries and common table expressions.

4 courses Beginner · Intermediate

Beginner

1 course

Introduction to SQL

SQL is different from other programming languages — and that's precisely what makes it so valuable.

Beginner

Intermediate

3 courses

Perform Complex JOINS in SQL

This course covers the execution of complex JOINs in SQL. It is aimed at people who already master the fundamentals of SQL JOINs and wish to deepen their knowledge with advanced technique...

Intermediate

Simplify SQL Queries with Common Table Expressions (CTEs)

A CTE (Common Table Expression) is a temporary result set that can be used inside a SELECT, INSERT, UPDATE or DELETE query. CTEs are comparable to subqueries, but with increased flexibility.

Intermediate

Write Complex Subqueries in SQL

subqueries are essential for performing complex filtering, aggregation, and comparisons that go beyond the capabilities of basic SQL JOIN. They allow queries to be nested inside other que...

Intermediate

Interested in SQL Fundamentals?

Get in Touch Back to Databases & SQL