This course introduces database concepts as related to the design of online data systems. This course will focus on the design and use of the MySQL relational database and Structured Query Language (SQL). Problems involving structuring, creating, maintaining, and accessing multi-user databases are presented and solutions developed. Comparisons of several commercially available database management systems are made including NoSQL systems.
Database Management Systems
Gain insight into a topic and learn the fundamentals.
Intermediate level
Some related experience required
25 hours to complete
3 weeks at 8 hours a week
Flexible schedule
Learn at your own pace
Skills you'll gain
Details to know
Recently updated!
May 2025
Assessments
35 assignments
Taught in English
See how employees at top companies are mastering in-demand skills
There are 6 modules in this course
Module 1 includes lectures on database design, database evolution, and the power of database management systems. After reading Chapter 1 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 1 Application and Module 1 Quiz (only 1 attempt each).
What's included
4 videos5 readings4 assignments1 discussion prompt
Module 2 includes lectures on data modeling, the evolution of data models, and data model abstraction. After setting up LucidChart, reading Chapters 2 and 9, and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 2 Application and Module 2 Quiz (only 1 attempt each).
What's included
3 videos4 readings5 assignments
Module 3 includes lectures on relational database models, operators, data dictionary and system catalog, entities and relationships, and data redundancy. After reading Chapter 3 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 3 Application and Module 3 Quiz (only 1 attempt each).
What's included
6 videos2 readings5 assignments
Module 4 includes lectures on entity relationships, entity participation and degrees in relationships, developing an Entity Relationship (ER) diagram, and a Module Review. After reading Chapter 4 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 4 Applications (2 attempts each) and Module 4 Quiz (only 1 attempt).
What's included
5 videos2 readings9 assignments
Module 5 includes lectures on Extended Entity Relationship (EER) model constructions, good primary keys, flexible solutions, and a Module Review. After reading Chapter 5 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 5 Application and Module 5 Quiz (only 1 attempt each).
What's included
4 videos2 readings8 assignments
Module 6 includes lectures on normalization, normal forms and transformations, applying normalization roles to tables, denormalization, and ERD data-modeling checklists. After reading Chapter 6 and watching the lectures, check your understanding with the Practice Exercises. Use the feedback from the Practice Exercises to complete the Module 6 Application and Module 6 Quiz (only 1 attempt each).
What's included
7 videos5 readings4 assignments
Instructor
Offered by
Why people choose Coursera for their career
Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
New to Software Development? Start here.
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.