Database Programming With PL/SQL - Ho Chi Minh City

Registration Information

Pre online registration for this workshop is required. Registration is limited and will be accepted on a first come basis.

You are required to register for this workshop on both BUILD-IT and Oracle website to secure your spot. 

Registration Close: July 17th, 2019 

To register, read the guide below.

REGISTRATION GUIDE

August 1, 2019 (All day) to August 9, 2019 (All day)

ASU Training room, floor 2, building C, Cao Thang Techical College Campus, 65 Huynh Thuc Khang, District 1, Ho Chi Minh City, Vietnam

Aug
01
When: Aug 1, 2019 - Aug 9, 2019, (All day)
Where:

ASU Training room, floor 2, building C, Cao Thang Techical College Campus, 65 Huynh Thuc Khang, District 1, Ho Chi Minh City, Vietnam

This course introduces participants to PL/SQL, Oracle's procedural extension language for SQL and the Oracle relational database. Participants explore the differences betwee SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database. This course culminates with a projec that challenges students to program, implement, and demonstrate a database solution for a business or organization

Duration:

  • Online: August 1st & 2nd, 2019 ; Face-to-face: August 7th, 8th, and 9th, 2019
  • Recommended total course tiem: 180 hours
  • Professional education credit hours for educators who complete Oracle Academy Training: 60

Prerequisites

Required

  • Previous experience with at least one programming language

Suggested

  • Previous experience with a database application
  • Oracle Academy Course - Database Design and Database Programming with SQL

Agenda

Time Details
DAY 1: Online
8:30 am - 10:30 am Opening; Section 1: Fundamentals: Introduction to PL/SQL; Benefits of PL/SQL; Creating PL/SQL Blocks
10:30 am - 10:40 am Break
10:40 am - 11:30 am Defining Variables and Datatypes: Using Variables in PL/SQL; Recognizing Pl/SQL Lexical Units; Recognizing Data Types
11:30 am - 1:30 pm Lunch break
1:30 pm - 3:00 pm Defining Variables and Datatypes: Using Scalar Data Types; Writing PL/SQL Executable Statements; Nested Blocks and Variable Scope; Good Programming Practices
3:00 pm - 3:15 pm Break
3:15 pm - 4:15pm Using SQL in PL/SQL: Review of SQL DML; Retrieving Data in PL/SQL
4:15 pm - 4:30 pm Break
4:30 pm - 5:30 pm Using SQL in PL/SQL: Manipulating Data in PL/SQL; Using Transaction Control Statements
DAY 2: Online
8:30 am - 10:30 am Program Structures to Control Execution Flow: Conditional Control: IF statement; Iterative Control: Basic Loops
10:30 am - 10:40 am Break
10:40 am - 11:30 am Program Structures to Control Execution Flow: Iterative Control: While and For Loops; Iterative Control: Nested Loops
11:30 am - 1:30 pm Lunch break
1:30 pm - 3:00 pm Using Composite Datatypes: User-Defined Records; Indexing Tables of Records
3:00 pm - 3:15 pm Break
3:15 pm - 4:15 pm Using Cursors and Parameters: Introduction to Explicit Cursors; Using Explicit Cursor Attributes; Cursor FOR Loops
4:15 pm - 4:30 pm Break
4:30 pm - 5:30 pm Using Cursors and Parameters: Cursors with Parameters; Using Cursors For Update; Using Multiple Cursors
DAY 3: Face - to - Face
8:30 am - 10:30 am Exception Handling: Handling Exceptions; Trapping Oracle Server Exceptions; Trapping User - Defined Exceptions; Recognizing the Scope of Exceptions
10:30 am - 10:40 am Break
10:40 am - 11:30 am Using and Managing Procedures: Creating Procedures; Using Parameters in Procedures; Passing Parameters
11:30 am - 1:30 pm Welcome lunch (by BUILD IT)
1:30 pm - 3:00 pm Using and Managing Functions: Creating Functions; Using Functions in SQL Statements
3:00 pm - 3:15 pm Break
3:15 pm - 4:15 pm Using and Managing Functions: Review of the Data Dictionary; Managing Procedures and Functions
4:15 pm - 4:30 pm Break
4:30 pm - 5:30 pm Using and Managing Functions: Review of Object Privileges; Using Invoker's Rights and Autonomous Transactions
DAY 4: Face - to - Face
8:30 am - 10:30 am Using and Managing Packages: Creating Packages; Managing Package Concepts; Advanced Package Concepts
10:30 am - 10:40 am Break
10:40 am - 11:30 am Getting the Best out of Packages; Persistent State of Package Variables; Using Oracle-Supplied Packages
11:30 am - 1:30 pm Lunch Break (self served)
1:30 pm - 3:00 pm Improving PL/SQL Performance: using Dynamic SQL
3:00 pm - 3:15 pm Break
3:15 pm - 4:15 pm Improving PL/SQL Performance: Improving PL/SQL Performance
4:15 pm - 4:30 pm Break
4:30 pm - 5:30 pm Using and Managing Triggers: Introduction to Triggers; Creating DML Triggers Part 1, 2
DAY 5: Face - to - Face
8:30 am - 10:30 am Using and Managing Triggers: Creating DDL and Database Event Triggers; Managing Triggers
10:30 am - 10:40 am Break
10:40 am - 11:30 am Recognizing and Managing Dependencies: Introduction to Dependencies; Understanding Remote Dependencies
11:30 am - 1:30 pm Lunch Break (self-served)
1:30 pm - 3:00 pm Using PL/SQL Compiler: Using PL/SQL Initialization Parameters; Displaying Compiler Warning Messages
3:00 pm - 3:15 pm Break
3:15pm - 4:15 pm Using the PL/SQL Compiler: Using Conditional Compilation; Hiding your Source Code
4:15 pm - 4:30 pm Break
4:30 pm - 5:30 pm Projects in class Show time