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.