SQL & Databases

Understanding relational databases, query design, and performance.

16 Topics6 Milestones

MilestoneTopic

SQL Basics

◆

Milestone

SELECT, JOINs, WHERE

◆

Milestone

Schema Design

◆

Milestone

Normalization

◆

Milestone

Indexing & Performance

◆

Milestone

Transactions & ACID

Subqueries

Aggregate Functions & GROUP BY

Views

Constraints (PK/FK/Unique)

Stored Procedures

optional

Database Design Patterns

Window Functions

Query Optimization

Backup & Recovery

◆

Milestone

When to Use NoSQL vs SQL

Tap any node to see details

Ready to start your journey?

Join thousands of learners who are advancing their careers with Pen Global Academy.