Thanks for register Oracle 12c SQL & MySQL Fundamental class.
Online class Registration web Link: Click here to register online class.
After register, waiting for approval. Will approve before class start.
To reduce background noise, we require students use a headset or earphone to join online live class.

Assume you are a new student to USA Laotu Class:
Here are what you need to do before class start:
Download Oracle class materials,
    1. backup your zipped file into a different Hard.
    2. Watch online class videos without doing anything.
    3. Go through downloaded class materials, follow class demo, do project, ask question at student forum.
 
1) Please create a new folder, name it as C:\ora12c,
   Use this folder to store all the downloaded files.

2)The downloaded file will be WinRar compressed files, you need WinRar to extract the file.
You can download a WinRar 390 from our website if you do not have one now:
http://www.usalaotu.com/download/wrar390.php

This is a 32-bit file, it will work for 64-bit computer too.
After download is done, please click file name wrar390.exe to install it into your computer.

   About how to use Winrar to extract the file:
   Please (Use FireFox) watch video:
   http://www.usalaotu.com/video/unzip_demo.swf

Class setup:
Before class start, we require you follow video and pdf file get Oracle 12c Virtual machine installed into your computer.
Video:
Video: Oracle 12c SQL Lab Setup.

Document:
pdf file: Oracle 12c SQL Lab Setup.

Class Document:
pdf file document: Oracle 12c SQL & MySQL Fundamental.

Watch class video online: (will be available in the night of each online class.)
Video: http://www.usalaotu.com/ora12c/ora12c_class1_20150407.php
Video: http://www.usalaotu.com/ora12c/ora12c_class2_20150409.php
Video: http://www.usalaotu.com/ora12c/ora12c_class3_20150421.php
Video: http://www.usalaotu.com/ora12c/ora12c_class4_20150423.php
Video: http://www.usalaotu.com/ora12c/ora12c_class5_20150428.php
Video: http://www.usalaotu.com/ora12c/ora12c_class6_20150430.php
Video: http://www.usalaotu.com/ora12c/ora12c_class7_20150505.php
Video: http://www.usalaotu.com/ora12c/ora12c_class8_20150507.php
Sep 2014 Oracle 11g SQL class document:

1) Please create a new folder, name it as C:\ora11g,
   Use this folder to store all the downloaded files.

2)The downloaded file will be WinRar compressed files, you need WinRar to extract the file.
You can download a WinRar 390 from our website if you do not have one now:
http://www.usalaotu.com/download/wrar390.php

This is a 32-bit file, it will work for 64-bit computer too.
After download is done, please click file name wrar390.exe to install it into your computer.

   About how to use Winrar to extract the file:
   Please (Use FireFox) watch video:
   http://www.usalaotu.com/video/unzip_demo.swf

The quick way to study is: Do nothing, keep watching class video, finish till chapter 10. Get a big picture, ignore the small questions.
Then, come back again for the second time, you will get many problems solved by yourself.

You can follow the step by step guide, get Oracle 11g for windows downloaded into your Laptop.
We will teach how to do Oracle installation in our coming online class.
You do not need to do it before class start.

Post on student forum of Oracle 11g class board if you have any questions.

Now start download Oracle 11g SQL class material from following links, do download one file at a time:
-- Open your FireFox Web browser;
-- Copy paste following URL to your FireFox brower;
-- Enter your email address, password (You can easily generate a password if you do not have one);
-- Click save in the pop-up window.

http://www.usalaotu.com/download/SQL101/SQL101ch1_2_3.php
file size 104MB.
Dandan's Behavior Interview Questions included
Oracle 11g download and install guide included.
Oracle SQL Developer download and installation guide included.

Many e-books included.
Home work:
-- Read and understand create_ap_tables.sql ,
-- Know how to create tables, how to insert data into tables.
-- Know how to add Primary key, how to add foreign key into tables.
-- Download and install Oracle SQL Developer into your PC, will make it wotk in next class.
Thanks and enjoy study!

http://www.usalaotu.com/download/SQL101/SQL101ch4_5_6_7.php

-- Document of how to download and install Oracle_on_VMWARE for Linux is included.

http://www.usalaotu.com/download/SQL101/SQL101ch8_9_10.php

-- Talked about TOAD; -- Memorial Hospital Data and Lina's solution included;
-- Please review all the sql scripts in ch 8 9 10, write down each of them multi times;
-- Please review Fast Printing project in the Microsoft Word file.

http://www.usalaotu.com/download/SQL101/SQL101ch10_11_12.php

-- Memorial Hospital Data and Lina's solution included;
-- Please review all the sql scripts in ch 10 11 12 13, write down each of them multi times;
-- Please review Fast Printing project in the Microsoft Word file.
-- Please review PL/SQL code.

http://www.usalaotu.com/download/SQL101/SQL101ch13_to_16.php

-- Lucky's configuration file;
-- Modified PL/SQL procedure and package,added error handler;
-- Disable_constraint.sql
-- Please complete Fast Printing project.


USA LaoTu
inquiries@usalaotu.com
408.707.3887

COPYRIGHT NOTICE. All materials available on www.usalaotu.com and all materials received from USA Lao Tu are protected by United States copyright laws and international copyright treaty provisions. This material has been placed on www.usalaotu.com and selectively distributed to registered USA Lao Tu students under the authority of the copyright owner for the sole purpose of viewing of the materials by users and students of www.usalaotu.com. Users are not authorized to download or transmit any of these materials electronically, or to otherwise reproduce any of the materials in any form or by any means, electronic or mechanical, including data storage and retrieval systems, recording, printing or photocopying. You may not alter or remove any trademark, copyright or other notice from copies of the content. All materials received from USA Lao Tu are for your personal, noncommercial use only. Any copyright violations will be prosecuted to the fullest extent of the law. COPYRIGHT 2007-2018 USA LAO TU LLC. ALL RIGHTS RESERVED.

TRADEMARK NOTICE. "USA Lao Tu" and "Lao Tu" are registered trademarks of USA Lao Tu LLC and its affiliates. You may not use any trademark or service mark appearing on this Site without the prior written consent of the owner of such mark, and nothing contained in this Site should be construed as granting, by implication, estoppel or otherwise, any license or right to use any trademark or service mark without such prior written consent. You may not alter or remove any trademark, copyright or other notice from copies of content. Any trademark infringements will be prosecuted to the fullest extent of the law.