Course Code: 26390

Oracle PL/SQL Course

Class Dates:
6/3/2024
8/26/2024
Length:
5 Days
Cost:
$3120.00
Class Time:
Technology:
Database
Delivery:
Instructor-Led Training, Virtual Instructor-Led Training

Overview

  • Course Overview
  • This Oracle PL/SQL course is designed for people who are already familiar with Oracle SQL and want to learn the fundamentals of PL/SQL programming in Oracle Database. The course covers topics such as PL/SQL basics, subprograms, conditional processing, exceptions, cursors, packages, and triggers. Through practical exercises and real-world examples, students will gain a strong foundation in PL/SQL and learn how to create efficient, maintainable, and secure applications in Oracle databases.
  • Audience
  • Database Administrators, Analyst, ETL Developer, BI Developer, Data Science

Prerequisites

  • SQL

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