AI-powered learning
Save this course
Introduction to Modern Databases
Master modern databases in this hands-on course as you learn to design, manage, and optimize systems while gaining practical expertise across SQL and NoSQL technologies.
4.9
62 Lessons
9h
Updated yesterday
Join 2.9 million developers at
Join 2.9 million developers at
LEARNING OBJECTIVES
- An understanding of database concepts, models, and architectures, including relational and NoSQL systems
- A working knowledge of ER modeling, relational schema design, and normalization techniques
- Hands-on experience writing SQL queries using DDL, DML, joins, subqueries, and window functions
- The ability to model, create, and query relational databases while ensuring data integrity and performance
- Familiarity with core database components such as transactions, indexing, query optimization, and concurrency control
- An understanding of when and how to apply different database types based on use cases and performance needs
Learning Roadmap
1.
Introduction to Databases
Introduction to Databases
Master essential database concepts, types, and evolution for effective data management.
2.
Database Models and Architecture
Database Models and Architecture
Explore essential database concepts, including models, schemas, architecture, and DBMS components.
3.
Relational Model
Relational Model
5 Lessons
5 Lessons
Explore relational database fundamentals, keys, integrity constraints, and Codd’s principles.
4.
Entity-Relationship Modeling
Entity-Relationship Modeling
5 Lessons
5 Lessons
Master effective database design through ER modeling, relationships, and mapping techniques.
5.
SQL Fundamentals
SQL Fundamentals
8 Lessons
8 Lessons
Master SQL fundamentals, including data management, querying, and set operations for effective database handling.
6.
Relational Algebra and Relational Calculus
Relational Algebra and Relational Calculus
5 Lessons
5 Lessons
Master relational algebra, join operations, and calculus for effective database querying.
7.
Advanced Database Concepts
Advanced Database Concepts
6 Lessons
6 Lessons
Master advanced SQL techniques for effective data analysis and insightful reporting.
8.
Schema Design and Normalization
Schema Design and Normalization
6 Lessons
6 Lessons
Master the database design process, focusing on normalization and performance optimization techniques.
9.
Transactions and Concurrency Control
Transactions and Concurrency Control
6 Lessons
6 Lessons
Master transaction management, ACID principles, and concurrency strategies for robust databases.
10.
Indexing and Query Optimization
Indexing and Query Optimization
6 Lessons
6 Lessons
Enhance database performance through indexing, query optimization, and efficient data management techniques.
11.
NoSQL Databases Overview
NoSQL Databases Overview
5 Lessons
5 Lessons
Explore NoSQL databases, their types, and MongoDB for efficient data management.
Certificate of Completion
Showcase your accomplishment by sharing your certificate of completion.
Complete more lessons to unlock your certificate
Developed by MAANG Engineers
ABOUT THIS COURSE
Modern databases are at the heart of nearly every application, powering everything from small websites to enterprise systems. Understanding how to design, manage, and optimize these systems is a critical skill for developers and data professionals. In this course, you’ll start by exploring foundational database concepts, models, and architectures, including relational and NoSQL systems.
You’ll then move into ER modeling, relational schema design, and normalization techniques to ensure efficient and consistent data structures. Next, you’ll gain hands-on experience writing SQL queries using DDL, DML, joins, subqueries, and window functions. You’ll also dive into transactions, indexing, query optimization, and concurrency control to build performant and reliable systems.
By the end of the course, you’ll have the ability to model, create, and query relational and NoSQL databases confidently. You’ll understand when and how to apply different database types based on real-world use cases.
Trusted by 2.9 million developers working at companies
A
Anthony Walker
@_webarchitect_
E
Evan Dunbar
ML Engineer
S
Software Developer
Carlos Matias La Borde
S
Souvik Kundu
Front-end Developer
V
Vinay Krishnaiah
Software Developer
Built for 10x Developers
No Passive Learning
Learn by building with project-based lessons and in-browser code editor
Personalized Roadmaps
The platform adapts to your strengths & skills gaps as you go
Future-proof Your Career
Get hands-on with in-demand skills
AI Code Mentor
Write better code with AI feedback, smart debugging, and "Ask AI"
MAANG+ Interview Prep
AI Mock Interviews simulate every technical loop at top companies
Free Resources
