Database Management Essentials

Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics.This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You'll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You'll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of MicroStrategy, a leading BI

( 153 Reviews )

Created by: Michael Mannino

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

Live Chat with CourseDuck's Co-Founder for Help

Need help deciding on a data science course? Or looking for more detail on Michael Mannino's Database Management Essentials? Feel free to chat below.

Join CourseDuck's Online Learning Discord Community

Course Description

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 or MySQL 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 or MySQL.

Time: 28h

Instructor Details

Michael Mannino

4.5 Rating
153 Reviews

My involvement with database technology and education spans more than 35 years in academic positions, research, and consulting. I have been a faculty member at the University of Florida, University of Texas at Austin, and University of Washington before joining the Business School at the University of Colorado Denver. My work in this specialization is a culmination of teaching data warehouse development for 15 years along with writing a supporting textbook and conducting research projects. In my teaching, It is my pleasure and privilege to share my excitement and extensive background to help you embark on an adventure towards a rewarding and challenging career as a data warehouse or business intelligence professional.

The Data Scientist's Toolbox (2019)

5.0 (148 Reviews)

Provider: Coursera
Time: 8h

Free

Python for Data Science (2017)

4.4 (9 Reviews)

Provider: edX

Free

Python A-Z: Python For Data Science With Real Exercises! (2022)

4.4 (150 Reviews)

Provider: Udemy
Time: 11h

$10.44

More Courses

Reviews

4.5

153 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Judith G on 22-Feb-19

Almost exclusively peer marked assessment and although you can learn from peer marking there is no incentive for other people to mark your work properly. Many people just appear to give everything full marks and the comment "great" or "nice" or even just a full stop to meet the comment requirement. When not giving full marks not one person put a comment to explain why they haven't given full marks and if the person marking your work doesn't fully understand the material they are just as likely to mark it correct when it is not as they are not sure about the material.

By Zhu K on 17-Feb-19

This course provides the essential foundations that a rookie need to master partial SQL and the basic techniques for drawing entity relation diagrams. All in all, it's a good course to embark on your journey for exploring database. However, some part of the video is kind of redundant. There are three points that I would like to mention. First, The peer-evaluation system. In other CS course, a grading system is prepared to give marks on student's assignment, which is more objective; Second, this course provides a link to buy textbook, rather than providing student the access to free online resources; Third, week7 material, upon functional dependency and BCNF are not clearly elaborated.

By Yong Y on 20-May-18

The course is very intense, need a lot of practice. A little boring when I took this course, course the tutorial and the forms of the course if boring for me. But you can quiet a lot about basic sql syntax and ERD modeling. And the assignment is not well designed, the classmate reviews take a lot of time , should be improved, like each assignment just upload one file, should do some automatic tools for the assignment reviews.

By Sylvain L on 9-Mar-16

Not enough implication from the instructors in the course. Students are left alone with the material, without any answers to there questions on the course.Peer review process subject to personal interpretation and leading to frustration for the students.That's quite unfortunate as this provides a bad experience whereas the course might have been good without that.

By Quinten B on 13-Jun-17

Personally they should add a free textbook and a vocabulary list with clear examples.So yes this course could benefit from more detail time to time

By Kostas A on 2-Jan-19

Avoid this course by all means. This is absolutely the worst course that I have ever enrolled and seriously I still can't understand how coursera allows such courses to exist. The material is very basic and it has a single reference for a paid book but the absolutely worst part is that the GRADING SYSTEM DEPENDS ON THE AVERAGE EVALUATION OF TWO OTHER RANDOM CLASSMATES. So you realize that even if your submission is perfect you end up getting random grades depending on the mood of your classmates and you can't do anything about it. I have just added University of Colorado in my blacklist because seriously this course is a disgrace for online courses.

By yoav z on 22-Mar-19

excellent content. the forum is dead and there are some mistakes in the school solution that couldn't be address for that reason. 5 start for content, 1 star for staff participation and discussion forum.

By Qin Q on 31-Oct-17

This course covered basic information. However, the organize about assignments is horrible. Tables format change from time to time, and the solution does not even match with questions.

By Eileene K G on 13-May-16

Do not be fooled by the course description. You do need to know some basics before attempting the course. Be prepared to look a lot of things up independently or purchase the "optional" text book. There is virtually no moderator in this course and the instructor does not grade or comment on the discussions. Basically he is reading you PowerPoint slides and adding very little to the lesson by watching and listening to him do so. Your grades are based on what your peers (who are also trying to learn) think or interpret the correct answer to be based on their limited knowledge and discretion. I would not recommend this course for someone wishing to learn SQL as it is not the main focus, it is only a small part of the lessons.

By Elliott L on 24-Mar-19

A lot of fluff is included, but taught the basics of SQL and entity relationship diagrams and normalisation, which to be pretty integral parts of understanding databases in a practical sense.

By Julien L on 23-Aug-18

A very boring way to bring up the subject.

By John M on 26-Feb-16

I found the content was great but the style of lectures were a bit too robotic and not conversational. This didn't help the learning process. Also, the course admin might consider explaining 'On' 'And' 'Where' 'TIMESTAMP', 'DateDiff' more than what was provided.