Beginner SQL
Beginner SQL Lessons
Browse every beginner SQL topic, organized into 5 practical learning paths.
SQL Foundations
SELECT, FROM, aliases, DISTINCT
- Introduction to SQL
- The SQL Tutorial for Data Analysis
- How SQL Queries Work
- SQL Query Execution Order
- SQL SELECT
Filtering Data
WHERE, AND/OR, IN, BETWEEN, LIKE
Sorting & Limiting
ORDER BY, LIMIT, OFFSET, pagination
Aggregate Functions
COUNT, SUM, AVG, MIN, MAX
Data Types & Casting
types, CAST, PostgreSQL ::