Databases
Master relational and NoSQL databases. SQL, database design, query optimization, and integrating databases into applications.
Course Curriculum
Module 1
SQL Fundamentals
SELECT, INSERT, UPDATE, DELETE, JOINs, and subqueries. Query relational databases with confidence.
Module 2
Advanced SQL
Window functions, CTEs, stored procedures, triggers, and complex query optimization techniques.
Module 3
Database Design & Modeling
ER diagrams, normalization, schema design, and translating business requirements into robust data models.
Module 4
Database Performance
Indexing strategies, query plan analysis, caching, and scaling databases under production load.
Module 5
Database Integration & APIs
Connecting databases to applications, ORMs, connection pooling, and building data-driven APIs.
Module 6
MySQL & MariaDB
Deep-dive into MySQL and MariaDB. Installation, configuration, replication, and production best practices.
Module 7
Data Warehousing
OLAP, star schemas, ETL pipelines, and analytical query patterns for business intelligence workloads.
Module 8
Database APIs
GraphQL, REST, and RPC patterns for exposing database data. Pagination, filtering, and security.
Module 9
Database Administration
Database Administration (19 lessons)
Module 10
Nosql Databases
Nosql Databases (21 lessons)