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.48%
- 4 stars22.22%
- 3 stars3.60%
- 2 stars1.41%
- 1 star2.25%
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.
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!
I Bhavin Khandelwal complete this course and i declares that i will very very enjoy this course and i improve my knowledge about this course and also in Database Management Essentials.
Excellent introduction to DB Management, I learned everything that I wanted to learn from it. I highly recommend it and actually I am already enrolled to the next course of the specialization.
关于 面向商业智能的数据仓库 专项课程
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 tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the final Capstone Project, you’ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.