(Winter 2010)

In this course, students learn the basic concepts of a data warehouse and study the issues involved in planning, designing, building, populating, and maintaining a successful data warehouse. Students learn to improve performance or manageability in a data warehouse using various Oracle Database features. Students also learn the basics about Oracle's Database partitioning architecture and identify the benefits of partitioning. Students review the benefits of parallel operations to reduce response time for data-intensive operations. Students learn about the extract, transform, and load of data phase (ETL) into an Oracle database warehouse. Students learn the basics about the benefits of using Oracle's materialized views to improve the data warehouse performance. Students also learn at a high level how query rewrite can improve a query's performance. Prerequisites: Knowledge of general data warehousing concepts, client-server technology and relational server technology.

Victor T. Wu, M.S., is a CTO and co-founder of EmpowerTrain, an Irvine-based company that offers high-end training on technologies including Oracle Database, Sun Solaris, Microsoft technologies. He has worked in the information systems field for the past 25 years as developer, information architect, director, and CIO. His expertise includes C++, Java programming, Oracle database and SQL Server development, high availability and performance tuning, Sun Solaris security and system tuning. He is frequently involved in large scale database and system tuning projects in San Francisco, Los Angeles, and San Diego. Wu is a UCLA graduate, Oracle Certified DBA, Oracle Certified Developer and holder of three Oracle Masters. Wu received UC Irvine Extension's Distinguished Instructor Award (2003) and UCLA Extension's Distinguished Instructor Award (2007).