Oracle 11g SQL class start on 04/13/2014

[USA LaoTu Support Team]

Oracle 11g SQL Online live class start on 08:00 to 12:00 (USA PST) Sunday 04/13/14, to 05/11/14, 5 weekends.
A Core Package course.
硅谷资深Oracle DBA 二十多年工业界经验, 六年多来培养学生无数, 教你Oracle 数据分析技术，带你进入数据分析好工作。

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

Pre-request: none.

[liyi0522]

网页上写的是4月20日开课。到底是哪一天？如何参加live课程？

[USA LaoTu Support Team]

Per student's ask, class time changed to Sunday morning:
Oracle 11g SQL Online live class start on 08:00 to 12:00 (USA PST) Sunday 04/13/14, to 05/11/14, 5 weekends.

[liyi0522]

When would you post live class gotomeeting link? and where?

[乐乐]

It's already in your student account on the top of Oracle 11g 4/13/2014 course page.

[芳芳]

Is this for Core package students 2013?

who will be the teacher?

Thank you.

[USA LaoTu Support Team]

Oracle 11g SQL is a course of Core Package 2013. Dr. LaoTu is the teacher.

Core Package 2013 students who registered after Jan 15, 2014 can join this online live class for FREE.

Please find more details about the policy from this link:
http://forum.usalaotu.com/index.php?topic=3067.0

[jying]

Hi, teacher
I registered core package last year. May I still take oracle 11g live class on sunday?

[USA LaoTu Support Team]

Core Package 2013 students who registered after Jan 15, 2014 can join this online live class for FREE.

Please find more details about the policy from this link:
http://forum.usalaotu.com/index.php?topic=3067.0

[USA LaoTu Support Team]

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.

[USA LaoTu Support Team]

2014-04-27 本期 Orale 11g SQL 第三次课:
Carrol同学，做的project，用 dynamic SQL generate control file for SQL Loader, 把 Clinical Trial 2013 的几十个 Tables, 眨眼间就统统 load 进 Oracle Database， 非常令人震撼. 

做生物的Yuan 同学 和 做 Accounting 的 Emily 同学 秀了她们做的 Clinical Trial Projects use SQL and SSRS reports, 让新同学看的羡慕不已。

她们也就是今年一月才开始学的， 搭上USA LaoTu 培训快车， 跟着大部队浩荡推进，充分利用同学论坛里的资源，采纳汲取同学们的成功经验，短短仨月，练就一身真本事。

课上，同学们还到凯瑞同学家里，这里瞧瞧，那里看看，你一言我一语，帮她解决了一个 Load Data 中因数据格式不对而出现的问题，凯瑞同学高兴的不得了。

本次课后，布置同学们作三个Projects. 都是模拟工作中的情形，完成以后，得到的第一手经验可以在面试时侃侃而谈。

同学们说：土校的学生都太厉害了！USA LaoTu 这种独一无二的以找工作为目的的深入浅出强化实战，新老同学互相分享，传帮带的高效教学方法 是其他任何地方都找不到的， 难怪如此多的学生能快速转行进入高薪好工作，如此多的咱国家庭能从 USA LaoTu 课程中受益。

今天课程的录像已经放在课程网址，供同学们学习观看。