- Pentaho
- Data Visualization (DataViz)
- Data Warehouse
- SQL
- Database (DB) Design
- Entity–Relationship (E-R) Model
- Database (DBMS)
- Extraction, Transformation And Loading (ETL)
- Data Integration
- Data Warehousing
- Materialized View
- Business Intelligence
面向商业智能的数据仓库 专项课程
Harness Business Data . Build a fully-optimized business data warehouse in five courses.
提供方


您将获得的技能
关于此 专项课程
面向相关领域的从业人员而设计面向相关领域从业人士。
面向相关领域的从业人员而设计面向相关领域从业人士。
专项课程的运作方式
加入课程
Coursera 专项课程是帮助您掌握一门技能的一系列课程。若要开始学习,请直接注册专项课程,或预览专项课程并选择您要首先开始学习的课程。当您订阅专项课程的部分课程时,您将自动订阅整个专项课程。您可以只完成一门课程,您可以随时暂停学习或结束订阅。访问您的学生面板,跟踪您的课程注册情况和进度。
实践项目
每个专项课程都包括实践项目。您需要成功完成这个(些)项目才能完成专项课程并获得证书。如果专项课程中包括单独的实践项目课程,则需要在开始之前完成其他所有课程。
获得证书
在结束每门课程并完成实践项目之后,您会获得一个证书,您可以向您的潜在雇主展示该证书并在您的职业社交网络中分享。

此专项课程包含 5 门课程
数据库管理精要
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.
数据仓库的概念、设计与数据整合
This is the second course in the Data Warehousing for Business Intelligence specialization. Ideally, the courses should be taken in sequence.
关系数据库支持的数据仓库
Relational Database Support for Data Warehouses is the third course in the Data Warehousing for Business Intelligence specialization. In this course, you'll use analytical elements of SQL for answering business intelligence questions. You'll learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, we'll also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.
商业智能的概念、工具与应用
This is the fourth course in the Data Warehouse for Business Intelligence specialization. Ideally, the courses should be taken in sequence. In this course, you will gain the knowledge and skills for using data warehouses for business intelligence purposes and for working as a business intelligence developer. You’ll have the opportunity to work with large data sets in a data warehouse environment and will learn the use of MicroStrategy's Online Analytical Processing (OLAP) and Visualization capabilities to create visualizations and dashboards.
提供方

科罗拉多大学系统
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.

常见问题
退款政策是如何规定的?
我可以只注册一门课程吗?
有助学金吗?
我可以免费学习课程吗?
此课程是 100% 在线学习吗?是否需要现场参加课程?
完成专项课程后我会获得大学学分吗?
How long does it take to complete the Data Warehousing for Business Intelligence Specialization?
此专项课程中每门课程的开课频率为多久?
What background knowledge is necessary?
Do I need to take the courses in a specific order?
Will I earn university credit for completing the Data Warehousing for Business Intelligence Specialization?
What will I be able to do upon completing the Data Warehousing for Business Intelligence Specialization?
还有其他问题吗?请访问 学生帮助中心。