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.
The University of Colorado is a recognized leader in higher education on the national and global stage. We collaborate to meet the diverse needs of our students and communities. We promote innovation, encourage discovery and support the extension of knowledge in ways unique to the state of Colorado and beyond.
- 5 stars70.31%
- 4 stars22.30%
- 3 stars3.67%
- 2 stars1.43%
- 1 star2.27%
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.
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.
Dr. Mannino is an excellent teacher. The numerous practice exercises were most useful in adding to the learning and to the understanding of the concepts. Thank you!
An excellent course to start with. Great for people who are just starting to learn database as well as for those who want to refresh their knowledge regarding the subject.
關於 面向商业智能的数据仓库 專項課程
Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics.