DBA 4: Analyzing Data
In this course, you will learn how to take your relational data warehouse to the next level using Mondrian and JPivot, two tools for multidimensional data analysis.
Upon completion of this course, you will be able to:
- Demonstrate the basics of MDX, the query language of data warehouses.
- Analyze and extrapolate business models through data modeling.
- Write a schema for Mondrian—the XML document that bridges the relational and multidimensional worlds.
From beginning to end, you will learn by doing Unix and MySQL-based projects and submitting them for instructor feedback. These projects, as well as the final project, will add to your portfolio and contribute to certificate completion. Besides a browser and Internet connection, all software is provided online by the O’Reilly School of Technology.
This course counts toward the Database Administration Certificate.
Prerequisites: DBA 3: Creating a Data Warehouse, or equivalent skills. This course is meant for the intermediate or advanced database administrator.
135 Clock-hours 9 CEUs
Course Details and Syllabus
|Course:||DBA 4: Analyzing Data|
|Time Frame:||This course is online and self-paced. You can expect to work approximately 135 hours on this course.|
|Technical Requirements:||As long as you have a web browser and internet connection, you can take this course from anywhere in the world.|
|CEUs:||9 Continuing Education Units with official letter from O’Reilly Media.|
|Software:||The web-based Learning Sandbox® provided for you will contain all your lessons, projects, quizzes, account files, editors, and programming tools necessary to build your skills from beginning to end, even beyond coursework. No other software is needed. In addition, you’ll be provided with a mySQL account that can be accessed through the Sandbox or, if you prefer, any normal SSH program. No other software is needed.|
|Instructor:||You will have one instructor throughout the course who will evaluate your projects and quizzes, hand them back for improvement when necessary, and coach you throughout your skills advancement.|
|Book:||All required course materials and software are included online within the Learning Sandbox®. However, within a few weeks of enrolling, you’ll receive the e-book Head First Data Analysis as a reference resource from O’Reilly.
|Certificates:||Completion of this course counts toward the Database Administration Certificate Series.|
|Prerequisites:||DBA 3, or equivalent experience. This course is meant for the intermediate or advanced database administrator.|
|Topics:||MySQL, MDX, the cube, calculated members, crossjoin, tuples, sets, union, filtering, hierarchies, date & time, top queries, graphs, Mondrian, shared dimensions, schemas|