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

Author Topic: 冷眼向洋看世界,热风吹雨洒江天。Dr. LaoTu 讲授 转行核心课 Oracle 19c/Teradata/MySQL /Linux 第1期  (Read 6494 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
人们都说国外工作不好找。华人移民到国外后,大多失业,或只能去做低薪的累脖工。 那都是因为他们没有接触到USALaoTu.com 这个高薪转行数据分析师捷径平台。

几年来,以及最近, USALaoTu.com 加拿大的同学们连连找到好工作,进入世界著名大公司,大银行。这是有原因的:
把硅谷专家三十多年业界经验,十多年来辅导上千爱家华人成功高薪转行数据分析师的面试技巧,以及成功转行在北美做数据分析师的老师们业界的工作绝招,融化在你求职的过程中。你拿不到Offer才怪!

USALaoTu.com 中国科学技术大学,中国科学院,微软,硅谷专家美国老土博士三十多年美国大小公司,研究院经验助我华人求变。 开拓高薪转行数据分析师捷径培训体系, 北美最早, 最大, 最高效, 最强师资, 转行找工作最快,最实用,成功学生最多网络教学平台数据分析师职业培训中心.

USA LaoTu 美国老土 高薪数据分析师培训网 每天有专家真人实时教课,每周两会专业辅导求职面试。利用USA LaoTu 数据分析师摇篮, 世界各地成千人成功高薪转行进大公司!

Oracle 是世界最大数据库软件公司。Oracle 数据库被广泛的用在各行各业,经过USA LaoTu 平台培训出来的数据人才,在很多大小公司使用Oracle数据库,做DBA,做分析数据的都有。

Oracle 专家,Dr. LaoTu 讲授核心课 Dr. LaoTu 讲授 转行核心课 Oracle 19c, MySQL  SQL  第1期  in Dec 2019

注册课程.

进入课程页面。

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Dr. LaoTu 讲授 转行核心课 Oracle 19c, MySQL  SQL  第1期  8:00 Sat 12/07/2019
8:00 Sat 12/07/2019
8:00 Sat 12/14/2019
8:00 Sat 12/21/2019  No Class
8:00 Sat 12/28/2019  No Class
8:00 Sat 01/04/2020
8:00 Sat 01/11/2020
8:00 Sat 01/18/2020

This course will cover Oracle and MySQL database skills.
Oracle 是世界最大数据库公司,Oracle + MySQL 占据世界数据库市场的半壁江山。



进入课程网页。

This course covers following topics:

Oracle 19C: Installation and usage;
MySQL: Installation and usage;

How to use Oracle SQL developer to connect to:
SQL Serer;

Projects:
Load data into Oracle 19C database;
Some Oracle DBA tasks;
ELT/ETL  process;
Data mapping;
Insurance  data analysis;
Business Service data analysis;

And more ...

Details later.



USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Topics covered  in Oracle 19c term1 class1:
-- How to use Oracle 19c command line interface sqlplus;
-- How to grant privilege from schema owner to another report user;
-- Install Oracle 19c Client software;
-- Install Oracle 19c SQL Developer;
-- How to configure client software;
-- How to set environmental variables;
-- How to export selected result to a CSV file;
-- How to use Oracle database dictionary;
-- How to use dynamic sql to generate sql script;
-- How to run sqlplus sql script file from a command line batch file;
-- How to put sqlplus command output into a operating system file.
Class video: http://www.usalaotu.org/student/Oracle19cSQL_term1.php

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Topic covered on Oracle 19c Term1 Class2:
-- How to load large volume of data into Oracle database;
-- How to do deduping;
-- How to add a primary key into a table;
-- Download and install a very popular GUI software for Oracle;
-- How to use this GUI tool to connect to remote Oracle database;
-- Download and install a most popular FTP GUI software;
-- Get file from and put file into remote FTP server;
-- Download an Oracle on Linux virtual machine from our FTP site;
-- Introduction of fundamental skills on Linux system;
-- Introduction to Linux editor;
-- Login root and oracle account on your own Linux machine;
-- Run oracle sqlplus on your own Linux machine;
-- How to reset the password of Oracle database user account;
-- Most important Oracle background processes;
-- How to kill a Linux process;
-- How to shutdown/start Oracle database on Linux.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Dr. LaoTu 讲授 转行核心课 Oracle 19c, MySQL  SQL  第1期  8:00 Sat 12/07/2019
8:00 Sat 12/07/2019
8:00 Sat 12/14/2019
8:00 Sat 12/21/2019  No Class
8:00 Sat 12/28/2019  No Class
8:00 Sat 01/04/2020
8:00 Sat 01/11/2020
8:00 Sat 01/18/2020

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Oracle 19c Term1 Class3:
-- Generate Oracle report use sqlplus;
-- Sqlplus command to calculate SUM of a column;
-- How display output column length and format;
-- How to use Linux vi to edit file;
-- Copy rows, delete rows in vi;
-- Edit Linux Shell program;
-- How to configure Linux environmental variable to connect to different Oracle database;
-- Call Oracle sqlplus and run sql script from a Shell script;
-- How to configure a new Linux cron job;
-- How to modify the execution time of a Linux cron job;
-- How to check the status of a Linux cron job;
-- How to check the error output of a Linux cron job;
-- How to record the execution timestamp of a Linux job;
-- How to install Oracle client software for Windows;
-- Get step by step installation guide from usalau.com use FTP;
-- How to connect Oracle database from Power BI;
-- How to configure ODBC;
-- How to use ODBC to connect to Oracle database from Power BI;
-- How to call Oracle sqlplus from Windows DOS command script;
-- Answered many other questions.
Class web page and video: http://www.usalaotu.com/student/Oracle19cSQL_term1.php

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Oracle 19c Term1 Class4:
-- Review Linux Cron job;
-- Oracle PL/SQL;
-- Oracle PL/SQL create procedure;
-- Create Oracle database jobs;
-- Write procedure do Insert/Update/Delete with commit;
-- How to control number of COMMIT in DML operations;
-- A Real PL/SQL production ETL code;
-- How to create a log table store ETL process status information;<br>
-- Read sample PL/SQL package code from Oracle;
-- How to find a string from many Linux files;
-- Download Teradata JDBC driver;
-- How to connect Teradata from Oracle SQL GUI tool;
-- How to download a GUI tool for  Tereadata SQL;
-- How to connect to Teradata user account in USALaoTu data center;
-- How to Run SQL and get result in Teradata GUI tool;
-- How to extract Teradata table to a CSV file;
-- How to load a CSV file into a Teradata table;
-- How to create index on a Teradata table.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
View class web page: http://www.usalaotu.org/student/course_category.php
Oracle 19c / Teradata/ MySQL Term1 Class5:
-- How to use Linux find commend to search file in a directory;
-- How to use Linux commend to change/edit a file without open it;
-- How to copy many Linux files fro one directory to another location;
-- How to download and install MySQL;
-- How to create MySQL database;
-- How to display database names in mySQL;
-- How to display table names in MySQL;
-- How to create an user account in MySQL;
-- How to grant user privileges to access a database;
-- How to reset password of a MySQL user;
-- How to start/stop/restart MySQL Server;
-- Create MySQL sample databases;
-- How to use MySQL Workbench;
-- How to connect to remote MySQL database;
-- How to control or allow user access of a MySQL server from a remote computer;
-- How to add new database connections in MySQL Workbench and TOAD for MySQL;
-- How to generate SQL explain plan by using MySQL Workbench;
-- How to generate Entity Relation Diagram by using TOAD for MySQL;
-- Sample SQL code to do data analysis using sample database.