DBA 4: Analyzing Data

 

In this course, students learn how to take their relational data warehouse from the previous course to the next level using Mondrian and JPivot, two tools for Multidimensional data warehouses.

First students learn the basics of MDX, the query language of data warehouses. Next students expand that knowledge to answer a variety of queries, such as:

  • How do this month's sales compare to last month?
  • What are the top five selling products?
  • How much do we expect to sell next month?
Finally, students learn how to write a schema for Mondrian - the XML document that bridges the relational data warehouse and multidimensional data warehouse worlds.

Participants learn by doing projects in their own Unix and MySQL environments, and then handing them in for instructor feedback. These projects, as well as the final project add to the student's portfolio and will contribute to certificate completion. Besides a browser and internet connection, all software is provided online by the O'Reilly School of Technology.

Upon completion of the course, students will earn 4 CEUs (Continuing Education Units) and a CEU letter from the University of Illinois Office of Continuing Education. This is the third course in the four-course Database Administration Certificate series.

 
Free ebooks & software included. Click for info on Lab Fees
 

DBA 4: Analyzing Data

448.00
Course Details and Syllabus Enroll
 

On your way to Certification:

 

New OST Courses!

Database Administration Certificate Series

DBA 1: Introduction to Database Administration
398.00
DBA 2: Administering MySQL
398.00
DBA 3: Creating a Data Warehouse
448.00
DBA 4: Analyzing Data
448.00
 
Enroll in all four Database Administration courses and get 25% off! (-$423)Expires 03/31/10Enroll for Certificate
 

Java Programming Certificate Series

System Administration Certificate

Client-Side Web Programming Certificate

PHP/SQL Programming Certificate

Web Programming Certificate

.NET Certificate

Open Source Programming Certificate

Other Courses

Experts are Made, Not Born - Enroll Now in the School of Technology

Georgia M. wants to talk to you!

"Wow, Georgia, I wish that everyone could be as friendly and efficient as you!"
-- Amanda S.

3/18/10: Unfortunately, a problem at our CA headquarters has affected our phones, so no calls can come through today. Thank you for your patience as we fix this problem, and be sure to contact Georgia via email for a prompt response.

Earn a Certificate

for Professional Development from the University of Illinois' Office of Continuing Education upon completion of a selected series of courses.

Illinois