SQL Tutorials

Advance your relational databases and SQL knowledge with a series of hands-on tutorials.

All Posts

Learning How to Use the SQL SELF JOIN

SQL Tutorials

Learning How to Use the SQL SELF JOIN
How to Write SQL Subqueries

SQL Tutorials

How to Write SQL Subqueries
Working with the LEFT JOIN in SQL

SQL Tutorials

Working with the LEFT JOIN in SQL
Introducing the RIGHT JOIN in SQL

SQL Tutorials

Introducing the RIGHT JOIN in SQL
What are Duplicate Records in SQL

SQL Tutorials

What are Duplicate Records in SQL
A Few Notes on the Joins Syntax in SQL

SQL Tutorials

A Few Notes on the Joins Syntax in SQL
How to Create an Inner Join in SQL

SQL Tutorials

How to Create an Inner Join in SQL
Introduction to SQL Joins

SQL Tutorials

Introduction to SQL Joins
Deciding When to Use WHERE or HAVING

SQL Tutorials

Deciding When to Use WHERE or HAVING
How to Use the SQL ORDER BY Clause

SQL Tutorials

How to Use the SQL ORDER BY Clause
How to Use the SQL GROUP BY Clause

SQL Tutorials

How to Use the SQL GROUP BY Clause
First Steps into Data Manipulation and Operators in SQL

SQL Tutorials

First Steps into Data Manipulation and Operators in SQL
Unique Key and Null Values

SQL Tutorials

Unique Key and Null Values
Relationships between Tables in SQL

SQL Tutorials

Relationships between Tables in SQL
SQL Foreign Key

SQL Tutorials

SQL Foreign Key