Oracle PL/SQL Fundamentals Vol. I II

Oracle PL/SQL Fundamentals vol. I & II

.MP4, AVC, 1000 kbps, 1280&720 | English, AAC, 64 kbps, 2 Ch | 97 Lectures | 20 hours | 7.68 GB

A complete introduction to PL/SQL database programming language

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).

What are the requirements?

Familiarity with database and programming principles

What am I going to get from this course?

Over 97 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