USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动,到这里来,必使你得改变!成千聪明华人循此捷径高薪进入大公司! => 坚定正确的转行方向 高薪捷径 视频试看 => Topic started by: USA LaoTu Support Team on October 29, 2014, 02:24:36 PM
-
Oracle PL/SQL Programming
Teacher Chris is an Oracle expert with more than 15 years Database developer experience in USA companies. He taught SQL server T-SQL programming course in USA LaoTu school, students learned a lot.
Five 4 hour sessions, total 20 hours.
Registration: http://student.usalaotu.com/make_payment.php
Price:
$1198 for general public
$898 for students paid $2999
$848 for students paid $3999
$798 for students paid $4999 and up
8:00am to 12:00pm Sunday, 06/15/14 to 7/13/14
Class 1
Introctuction
PL/SQL Variable
PL/SQL Dataype and their Functions
date
number
varchar2
%type
Clob
PL/SQL table
Analytic functions
Regular Expressions: avoiding hard coding
Project: Data cleansing
Sending catch up file: by date , or by cust_id?
Class 2
Oracle PL/SQL control structure and keyword
begin end
when
if
exit
exist
loop
session
commit
rollback
Cursor
explicit
implicit
ref cursor
Bulk collect
Project: Prevent and remove duplicate
Class 3
Oracle objects
Funtion
parameter order and named
return
cursor as parameter
return cursor
pl/sql table as parameter
return pl/sql table
table function
Procedure
return values?
Package spec and body
global variable
Views
Trigger
Autonomous
Mutating table
in line procedure, in line function
with
Project: table_to_file
Class 4
performance
index
function based index
active distinc values
dup_val_on_index
hint to silently remove dupe value
compress
partition
hint
parallel processing
materilized view
global temprorary table
dblink and clob
truncate vs delete
Dynamic SQL
Project: supporting a QA project
Class 5
error handling
common errors
when others
error log table
continue on error
space estimate and management
connecy by
pivote and unpivot table
v$session etc
Project On line Application support
password repeating characters
returning object to front end