Index structures, query plans, and optimizing queries.

Tools

Visual Studio Code

Weeks

Week 0 Week 1 - Introduction to Databases Week 2 Week 3 Week 4 Week 5

Courses

Artificial Intelligence Database Systems Introduction to Computer Science Python Programming Web Development

UET Learning Course

Tools

UET Duck AI
VS Code

Gradebook
Syllabus

Weeks

Week 0
Week 1
Week 2
Week 3
Week 4
Week 5

Courses

Artificial Intelligence
Database Systems
Introduction to Computer Science
Python Programming
Web Development

Week 3 - Indexing & Performance

Week 3

Index structures, query plans, and optimizing queries.

Indexing & Performance

Explain B-trees and how indexes help queries; practice analyzing EXPLAIN output.