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.phpPrice:
$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