Save 25% on Certificate Courses

Until March 31st, enroll in all courses within ANY Certificate series, and save 25%. Enroll today!

> Read more

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

Course Details and Syllabus


Course:	DBA 4: Analyzing Data
Tuition:	$448
Time Frame:	Due to our monthly lab fee system, this course is completely self-paced. You can expect to work approximately 40 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:	4 Continuing Education Units with official letter from the University of Illinois Office of Continuing Education.
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 free ebook Information Dashboard Design as a complimentary reference from O'Reilly.
Certificates:	Completion of this course counts toward the Database Administration Certificate Series.
Prerequisites:	DBA 3, or equivalent experience. If you are pursuing a Certificate, all courses within that Certificate series must be completed.
Topics:	MySQL, MDX, the cube, calculated members, crossjoin, tuples, sets, union, filtering, hierarchies, date & time, top queries, graphs, Mondrian, shared dimensions, schemas
Syllabus:	DBA 4 Lab 1 -- Introduction How to Learn using OST Courses Understanding the Learning Sandbox Using Unix and MySQL Modes Using MDX Mode DBA 4 Lab 2 -- MDX From The Ground Up What is a Cube? Comparing SQL to MDX Basic MDX Queries DBA 4 Lab 3 -- Tuples and Sets Tuples Sets Navigating the Cube DBA 4 Lab 4 -- Calculated Members Adding Calculated Members Format Strings Named Sets DBA 4 Lab 5 -- MDX Functions Union Crossjoin Other Set Functions DBA 4 Lab 6 -- MDX Functions II Filtering Data Functions for Hierarchies DBA 4 Lab 7 -- Traveling In Time Common Date Questions Comparing Dates DBA 4 Lab 8 -- Top Queries TopCount TopPercent Generate DBA 4 Lab 9 -- Predicting the Future How to Predict the Future Using MDX to Predict The Future Graphs DBA 4 Lab 10 -- Using Mondrian Writing a Mondrian Schema Shared Dimensions Cubes DBA 4 Lab 11 -- Advanced Schemas Virtual Cubes Calculated Members DBA 4 Lab 12 -- Final Project Writing Schemas Writing MDX Queries

On your way to Certification:

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/10

Enroll for Certificate

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