Overview
Course Description
Thank you for reading this post, don't forget to subscribe!Provides an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming.
Audience Profile
Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
- Application designers and developers Database administrators
- Business users and non-technical senior end users
Prerequisites
Oracle Database 11g – SQL Fundamentals
Learning Objectives
The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle database.
Course Outline
Course Outline
Module 1: Volume 1
Lessons
• Choosing a SQL & PL/SQL Interface
• Language Features
• Declare Clause
• Begin Clause
• Exception Clause
• Explicit Cursors
• Advanced Programming: Declared Subprograms
Module 2: Volume 2
Lessons
• Introducing Database Program Units
• Creating Stored Procedures & Functions
• Maintaining Stored Procedures & Functions
• Creating and Maintaining Packages
• Advanced Cursor Techniques
• Using System-Supplied Packages
• Relating Database Triggers
• Maintaining Database Triggers
• Implementing System Even Triggers