SQL Tutorials

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

All Posts

TCL Statements in SQL: How to Manage Database Transactions?

SQL Tutorials

TCL Statements in SQL: How to Manage Database Transactions?
DCL In a Nutshell: A Brief Look into the SQL Data Control Language

SQL Tutorials

DCL In a Nutshell: A Brief Look into the SQL Data Control Language
A Beginner’s Guide to DML in SQL

SQL Tutorials

A Beginner’s Guide to DML in SQL
Getting Started with DDL in SQL: A Brief Overview

SQL Tutorials

Getting Started with DDL in SQL: A Brief Overview
Basic Database Terminology

SQL Tutorials

Basic Database Terminology
Database vs Spreadsheet: What’s the Difference?

SQL Tutorials

Database vs Spreadsheet: What’s the Difference?
What Are Joins?

SQL Tutorials

What Are Joins?
MySQL vs PostgreSQL: An Open Source Battle

SQL Tutorials

MySQL vs PostgreSQL: An Open Source Battle
How to Use SQL’s Limit Statement?

SQL Tutorials

How to Use SQL’s Limit Statement?
Solving a Business Task in SQL and Visualizing it in Tableau

SQL Tutorials

Solving a Business Task in SQL and Visualizing it in Tableau
How to Set up a Database in SQL

SQL Tutorials

How to Set up a Database in SQL
Data Manipulation: Integrating SQL and Tableau

SQL Tutorials

Data Manipulation: Integrating SQL and Tableau
When to Use the SQL CASE Statement

SQL Tutorials

When to Use the SQL CASE Statement
Working with Indexes in MySQL

SQL Tutorials

Working with Indexes in MySQL
Introduction to SQL Views

SQL Tutorials

Introduction to SQL Views