← Back to Topics

SQL

SQL

Query, manage, and manipulate relational databases with structured commands.

34 Concepts Data & Databases 📖 Story-Based

⚠️

Error

← Back to Topics

SQL Foundations

Introduction to SQL

SQL Data Types

DDL and Schema Operations

Constraints

Querying Basics

SELECT Statement

Filtering Data

Sorting and Limiting Results

NULL Handling and Conditionals

Data Manipulation

Data Modification

Aggregation and Grouping

Creating Tables from Queries

Multi-Table Queries

JOIN Types

Advanced JOIN Techniques

Subquery Fundamentals

Advanced Subqueries

Set Operations

Database Objects

Views

Indexes

Procedures and Functions

Triggers

Transactions

Transaction Basics

Isolation and Concurrency

Locking

Database Design

Normalization

Entity Relationship Modeling

Referential Integrity

Keys and Sequences

Advanced Functions

Built-in Functions

Window Functions

Advanced Window Functions

Common Table Expressions

Performance and Security

Query Performance

Access Control

SQL Injection Prevention