Course Description
This Oracle 11g PL/SQL Part 2 course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you’ll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP).
Upon successful completion of this course, you’ll stand out from your competition while you’re chasing your dream job!
What Will I Learn?
- Prepare your environment
- Introducing Database Program Units
- Creating and Maintaining Stored Procedures & Functions
- Creating and Maintaining Packages
- Advanced Cursor Techniques
- Using System-Supplied Packages
- Creating and Maintaining Database Triggers
- Implementing System Event Triggers
Requirements
- Familiarity with database and programming principles
Who is the target audience?
- Application designers and developers
- Database administrators
- Business users and non-technical senior end users
-
Introduction 00:03:00 -
Install Oracle XE 00:11:00
-
SQL Developer Installation
-
Workstation Setup 00:12:00
-
Introducing the Database Program Unit 00:19:00
-
Creating Stored Procedures and Functions 00:19:00
-
Understanding the Parameter Specification 00:23:00
-
Executing Procedures and Functions 00:26:00
-
Calling Functions from within SQL 00:13:00
-
Handling Compilation Errors 00:08:00
-
Recompiling and Dropping Programs 00:16:00
-
Data Dictionary Storage 00:25:00
-
Managing Dependencies 00:13:00
-
Tracking Dependencies 00:08:00
-
Using the Dependency Tracking Utility 00:09:00
-
What Is a Package? 00:10:00
-
Creating a Package 00:19:00
-
Package Definition Information 00:08:00
-
Advanced Programming Techniques 00:06:00
-
Using Persistent Global Objects 00:04:00
-
Including Initialization Logic 00:15:00
-
Object Oriented Support within Packages 00:14:00
-
Package Maintenance 00:18:00
-
Learning to Use Cursor Variables 00:24:00
-
Advanced Cursor Techniques Weak Cursor Definitions 00:16:00
-
REFCURSOR Cursor Definition 00:05:00
-
Using Cursor Expression 00:14:00
-
Using the DBMS OUTPUT() Package 00:12:00
-
Using the UTL FILE() Package 00:30:00
-
Understanding the Database Trigger 00:23:00
-
Statement-Level Triggers 00:23:00
-
Row-Level Triggers 00:12:00
-
Row Level Trigger Example 1 00:11:00
-
Row Level Trigger Example 2 00:07:00
-
Row Level Trigger Example 3 00:08:00
-
Working with the INSTEAD OF Trigger 00:11:00
-
Using Triggers within an Application 00:09:00
-
Using the CALL Statement 00:09:00
-
Trigger Maintenance Tasks 00:12:00
-
Work with Multiple Triggers for a Single Table 00:11:00
-
Handling Mutating Table Issues 00:22:00
-
Using the Compound Trigger 00:06:00
-
What Is a System Event Trigger 00:05:00
-
Defining Scope 00:04:00
-
Identifying Available System Events 00:12:00
-
Conclusion 00:02:00
Course Reviews
No Reviews found for this course.
or
Get all courses for only £492000+ Globally Recognised Premium Courses
This course includes:
