SQL Fundamentals
Back: Relational Databases
The core language for interacting with relational databases. SQL provides declarative syntax for defining schemas, querying data, and manipulating records. Understanding SQL deeply is essential for any backend engineer.
Concepts
- DDL (Data Definition Language)
- DML (Data Manipulation Language)
- Joins
- Subqueries
- Aggregation
- CTEs (Common Table Expressions)
- Set Operations