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.