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.23%
- 3 stars3.60%
- 2 stars1.41%
- 1 star2.25%
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
This course is having very knowledgeable content. It was having various factors which developed my thinking ability and how to execute the queries. This was absolutely beneficial for me.
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.
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.
關於 面向商业智能的数据仓库 專項課程
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.