420 Medical Database Architectures

Week

  01 02 03 04 05 06 07 08 09 10

This Course Schedule is subject to change throughout the course.  Notification and appropriate adjustments to these requirements will be given in a timely manner!  

 

Wk

Topics

Day 1

 

Day 2

1

Database design

Database design - continued  

bullet

Animated DataBase Courseware

2

Database design - continued  &

Database Administration

Database Administration - continued

3

Cache

Cache - continued

4

Cache - continued

Cache - continued

5

Review/Project

Practical 1

6

Database Interaction  

bullethttp://java.sun.com/docs/books/tutorial/
bulletJDBC Tutorial
bulletJDBC Resources
bulletJDBC Drivers

Database Interaction - continued  

bullet

Using Cache w/ JDBC

bullet

wikipedia

7

Data Warehouse  

bulletwww.kimballgroup.com
bulletwww.inmoncif.com
bullet"The Data Warehouse Lifecycle Toolkit”, 2nd Edition, Kimball, et al, John Wiley & Sons, 2008.
bullet“Corporate Information Factory”, 2nd Edition, Inmon, et al, John Wiley & Sons, 2001
bullet"Building the Data Warehouse", 4th Edition, Inmon, John Wiley & Sons, 2008.

Data Warehouse - continued  

bullet

Ponniah, P., Data Warehousing Fundamentals, a Comprehensive Guide for IT Professionals, 2nd Edition, John Wiley & Sons, 2010.  (ISBN 978-0-470-46207-2)

8

ETL

ETL - continued  

bullet

   ETL Market Overview

bullet

E   ETL Magic Quadrant Update: A Market in Evolution

9

Web Interface  

bullet

Install Apache on Windows 7 - how to

bullet

Install PHP on Windows 7

Web Interface - continued  

bullet

How to Install and Configure PHP 5 to Run with Apache on Windows

bullet

ODBC Manual

bullet

ADOdb Library for PHP

10

Review/Project

Practical 2

11

Final: 5/18/11(W) 12:30-2:30 @ 70-2620

 

top