Overview of SQL Syntax

Structured Query Language (SQL) is used to interact with relational databases. Each SQL statement follows a logical structure.

  • SELECT - Choose columns
  • FROM - Define tables
  • WHERE - Filter rows
  • ORDER BY - Sort results
  • GROUP BY - Aggregate data

Let’s break down each component in detail in the following lessons.