Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy. As you develop these skills, you will use either Oracle, MySQL, or PostgreSQL to execute SQL statements and a database diagramming tool such as the ER Assistant or Visual Paradigm to create ERDs. We’ve designed this course to ensure a common foundation for specialization learners. Everyone taking the course can jump right in with writing SQL statements in Oracle, MySQL, or PostgreSQL.
This course is part of the Data Warehousing for Business Intelligence Specialization
About this Course
Skills you will gain
- Database (DB) Design
- Entity–Relationship (E-R) Model
- Database (DBMS)
Syllabus - What you will learn from this course
Introduction to Databases and DBMSs
Relational Data Model and the CREATE TABLE Statement
Basic Query Formulation with SQL
Extended Query Formulation with SQL
- 5 stars70.44%
- 4 stars22.19%
- 3 stars3.63%
- 2 stars1.43%
- 1 star2.29%
TOP REVIEWS FROM DATABASE MANAGEMENT ESSENTIALS
Course Is Good One must take this course in order to get background knowledge of DBMS essentials basic query formation and ER Diagrams ER Diagrams is one that must be carefully study.
This is a great course! THANK YOU VERY MUCH COURSERA AND UNIVERSITY OF COLORADO SYSTEM TEAM! Especially to the professor that taught here in this course. Thank you.
Of all the database courses I have ever done, this one covers the concepts best and exhaustively. I highly recommend it to all beginners and advanced users who want to review the basics.
The DBMS concepts explained in this course, such as ERD design, schema conversion and normalization are very good and has given a good foundational understanding to me.
About the Data Warehousing for Business Intelligence Specialization
Frequently Asked Questions
When will I have access to the lectures and assignments?
What will I get if I subscribe to this Specialization?
What is the refund policy?
Is financial aid available?
More questions? Visit the Learner Help Center.