Oracle 11g SQL Start on Jan 4 2014

[USA LaoTu Support Team]

Oracle 11g SQL Start on Jan 04 2014
A Core Package course.
硅谷资深Oracle DBA 二十多年工业界经验, 六年多来培养学生无数, 教你Oracle 数据分析技术，带你进入数据分析好工作。

After register, student can access to previous class video immediately, and join thin online live class. This online live class will be recorded too, you will be able to access these recorded class video too.

8:00 am to 12:00 noon  Saturday  01/04/2014   4 hr
18:00  to  20:00  Tuesday  01/07/2014   2 hr
18:00  to  21:00  Thursday 01/09/2014   3 hr
18:00  to  20:00  Tuesday  01/14/2014   2 hr 
18:00  to  21:00  Thursday 01/16/2014   3 hr
18:00  to  21:00  Tuesday  01/21/2014   3 hr
18:00  to  21:00  Thursday 01/23/2014   3 hr
Pre-request: none.

[USA LaoTu Support Team]

laoshi,
 
老同学还能听
Oracle 11g SQL Start on Jan 4 2014吗？
 
像上次SQL Server一样。
 
Regards.

-- Yes, Core Package Students who registered within 365 days can join this Oracle 11g SQL course for listen.
-- Will publish class connection information later tomorrow night, check student signon page for information.

[USA LaoTu Support Team]

Class connection information published on student signon web page.
After register class, please wait for approval.
Will do approve before class start. Not need email again to ask.
Thanks.

[DBV]

Happy New Year Dr. Laotu!

I am a new core package student. Will I receive the class webnar links before the class starts? Or do I need to register anywhere on your website?

Thanks!

[USA LaoTu Support Team]

As said, follow the instruction you get after register course. Go to student signon page:  student.usalaotu.com/signon.php
You will see the name of new Oracle 11g SQL class in there.

[yuan]

Suggestion wanted....

Anyone taking Oracle 11g SQL or SQL Server 2012 know that it is better to download database server before the first class or after?
Many thanks,
zym

[如月]

You'd better not do anything before the first class, laoshi will tell you what to do first and what you should do and how to do it.....
You don't need to install anything yet

If you have time, you can listen the last session's class video which you download from the class link, and then you will have some ideas how to study this course and what is the best method

Suggestion wanted....

Anyone taking Oracle 11g SQL or SQL Server 2012 know that it is better to download database server before the first class or after?
Many thanks,
zym

[yuan]

Hi 如月， thank you for always being there to help. Advice accepted. zym

[USA LaoTu Support Team]

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#msg12115
Please 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.