CLASSROOM
TENTATIVE

SCHEDULES


Sep 11, 2017 9:00 am 18:00 pm
Sep 12, 2017 9:00 am 18:00 pm
Sep 13, 2017 9:00 am 18:00 pm
Sep 14, 2017 9:00 am 18:00 pm
Sep 15, 2017 9:00 am 18:00 pm
REGISTER NOW

ORACLE

PL/SQL FUNDAMENTALS

DESCRIPTION
The course introduces PL/SQL programming language basics, including the basic programming block structure, conditional statements, looping constructs, and additional functionality to extend the use of SQL.
COURSE CONTENT
  • Overview of PL-SQL
  • Entering and running PL/SQL Code
  • PL/SQL Block Structure
  • Variables and Identifiers
  • Using %TYPE and %ROWTYPE
  • PL/SQL Control Structures
  • Using Local PL/SQL Procedures and Functions
  • Using Cursor Variable to Retrieve Data
  • Working with PL/SQL Data Structures
  • Handling PL/SQL Errors
  • Overview of Procedures, Functions and Packages
  • Managing Stored Procedures and Functions
  • Managing Packages
  • Overview of Triggers
  • Designing Triggers
  • Managing Triggers in a Database
  • Manipulating Large Objects