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?
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.
Georgia M. wants to talk to you!
"Wow, Georgia, I wish that everyone could be as friendly and efficient as you!"-- Amanda S.
Call 800-998-9938 x.7187
M-F between 9am and 5pm PST
Earn a Certificate
for Professional Development from the University of Illinois' Office of Continuing Education upon completion of a selected series of courses.
