HTTP/2 302 server: nginx date: Sat, 02 Aug 2025 19:24:30 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100325204715 location: https://web.archive.org/web/20100325204715/https://www.oreillyschool.com/courses/dba3 server-timing: captures_list;dur=0.803567, exclusion.robots;dur=0.028644, exclusion.robots.policy;dur=0.013003, esindex;dur=0.015849, cdx.remote;dur=69.740668, LoadShardBlock;dur=408.155266, PetaboxLoader3.resolve;dur=208.881980, PetaboxLoader3.datanode;dur=140.125873 x-app-server: wwwb-app215 x-ts: 302 x-tr: 512 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: wb-p-SERVER=wwwb-app215; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Sat, 02 Aug 2025 19:24:31 GMT content-type: text/html; charset=UTF-8 x-archive-orig-date: Thu, 25 Mar 2010 20:47:14 GMT x-archive-orig-server: Apache/2.0.59 (CentOS) x-archive-orig-x-powered-by: PHP/5.1.6 x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: windows-1252 memento-datetime: Thu, 25 Mar 2010 20:47:15 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Fri, 27 Mar 2009 10:24:18 GMT", ; rel="prev memento"; datetime="Tue, 23 Feb 2010 04:50:00 GMT", ; rel="memento"; datetime="Thu, 25 Mar 2010 20:47:15 GMT", ; rel="next memento"; datetime="Mon, 29 Mar 2010 12:16:45 GMT", ; rel="last memento"; datetime="Sun, 13 Dec 2015 01:41:07 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 51_14_20100325190714_crawl102_IndexOnly-c/51_14_20100325204654_crawl102.arc.gz server-timing: captures_list;dur=0.653692, exclusion.robots;dur=0.020904, exclusion.robots.policy;dur=0.010241, esindex;dur=0.012152, cdx.remote;dur=119.255682, LoadShardBlock;dur=195.927359, PetaboxLoader3.datanode;dur=156.927088, PetaboxLoader3.resolve;dur=397.765208, load_resource;dur=438.050663 x-app-server: wwwb-app215 x-ts: 200 x-tr: 899 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip

• Sign In
• FAQs
• Search
• Contact
• Press

• Home
• Your Career
• Why O'Reilly
• Certificate Programs
• Online Courses
• Enroll

• Online Courses
• For Managers
• Enroll Today

$100 for Every Referral!

Translate your enthusiasm for OST into cash or tuition credit, through the new OST Referral Program.

Learn More

Save 25% on Certificate Courses

Until March 31st, enroll in all courses within ANY Certificate series, and save 25%. Enroll today! Not valid with any other offer.

> Read more

DBA 3: Creating a Data Warehouse

 

In this course, students learn what makes up a data warehouse and gain an understanding of the dimensional model. Next, students learn how to implement the dimensional model using standard ETL processes. Then, students learn about special data warehousing situations, and finally, how to query relational data warehouses using standard SQL commands.

From beginning to end, participants will learn by doing projects using Talend Open Studio, an Eclipse based tool for implementing data warehouses. Students complete projects using Talend, developing their own complete data warehouses. The projects 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

Our unique learning methods allow you to have 24-hour access to your lab account, including all coursework, files, development tools, online portfolio, and your Instructor's feedback, for as long as you need. This way, your courses are completely self-paced for your busy schedule. You can freeze and unfreeze your lab account when necessary, and you can even keep the account when you've finished your courses -- to have a portfolio for your resume, to keep practicing your skills, or to create prototypes on a safe system.

Base lab fee is a flat $9.95/month, no matter how many courses you are in. (Java Programming courses, Python Programming courses and DBA 3 incur an additional $5.00/month lab fee due to the virtual Windows account used for Ellipse. This is per account, not per course, and it can be removed upon request when not working on these courses.)

 

