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

Author Topic: Oracle 12c PL/SQL programming 第二期 16:00 to 19:00 Saturday 03/26 to 05/07  (Read 7377 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Oracle 12c PL/SQL programming 第二期  16:00 to 19:00 Saturday 03/26 to 05/07  total 7 x 3 hour = 21 hour.

Sat, Mar 26, 2016 4:00 PM - 7:00 PM PDT
Sat, Apr 2, 2016 4:00 PM - 7:00 PM PDT
Sat, Apr 9, 2016 4:00 PM - 7:00 PM PDT
Sat, Apr 16, 2016 4:00 PM - 7:00 PM PDT
Sat, Apr 23, 2016 4:00 PM - 7:00 PM PDT
Sat, Apr 30, 2016 4:00 PM - 7:00 PM PDT
Sat, May 7, 2016 4:00 PM - 7:00 PM PDT

Industry Oracle PL/SQL expert teaches real world Oracle PL/SQL experience.

Pre-requisition: Oracle 12c SQL (Core Package class).

class 1: programming in pl/sql
         purpose: the students are able to create and run one pl/sql program unit
         1. introduction to pl/sql
         2. creating and running pl/sql code
         3. pl/sql language fundamentals
            (1) pl/sql block structure
            (2) pl/sql character set, identifiers, literals, semicolon delimter, comments, pragma, labels

class 2: pl/sql program structure
         purpose: the students are able to grasp the program syntax
         1. conditional and sequential control
         2. iteration processing with loops
         3. exception handler

class 3: pl/sql program data
         purpose: the students are able to grasp the common pl/sql data type
         1. primitive data type
         2. date and timestamp
         3. record
         4. collection
         5. object
      
class 4: pl/sql application construction
         purpose: the students are able to grasp common pl/sql program unit type
         1. procedure, function, package
         2. trigger
         3. pl/sql unit testing, performance tuning fundamental
      
class 5: sql in pl/sql
        purpose: the students are able to grasp the bulk operation, transaction and dynamic sql
         1. dml in pl/sql and bulk dml operation
         2. transaction management

class 6: large object data manipulation         
         purpose: manipulate un-structured large object data
         1. clob, blob, bfile
         2. manipulate large object data

class 7: advanced pl/sql topics
         purpose: advanced pl/sql topics
         1. native and interpreted compilation
         2. call external java and c++ program unit
         3. row/column based access control
         4. result cache
         5. sql injection


More detail later.