2014-01-07 class video is ready for review. New student can access it from student signon page.
Topics talked in this class session: how to install SQL Developer and TOAD for Oracle Analyst, How to use TOAD do database table export/import, Table constraints, How to create dimension table and fact table. Sample data of dimension and fact table. How to generate a simple business report use sql by joining two tables.
Data file for Project: The Tasks your manager asks you to do
has been uploaded into the attached file on the top message of Oracle 11g SQL class forum board:
http://forum.usalaotu.com/index.php?topic=752.msg12115;topicseen#msg12115Please finish the project this week.
Here is the Project requirements:
All,
Please find a attached file with this email.
Please read the README.txt file after you extract/unzip the file:
16 tables, in excel sheets, for the business
8 reports, in excel sheets, in Report folder
2 uncompleted documents, in notepad, in document folder, which was left by previous employee for this job.
Your task:
-- Migrate all the 16 tables into Oracle database;
-- Load all the 16 tables into Oracle database;
-- Develop SQL in Oracle database to generate all the 8 reports
Please try to finish the task independently use the skill you learned in Oracle 11g SQL class, just assume you are in work.
If you have questions, ask and discuss in our Oracle 11g Student forum.
We hope you deliver task COB Friday.