DBA 3: Creating a Data Warehouse	448.00
Course Details and Syllabus
Course Details and Syllabus Course: DBA 3: Creating a Data Warehouse 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 Ellipse 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 MySQL Stored Procedure Programming as a complimentary reference from O'Reilly. Certificates: Completion of this course counts toward the Database Administration Certificate Series. Prerequisites: DBA 2, or equivalent experience. If you are pursuing a Certificate, all courses within that Certificate series must be completed. Topics: Data warehouses, dimensions, ETL, Talend, performance, facts, aggregation Syllabus: DBA 3 Lab 1 -- Introduction How to Learn using OST Courses Understanding the Learning Sandbox Getting Started with Talend Open Studio DBA 3 Lab 2 -- What is a Data Warehouse? Facts and Dimensions The Dimensional Model DBA 3 Lab 3 -- Implementing The Dimensional Model The Date Dimension Slowly Changing Dimensions DBA 3 Lab 4 -- Implementing The Dimensional Model, Part II Dimensions Facts Factless Facts DBA 3 Lab 5 -- Extract, Transform, Load (ETL) Logging and Auditing Extracting Data DBA 3 Lab 6 -- Tools for ETL Talend Open Studio Jobs Data Flows DBA 3 Lab 7 -- ETL: The Date Dimension Job Structure Loading from Excel Mapping Columns Database Connections DBA 3 Lab 8 -- Basic Dimension Processing Job Structure Performance DBA 3 Lab 9 -- SCD Processing Algorithms for Slowly Changing Dimensions Implementation DBA 3 Lab 10 -- Processing Facts Job Orchestration Fact Processing DBA 3 Lab 11 -- Processing Facts, Part II Implementing Facts DBA 3 Lab 12 -- Special Facts Missing Keys Aggregations Deaggregations Early Arriving Facts DBA 3 Lab 13 -- Querying a Relational Data Warehouse Viewing Data Common Questions Problems with Queries DBA 3 Lab 14 -- Final Project Your Own Data Warehouse

 

On your way to Certification:

 

New OST Courses!

Perl 1: Introduction to Perl	398.00
Python 1: Beginning Python	398.00

 

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

 

Java Programming Certificate Series

Java Programming 1: Introduction to Java and the Eclipse Development Environment	398.00
Java Programming 2: The Java Programming Language	398.00
Java Programming 3: Java Programming Foundations	398.00
Java Programming 4: Java Application Building	398.00

 

Enroll in all four Java Programming courses and get 25% off! (-$398)Expires 03/31/10

 

System Administration Certificate

Linux/Unix 1: The Unix file system	398.00
Linux/Unix 2: Networking and DNS	398.00
Linux/Unix 3: Unix Services	398.00
Linux/Unix 4: Scripting for Administrators Sed, Awk, and Perl	398.00

 

Enroll in all four System Administration courses and get 25% off! (-$398)Expires 03/31/10

 

Client-Side Web Programming Certificate

Introduction to HTML and CSS	298.00
JavaScript 1: Introduction to JavaScript	398.00
JavaScript 2: AJAX	398.00

 

Enroll in all three Client-Side Web Programming courses and get 25% off! (-$274)Expires 03/31/10

 

PHP/SQL Programming Certificate

Introduction to PHP	398.00
PHP/SQL 1: Introduction to Database Programming	398.00
PHP/SQL 2: Relational Theory and Logical Design	398.00
PHP/SQL 3: Seamless Web 2.0 Integration	398.00

 

Enroll in all four PHP/SQL Programming courses and get 25% off! (-$398)Expires 03/31/10

 

Web Programming Certificate

Introduction to HTML and CSS	298.00
JavaScript 1: Introduction to JavaScript	398.00
Introduction to XML	398.00
Learn Perl for CGI Programming	398.00
Unix for Web Programming	298.00
Learn SQL for Database Programming	398.00

 

Enroll in all six Web Programming courses and get 25% off! (-$547)Expires 03/31/10

 

.NET Certificate

Introduction to XML	398.00
Introduction to Object-Oriented Programming	398.00
Learn C#.NET	498.00

 

Enroll in all three .NET Programming courses and get 25% off! (-$324)Expires 03/31/10

 

Open Source Programming Certificate

Introduction to Object-Oriented Programming	398.00
Linux/Unix 1: The Unix file system	398.00
Learn Perl for CGI Programming	398.00
Introduction to PHP	398.00
PHP/SQL 1: Introduction to Database Programming	398.00

 

Enroll in all five Open-Source Programming courses and get 25% off! (-$498)Expires 03/31/10

 

Other Courses

Learn C Programming, Part 1	298.00
Learn C Programming, Part 2	298.00
Learn VBScript	298.00
Visual Basic .NET	498.00

 

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 6pm PST

Earn a Certificate

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

© 2009, O'Reilly Media, Inc. All rights reserved.