Oracle 11g SQL (Core Package 2013 Course) online live class started on Sunday 04/13/14, students get many projects to do, including:
-- Extract and load data warehouse fact and dimension table data;
-- Analyze sales history data warehouse data generate reports about sales amount for different time, different customer and products.
-- Download Database Extracts From the Clinical Trials Transformation Initiative (CTTI) Database for Aggregate Analysis of ClinicalTrials.gov (AACT), load the downloaded ClinicalTrials 2013 data into about 30 Oracle database tables, generate reports use SQL script.