Track 10 of 14
Master database management. Learn SQL, relational design, and NoSQL databases for scalable applications.
SQL and database design are fundamental skills for any developer or data professional. In this comprehensive 12-week program, you'll master both relational and NoSQL databases.
From writing complex queries and designing normalized schemas to implementing indexing and optimization techniques, this course covers the complete spectrum of database management. You'll learn to handle large datasets efficiently and scale databases for production environments.
Write complex SQL queries and stored procedures
Design normalized relational database schemas
Implement indexes and optimize query performance
Master transactions and ACID properties
Work with NoSQL databases (MongoDB)
Implement database security and backup strategies
Handle data migrations and versioning
Optimize databases for scale and performance
₹7-12L
₹7-13L
₹8-14L
Week 1-2
• SELECT queries
• WHERE & filtering
• Joins
• Aggregation
Project: Query Analysis on Real Dataset
Week 3-4
• Subqueries
• Window functions
• CTEs
• Stored procedures
Project: Complex Multi-table Queries
Week 5-6
• Normalization
• Schema design
• ER diagrams
• Data types
Project: Design Database Schema
Week 7-8
• Indexing
• Query optimization
• Explain plans
• Caching
Project: Optimize Slow Queries
Week 9-10
• MongoDB
• Document models
• Aggregation
• Indexing
Project: Build NoSQL Application
Week 11-12
• Transactions
• Security
• Scaling
• Backup & recovery
Project: Capstone Database Project
Advanced open-source relational database
Advanced Level
Popular relational database management system
Advanced Level
Leading NoSQL document database
Intermediate Level
Universal database management tool
Intermediate Level