Introduction to Modern Databases *

Databases

Beginner

59 Lessons

1h

Certificate of Completion

Databases

AI-POWERED

Explanations

AI-POWERED

Explanations
Course Overview
Course Content

Course Overview

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 consist...Show More

Course Content

1.

Introduction to Databases

Get an introduction to databases.
Data vs. Information
What Databases Really Are
From Files to Clouds
Flat Files
Relational Databases
Relational vs. NoSQL
NoSQL & Cloud
2.

Database Models and Architectures

Explore essential database concepts.
Understanding Schema
Understanding Instance
Schema vs. Instance
Three Views of Database Architecture
Data Independence
Logical Data Independence
Physical Data Independence
Inside the DB Engine
3.

Relational Model

Explore relational database fundamentals.
Tables, Rows, Columns
Why Keys Matter
The Primary Key
The Foreign Key
Integrity Constraints
Entity Integrity Constraint
Referential Integrity Constraint
Domain Integrity Constraint
Constraints Quiz
4.

Entity-Relationship Modeling

Master effective database design through ER modeling.
ER Models in Plain Words
Reading Crow’s Foot
From ER to Tables
5.

SQL Fundamentals

Master SQL fundamentals for effective database handling.
SQL: What, Not How
DDL vs. DML
Anatomy of SELECT
Filtering Rows with WHERE
Handling NULLs Correctly
Joining Tables Together
Inner Join Basics
Left Join Basics
Grouping and Aggregates
Filtering Aggregates Example
Subqueries
Conditional Logic in SQL
CASE statement
The IF function
6.

Schema Design and Normalization

5 Lessons

Master the database design process.
7.

Transactions and Concurrency Control

8 Lessons

Master transaction management for robust databases.
8.

NoSQL Databases Overview

3 Lessons

Explore NoSQL databases for efficient data management.
9.

Conclusion

2 Lessons

Review the concepts learned in the course.

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

Evan Dunbar

ML Engineer

Carlos Matias La Borde

Software Developer

Souvik Kundu

Front-end Developer

Vinay Krishnaiah

Software Developer

Eric Downs

Musician/Entrepeneur

Kenan Eyvazov

DevOps Engineer

Souvik Kundu

Front-end Developer

Eric Downs

Musician/Entrepeneur

Anthony Walker

@_webarchitect_

Evan Dunbar

ML Engineer

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

AI Prompt

Build prompt engineering skills. Practice implementing AI-informed solutions.

Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath