A complete introduction to PL/SQL database programming language
Oracle PL/SQL Fundamentals vol. I & II
Number of Lectures
What Will I Learn?
Over 90 lectures and 20 hours of content
Prepare your enviornment
Introducing Database Program Units
Creating and Maintaining Packages
Using System-Supplied Packages
Creating and Maintaining Database Triggers
Implementing System Event Triggers
Work with Oracle database tools
Understand and work work language features
Work with DECLARE, BEGIN & EXCEPTION clause
Understand and use nested blocks
Use explicit cursors
Familiarity with database and programming principles
In this Oracle 11g PL/SQL Bundle you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).
Who is the target audience?
Application designers and developers
Business users and non-technical senior end users
Udemy Link – https://www.udemy.com/oracle-plsql-fundamentals-vol-i-ii/