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.27%
- 4 stars22.29%
- 3 stars3.64%
- 2 stars1.45%
- 1 star2.32%
The course is well structured and the tools used for building the conceptual model are quite user friendly. The course has given a better understanding of the database management systems.
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.
Fair enough. Good material and content for someone new or that needs to remember basic concepts about databases. Not needed if the main focus is DWH and experience with DB exists
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.
关于 面向商业智能的数据仓库 专项课程
Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics.