Start Here
Learn SQL start here with practical examples and guided drills on dbSyntax.
Start with What is a database?What is a database?
BeginnerA database is an organized collection of data stored in a way that makes it easy to: Add new data Find data Update data Delete data Think of...
What is SQL?
BeginnerSQL stands for Structured Query Language. If a database is where data lives, SQL is how you ask it questions. It is one of the fastest ways ...
SQL syntax
BeginnerGood SQL is rarely about clever tricks. Most of the time, it is about getting structure right: what to select, where it comes from, how it i...
SQL datatypes
BeginnerA column name tells you what a value represents. Its datatype tells the database how that value should behave....
How to run queries (tooling)
BeginnerWriting SQL is only half of the skill. The other half is running queries in a clean loop: write, run, inspect, and refine. This lesson shows...
How to read tables/ERDs
BeginnerReading tables and ERDs is the fastest way to understand an unfamiliar dataset. Before writing complex SQL, you should know table grain, key...