Oracle PL/SQL Fundamentals vol. I & II by Udemy
A complete introduction to PL/SQL database programming language
Course Highlights
- 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
Skills you will learn!
Curriculum
51 Topics
Introduction
Course Setup
Selecting the Appropriate Database Tool
Understanding PL/SQL
PL/SQL Blocks
Working with SQL Plus
DECLARE Clause Objects
PL/SQL Available Data Types
Declaring Simple Data Types and Assignments
Declaring Complex Data Types and Assignments
Declaring Complex RowTypes and Assignments
Declaring Complex Tables
Declaring Complex Records
Creating and Declaring User-Defined Types
What Can Be Included in the BEGIN Clause
Working with CHAR and VARCHAR2 Variables
Handling String Literals
Working with Numeric Variables
Working with Date Variables
Assigning and Using Boolean Variables
Using Comparison Operators
Using SQL Functions
SQL DML within PL/SQL
Using SELECT
Exceptions and Embedded SQL
Using Sequences
Logic Control and Branching
Using GOTO
Working with LOOPS
Creating and Using the Indefinite Loop
Creating and Using the Conditional Loop
Using Nested Loops
Using the If-Then-Else
Using the CASE Statement
What Are the Types of Exceptions
Trapping Exceptions
Identify Exception Details
Creating User-Defined Exceptions
Using SQLCODE and SQLERRM Objects
Understand the Implicit Cursor
Creating User-Defined Events
Understanding the Concept and Purpose of Explicit Cursors
Learn about Cursor Attributes
Using the Continue Statement
Working with Updateable Cursors
Creating and Using Cursor Parameters
FOR...LOOP Cursors
Understanding Nested Blocks
Difference between Global vs Local Objects and Exceptions
Subprograms: How They Differ from Nested Blocks
Conclusion
46 Topics
Introduction
Install Oracle XE
SQL Developer Installation
Workstation Setup
Introducing the Database Program Unit
Creating Stored Procedures and Functions
Understanding the Parameter Specification
Executing Procedures and Functions
Calling Functions from within SQL
Handling Compilation Errors
Recompiling and Dropping Programs
Data Dictionary Storage
Managing Dependencies
Tracking Dependencies
Using the Dependency Tracking Utility
What Is a Package?
Creating a Package
Package Definition Information
Advanced Programming Techniques
Using Persistent Global Objects
Including Initialization Logic
Object Oriented Support within Packages
Package Maintenance
Learning to Use Cursor Variables
Weak Cursor Definitions
REFCURSOR Cursor Definition
Using Cursor Expression
Using the DBMS OUTPUT() Package
Using the UTL FILE() Package
Understanding the Database Trigger
Statement-Level Triggers
Row-Level Triggers
Row Level Trigger Example 1
Row Level Trigger Example 2
Row Level Trigger Example 3
Working with the INSTEAD OF Trigger
Using Triggers within an Application
Using the CALL Statement
Trigger Maintenance Tasks
Work with Multiple Triggers for a Single Table
Handling Mutating Table Issues
Using the Compound Trigger
What Is a System Event Trigger
Defining Scope
Identifying Available System Events
Conclusion
Oracle PL/SQL Fundamentals vol. I & II
Thank You!
Your review has been submitted successfully.