Oracle PL/SQL Course

Course Details

• Benefits
• Foundational Knowledge, he course provides a comprehensive introduction to Oracle PL/SQL, ensuring students have a solid understanding of PL/SQL programming and Oracle database application development
• Hands-on Learning: Practical exercises and real-world examples help students develop their skills and confidence in working with PL/SQL in Oracle databases.
• Efficient and Secure Applications: Students will learn how to create efficient, maintainable, and secure applications in Oracle databases, improving their productivity and problem-solving abilities.
• Experienced Authors: The course is created by expert instructors with extensive knowledge and experience in Oracle PL/SQL and database programming, ensuring that students receive high-quality and up-t
• Real-World Applications: After completing the course, students will be able to apply their Oracle PL/SQL skills to develop and optimize data-driven applications, helping them make a tangible impact in
• PL/SQL Basics
• The HR Schema, What is PL/SQL?, Blocks
• Outputting Information
• Variables and Constants
• Constants, Data Types
• Naming Variables and Other Elements
• Embedding SQL in PL/SQL
• SELECT…INTO and RETURNING…INTO
• Using Variables (Exercise)
• PL/SQL Features
• Subprograms
• Introduction to Subprograms
• Procedures, Variable Declarations
• Parameters, Parameters with Default Values
• Parameter Modes, IN Mode, OUT Mode, IN OUT Mode
• Named Notation, Using SQL in a Subprogram
• %TYPE, Creating a Procedure (Exercise)
• Functions, Creating a Function (Exercise)
• Using PL/SQL Functions in SQL Queries
• Dropping a Subprogram
• Conditional Processing
• Conditions and Booleans
• IF-ELSIF-ELSE Conditions
• Creating a get_age() Function (Exercise)
• ELSIF
• Creating a check_rights() Procedure (Exercise)
• Creating an is_manager() Function (Exercise)
• BOOLEAN Values and Standard SQL
• The CASE Statement
• CASE Expressions
• Replacing the Head Honcho (Exercise)
• Exceptions
• Introduction to Exceptions
• Predefined Exceptions, The EXCEPTION Part of the Block
• Catching NO_DATA_FOUND Exception (Exercise)
• User-defined Exceptions, User-defined Exceptions in Subprograms
• Re-raising Exceptions, Replacing the Head Honcho (revisited) (Exercise)
• Adding Exceptions to update_employee_manager() (Exercise)
• Naming Unnamed Predefined Exceptions
• WHILE Loops
• When to Use Exceptions
• Cursors
• Implicit Cursors
• Using Implicit Cursor Attributes (Exercise)
• Explicit Cursors
• %ROWTYPE
• Explicit Cursor Use Case
• Cursor FOR LOOP
• Using an Explicit Cursor (Exercise)
• Cursor Parameters
• Packages
• Package Basics, The Package Specification
• The Package Body
• Modifying the Package (Exercise)
• Building an Employee Package
• Adding a get_manager() Function (Exercise)
• Overloading Subprograms
• Adding Overloaded Functions to the Package (Exercise)
• Auditing, Validation Procedures
• Adding a Validation Procedure (Exercise)
• Package Cursors
• Adding a Cursor to the Package (Exercise)
• Benefits of Packages
• Triggers
• What are Triggers?
• Trigger Parts
• Validation Triggers
• Creating a Trigger on the jobs Table (Exercise)
• The WHEN Clause
• Using the WHEN Clause (Exercise)
• Audit Triggers
• Statement-level Triggers
• Compound Triggers
• Trigger Warning