Author Topic: Content of Oracle 11g PL/SQL Programming  (Read 6908 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3974
  • Karma: +35/-11
Content of Oracle 11g PL/SQL Programming
« 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