SQL References

SQL Aggregate Functions

Calculating values across rows

SQL Basics

Basic SQL commands and syntax

SQL DDL Commands

Data Definition Language - CREATE, ALTER, DROP

SQL DML Commands

Data Manipulation Language - INSERT, UPDATE, DELETE

SQL JOIN Operations

Combining data from multiple tables

SQL SELECT Statement

Querying data with SELECT

SQL String Functions

Working with text data

SQL Subqueries

Using nested queries

SQL WHERE Clause

Filtering data with WHERE