USA LaoTu 高薪转行做数据第一平台

只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on February 16, 2016, 12:10:50 PM

Title: Oracle 12c PL/SQL programming 第二期 16:00 to 19:00 Saturday 03/26 to 05/07
Post by: USA LaoTu Support Team on February 16, 2016, 12:10:50 PM

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.

Title: 视频: Oracle 12c PL/SQL programming 第二期 16:00 to 19:00 Saturday 03/26 to 05/07
Post by: USA LaoTu Support Team on March 22, 2016, 12:01:47 PM

 视频：USALaoTu 美国老土 289th 专业求职辅导周会 PL/SQL老师介绍课程 20160316， 回答同学们问题。  (https://youtu.be/4Z2Auyf18D0)