好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text

Author Topic: Dr. LaoTu 讲授 Oracle 12c SQL & MySQL 第四期 (Core Package class) 10/24 to 12/12  (Read 11290 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
This is a Core Package 2013 class!

Dr. LaoTu 讲授 Oracle 12c SQL & MySQL Fundamental 第四期 (Core Package class)  10/24 to 12/12
Total 20 hours.


Student will also get  Oracle 11g class document and class video.

16:00 to 19:00 USA PST (Los Angeles Time)  Saturday.

10/24, 10/31, 11/07, 11/14, 11/21, 11/28 (No class),

12/05, 12/12

This is a Core Package 2013 class.

Price: $1260 for general public.
Registration: http://www.usalaotu.com/student/register.php
Access class web page: http://www.usalaotu.com/student/signon.php
Online class connection information is inside the class web page. Please wait for approval after registering for the online webinar.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Our goal for this class is:
Let student gain real experience on Oracle 12c on Windows and on Linux system.
-- In first class, we covered:
-- How to install Virtual Machine;
-- How to install Windows Server;
-- How to install Oracle 12c;
-- Oracle 12c Database Architecture;
-- Oracle 12c Database data files;
-- How to change to different databases when you work in a company;
-- How to connect to remote Oracle database;
-- How to install SQL Developer into Windows Server;

Dr. LaoTu 把多年的工作经验溶进教课中. 如果你想找数据分析领域工作, 学这个课是最快的方法.

课后有视频, 可随时复习.
注册连接在这里. 随时注册课后,就可以学起来,不用等.


USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
In second class of Saturday 2015-10-31, we started 15 minute early and finished in 1 hour late.
We covered topics of:
-- Trouble shooting while making connections to local and to remote databases;
-- Oracle 12c on Linux,  delete, create a database;
-- As a DBA, create user, grant permissions; 
-- Oracle database data types;
-- Create tables;
-- Insert data into tables;
-- Load Excel data into database use SQL developer;
-- Manager asks me load data into a remote Oracle database table located in cloud data center;
-- Oracle SQL*Loader utility, controlfile, datafile, logfile, bad file;
-- Windows Batch file;
-- Edit a file in Linus server;
-- Why mu sqlplus is not working well on Linus;
-- Linus command of list files;
-- Linus user profile.
Step be step students are leaning lots of stuff as same as in a real work ...

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
In USALaoTu 美国老土's class, student gain real skill and experience by doing real projects.
八年来,世界各地成千华人就这样在跟硅谷专家USALaoTu 美国老土做项目中学得公司所需技术,不用再读学位,很快转行,走出家,高薪进大公司. 这些家庭生活更幸福了!

Oracle 12c Term4 class2 tasks your manager asks you to do this week2015-11-02:
(Only registered student can see whole poster from this link:
http://www.usalaotu.com/forum/index.php?topic=7355.msg31677#msg31677)

Welcome on board!
We are a database consulting company, we do data loading, management and analysis for many companies in many industries.

As an new employee, I would like to you finish load following data into our dev database in cloud by COB Friday.
1. database:
    Server name: ?????????, Service_name: dev
    Username/password: ???????????  (Sorry, only registered student can see this information)
    Table name: You create new tables as you like, name your table as <table_name>_<your_first_name>
                       Example: employees_steve
2. data:
   2-1: For healthcare Hospital, in SQL101ch4_5_6_7\ch5_6\report
           folder:   SQL101ch4_5_6_7\SQL101ch4_5_6_7\ch4\Memory_Hospital
           file name: total 9 excel files

   2-2: For accounting firm:
           folder:   SQL101ch4_5_6_7\ch5_6\report
           file name: ledger.csv

   2-3: for Financial company:
           folder: SQL101ch4_5_6_7\ch5_6\report
           file name: stock.csv

Again, please have all data ready in tables by COB Friday.
Happy work!

You can discuss your questions by reply this email. Only registered student can see this poster:
http://www.usalaotu.com/forum/index.php?topic=7355.msg31677#msg31677

But, don't show your result in email.
Show your result in Saturday afternoon's team meeting.
Good luck!

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Oracle 12c & MySQL class finished last Saturday.
In last class, we focus on following topics:
-- Install MySQL Server;
-- Install MySQL Workbench;
-- Configure workbench to connect to remote database;
-- Connect to MySQL database from a command line interface;
-- Create MySQL user account;
-- How to access remote MySQL database in cloud;
-- How to load data into MySQL Database.

We have created and loaded a complete OLTP database Wine_Store into our remote MySQL Server, student can access this OLTP database from their home  and do their queries. Student can generate all sorts of business reports use SQL you learned in this class.

SQL Server SQL class will start on 12/19/2015.
A perfect timing to join.
See you in SQL Server SQL class.