Back to Learning Paths
Database & Data Engineering
Master data storage, processing, and analytics. Learn SQL, NoSQL databases, caching strategies, and data modeling for scalable applications.
13 Modules
Video Tutorials
Database Projects
Course Curriculum
Module 1: SQL Fundamentals
Master SQL queries, joins, and database operations.
- • SELECT, INSERT, UPDATE, DELETE
- • JOINs and Subqueries
- • Aggregations and GROUP BY
- • Indexes and Performance
Module 2: PostgreSQL
Work with PostgreSQL, the world's most advanced open-source database.
- • PostgreSQL Setup & Configuration
- • Advanced Data Types (JSON, Arrays)
- • Stored Procedures & Functions
- • Full-Text Search
Module 3: MongoDB & NoSQL
Build applications with MongoDB and understand NoSQL concepts.
- • Document-based Data Modeling
- • CRUD Operations & Queries
- • Aggregation Pipeline
- • Indexing & Performance Tuning
Module 4: Redis & Caching
Implement caching strategies with Redis for high-performance applications.
- • Redis Data Structures
- • Caching Patterns
- • Session Management
- • Pub/Sub Messaging
Module 5: Data Modeling & Design
Design efficient database schemas and data models.
- • Entity-Relationship Diagrams
- • Normalization & Denormalization
- • Schema Design Patterns
- • Database Migrations
Module 6: Database Optimization
Optimize database performance and query execution.
- • Query Optimization Techniques
- • Index Strategies
- • Connection Pooling
- • Performance Monitoring