SQL & Databases

1

Introduction to SQL

Understand relational databases, SQL syntax, and database management systems.

beginner

2

SELECT and Filtering

Query data from tables with SELECT, WHERE, and comparison operators.

beginner

3

Sorting and Limiting

Order results with ORDER BY and limit output with LIMIT and OFFSET.

beginner

4

Aggregate Functions

Summarize data with COUNT, SUM, AVG, MIN, MAX, and GROUP BY.

beginner

5

Joins - INNER and OUTER

Combine data from multiple tables using different join types.

beginner

6

Subqueries

Write queries within queries for complex data retrieval.

intermediate

7

INSERT, UPDATE, DELETE

Modify data in tables with DML statements.

intermediate

8

CREATE TABLE and Constraints

Design tables with data types, primary keys, and foreign keys.

intermediate

9

Indexes

Improve query performance with indexes and understand their trade-offs.

intermediate

10

String and Date Functions

Manipulate text and dates with built-in SQL functions.

intermediate

11

Views

Create virtual tables with views for simplified data access.

intermediate

12

Transactions

Ensure data integrity with ACID transactions and isolation levels.

intermediate

13

Window Functions

Perform calculations across rows with OVER, PARTITION BY, and ROW_NUMBER.

advanced

14

Stored Procedures

Encapsulate reusable SQL logic in stored procedures and functions.

advanced

15

Query Optimization

Analyze and optimize slow queries with EXPLAIN, indexing strategies, and best practices.

advanced