你将学到什么
How to design relational databases that are used to manage operational systems
How to query relational databases using Structured Query Language (SQL)
How to design data warehouses and business intelligence systems
Understand the principles of data profiling, data integration, and master data management
Understand the basics of Hadoop, Hive and Pig
课程概况
High-quality information is the key to successful management of businesses. Despite the large quantity of data that is collected by organizations, managers struggle to obtain information that helps them make decisions. While operational processing systems help capture, store, and manipulate data to support day-to-day operations of organizations, reconciled systems — sometimes referred to as data warehouses or business intelligence (BI) systems — support the analysis of data, thus, enabling decision making.
With the advent of big data systems, organizations have turned toenterprise data management frameworks to manage and gain insights from the vast amount of data collected. While storage costs themselves are relatively affordable, the bigger challenge has been finding an appropriate mechanism to manage the data as many technologies (e.g., relational databases, data warehouses) have limitations on the amount of data that can be stored.
This course focuses on realizing the business advantage and business potential of operational, reconciled, and big data systems as well as data assets in supporting enterprise data management strategies and enterprise data analytics.
Verified Learners will need to purchase a textbook in order to successfully complete the course. See the FAQ for details.
预备知识
None.
常见问题
Does this course require a textbook?
Yes, if you are Verified Learner, a textbook is required. If you choose to verify, you will also need to purchase a copy of Hoffer, J., Venkataraman, R., & Topi, H. (2019). Modern Database Management (13 ed.). Pearson. Print ISBN: 9780134773650, 0134773659: eText ISBN: 9780134792293, 0134792297. This textbook typically costs around $59.99 to rent and $89.99 to purchase permanently. A digital copy is acceptable.
