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.42%
- 4 stars22.21%
- 3 stars3.63%
- 2 stars1.43%
- 1 star2.29%
TOP REVIEWS FROM DATABASE MANAGEMENT ESSENTIALS
Very good to every beginner out there trying to get into database management , tasks are really educational , only the normalization section needs more clarification. but as a total it is awesome
It has been an completely endearing experience. The course does provide us a perfect picture of the topic. The lessons curated were easy to understand and learn.
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.
Since this is a prerequisite in our course, this class helped me a lot. I've learned things that I did not understand or encountered in my University. Thank you!
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?
Is financial aid available?
More questions? Visit the Learner Help Center.