- Self-paced
- Free Access
- Fee-based Certificate
Delivering a Relational Data Warehouse
You can't access an archived course
- 6 Sequences
- Intermediate Level
Course details
Syllabus
This week makes the business case for a data warehouse, explores data warehouse architectures, and plans the initial design of the database used in the course
Week 2: Designing a Relational Data Warehouse Schema
This week introduces the design of dimension tables and fact tables, and explores additional schema design concepts to address data warehouse challenges.
Week 3: Optimizing a Data Warehouse for Scale and Performance
This week introduces the physical design of the data warehouse, including table partitioning, indexes, and in-memory column store indexes.
Week 4: Loading and Maintaining a Data Warehouse
This week emphasizes the loading of data into the warehouse. We’ll introduce the implementation of an enterprise information management strategy to improve the quality of data, and the use of extract, transform and load (ETL) tools to load the warehouse.
Final Exam
The end of the course is comprised of the final exam, which accounts for 50% of your grade and will be combined with the assessments in each module to determine your overall score. You must achieve an overall score of 70% or higher to pass this course and earn a certificate.
Prerequisite
- Familiarity with database concepts and basic SQL query syntax
- Familiarity with business uses of databases, such as reports and dashboards
- A willingness to learn actively and persevere when troubleshooting technical problems is essential
Instructors
Peter Myers
Consultant, Trainer and Presenter
Bitwise Solutions
Chris Randall
Senior Content Developer, Microsoft Learning Experiences
Microsoft
Editor
Microsoft Corporation is an American multinational technology company headquartered in Redmond, Washington, that develops, manufactures, licenses, supports and sells computer software, consumer electronics and personal computers and services. Its best known software products are the Microsoft Windows line of operating systems, Microsoft Office office suite, and Internet Explorer web browser.
Platform
Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with EdX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.