Courses | Oracle | Instructor Led Courses   | Oracle Database: PL/SQL Fundamentals

Oracle Database: PL/SQL Fundamentals

Oracle Database: PL/SQL Fundamentals

Instructor-Led Training Course

 Virtual Live Instructor

 Free Training Manual

 Free Repeat

Course Details

 

Course Description:

  The Oracle Database 12c: PL/SQL Fundamentals course is a 5-day course that is designed to teach students Oracle database programming using the PL/SQL programming language. Students will learn the syntax, structure and features of the language.

The course will also provide a foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.

Students will also learn the use of database-resident stored program units such as procedures, functions, packages and database triggers. New features introduced with the Oracle 12c release of the database are also discussed and demonstrated.

This course is taught using version 12c, but the topics are applicable for either version 11g or 12c.

Topics covered in the course include:

  • SELECTION & SETUP OF THE DATABASE INTERFACE
  • ABOUT BIND & SUBSTITUTION VARIABLES
  • CHOOSING A DATABASE PROGRAMMING LANGUAGE
  • PL/SQL LANGUAGE FUNDAMENTALS
  • DECLARE SECTION
  • BEGIN SECTION
  • EXCEPTION SECTION
  • EXPLICIT CURSORS
  • DATABASE-RESIDENT PROGRAM UNITS
  • CREATING STORED PROCEDURES & FUNCTIONS
  • EXECUTING STORED PROCEDURES & FUNCTIONS
  • MAINTAINING STORED PROGRAM UNITS
  • MANAGING DEPENDENCIES
  • CREATING & MAINTAINING PACKAGES
  • ADVANCED PACKAGE CAPABILITIES
  • ADVANCED CURSOR TECHNIQUES
  • USING SYSTEM-SUPPLIED PACKAGES
  • DATABASE TRIGGER CONCEPTS
  • CREATING DATABASE TRIGGERS
  • MAINTAINING DATABASE TRIGGERS
  • IMPLEMENTING SYSTEM EVENT TRIGGERS

Target Student:This course is intended for Oracle professionals, both business and systems professionals.

Students should possess the following skills and experience before attending the course:

 

SELECTION & SETUP OF THE DATABASE INTERFACE

  • CONSIDERING AVAILABLE TOOLS
  • SELECTING THE APPROPRIATE TOOL
  • ORACLE NET DATABASE CONNECTIONS
  • ORACLE PAAS DATABASE CONNECTIONS
  • SETUP SQL DEVELOPER
  • SETUP SQL*PLUS
  • SETUP JDEVELOPER

    • UNDERSTANDING BIND & SUBSTITUTION VARIABLES
  • USING SQL DEVELOPER
  • USING SQL*PLUS

    • CHOOSING A DATABASE PROGRAMMING LANGUAGE
  • WHAT IS DATABASE PROGRAMMING?
  • PL/SQL PERFORMANCE ADVANTAGES
  • INTEGRATION WITH OTHER LANGUAGES

    • PL/SQL LANGUAGE FUNDAMENTALS
  • PL/SQL PROGRAM STRUCTURE
  • LANGUAGE SYNTAX RULES
  • EMBEDDING SQL
  • WRITING READABLE CODE
  • GENERATING DATABASE OUTPUT
  • SQL*PLUS INPUT OF A PROGRAM BLOCK

    • DECLARE SECTION
  • UNDERSTANDING THE DECLARE SECTION
  • DECLARE PRIMITIVE TYPES
  • DECLARATION OPTIONS
  • NOT NULL
  • CONSTANT
  • DATA DICTIONARY INTEGRATION
  • %TYPE
  • DECLARE SIMPLE USER-DEFINED TYPES
  • TYPE ... TABLE
  • TYPE ... RECORD
  • EXTENDED USER-DEFINED TYPES

    • BEGIN SECTION
  • UNDERSTANDING THE BEGIN SECTION
  • MANIPULATING PROGRAM DATA
  • LOGIC CONTROL & BRANCHING
  • GOTO
  • LOOP
  • IF-THEN-ELSE
  • CASE

    • EXCEPTION SECTION
  • UNDERSTANDING THE EXCEPTION SECTION
  • ISOLATING THE SPECIFIC EXCEPTION
  • PRAGMA EXCEPTION_INIT
  • SQLCODE & SQLERRM Example
  • SQL%ROWCOUNT & SELECT...INTO

    • BEYOND THE BASICS: EXPLICIT CURSORS
  • UNDERSTANDING EXPLICIT CURSORS
  • EXTENDED CURSOR TECHNIQUES
  • FOR UPDATE OF Clause
  • WHERE CURRENT OF Clause
  • Using FOR…LOOP Cursors

    • INTRODUCING DATABASE-RESIDENT PROGRAM UNITS
  • UNDERSTANDING DATABASE-RESIDENT PROGRAMS
  • PHYSICAL STORAGE & EXECUTION
  • TYPES OF STORED PROGRAM UNITS
  • STORED PROGRAM UNIT ADVANTAGES
  • MODULAR DESIGN PRINCIPLES

    • CREATING STORED PROCEDURES & FUNCTIONS
  • STORED PROCEDURES & FUNCTIONS
  • CREATE PROCEDURE / CREATE FUNCTION
  • CREATING PROCEDURES & FUNCTIONS
  • RAISE_SALARY() Procedure
  • SALARY_VALID() Function
  • THE PARAMETER SPECIFICATION
  • DEFAULT Clause
  • SYSTEM & OBJECT PRIVILEGES
  • USING THE DEVELOPMENT TOOLS

    • EXECUTING STORED PROCEDURES & FUNCTIONS
  • CALLING PROCEDURES & FUNCTIONS
  • UNIT TESTING WITH EXECUTE
  • ANONYMOUS BLOCK UNIT TESTING
  • SPECIFYING A PARAMETER NOTATION
  • SQL WORKSHEET UNIT TESTING
  • CALLING FUNCTIONS FROM SQL

    • MAINTAINING STORED PROGRAM UNITS
  • RECOMPILING PROGRAMS
  • Mass Recompilation Using UTL_RECOMP()
  • DROPPING PROCEDURES & FUNCTIONS
  • DROP PROCEDURE / FUNCTION
  • DATA DICTIONARY METADATA
  • Using USER_OBJECTS
  • Using USER_SOURCE
  • Using USER_ERRORS
  • Using USER_OBJECT_SIZE
  • Using USER_DEPENDENCIES

    • MANAGING DEPENDENCIES
  • DEPENDENCY INTERNALS
  • TRACKING DEPENDENCIES
  • THE DEPENDENCY TRACKING UTILITY
  • SQL DEVELOPER DEPENDENCY INFO
  • DEPENDENCY STRATEGY CHECKLISTS

    • CREATING & MAINTAINING PACKAGES
  • UNDERSTANDING PACKAGES
  • CREATING PACKAGES
  • MAINTAINING PACKAGES
  • PERFORMANCE CONSIDERATIONS

    • ADVANCED PACKAGE CAPABILITIES
  • DEFINER & INVOKER RIGHTS
  • WHITE LISTS & ACCESSIBLE BY
  • PERSISTENT GLOBAL OBJECTS
  • DEFINING INITIALIZATION LOGIC
  • OBJECT ORIENTATION SUPPORT

    • ADVANCED CURSOR TECHNIQUES
  • USING CURSOR VARIABLES
  • Using SYS_REFCURSOR
  • USING CURSOR EXPRESSIONS

    • USING SYSTEM-SUPPLIED PACKAGES
  • DBMS_OUTPUT()
  • UTL_FILE()
  • FOPEN() Example

    • DATABASE TRIGGER CONCEPTS
  • UNDERSTANDING DATABASE TRIGGERS
  • DML EVENT TRIGGER SUB-TYPES
  • DATABASE TRIGGER SCENARIO
  • TRIGGER EXECUTION MECHANISMS
  • TRIGGERS WITHIN SQL WORKSHEET

    • CREATING DATABASE TRIGGERS
  • STATEMENT-LEVEL TRIGGERS
  • Using RAISE_APPLICATION_ERROR()
  • ROW-LEVEL TRIGGERS
  • EXAMPLES OF TRIGGERS
  • EMPLOYEE_SALARY_CHECK Example
  • EMPLOYEE_JOURNAL Example
  • BUDGET_EVENT Example
  • INSTEAD OF TRIGGERS
  • TRIGGERS WITHIN AN APPLICATION

    • MAINTAINING DATABASE TRIGGERS
  • CALL SYNTAX
  • TRIGGER MAINTENANCE TASKS
  • SHOW ERRORS TRIGGER
  • DROP TRIGGER
  • ALTER TRIGGER
  • MULTIPLE TRIGGERS FOR A TABLE
  • HANDLING MUTATING TABLE ISSUES

    • IMPLEMENTING SYSTEM EVENT TRIGGERS
  • WHAT ARE SYSTEM EVENT TRIGGERS?
  • DEFINING THE SCOPE
  • AVAILABLE SYSTEM EVENTS
  • SYSTEM EVENT ATTRIBUTES

    •  

    Please check the course description to find prerequisite information.

     

     

    We offer live-instructor group training classes for your team.

    Upskill your team from the comfort of your office or online.

    Benefits of Group Training Include:

    • Experienced Professional Instructor Trains Your Team
    • Content Focused On Your Team's Needs
    • Convenient Scheduling and Class Setup
    • Significant Per/Student Cost Savings
    • Online, On-Site and Blended Options Available

     

    -10%

    Oracle Database: PL/SQL Fundamentals

    Instructor-Led Training Course

    $ 2995
    5-Day Course

    • Free Repeat
    • Professional Instructors
    • Official Course Materials
    • Free Training Materials
    • Small Class Sizes
    Army
    Cisco
    AirForce
    New York City
    Marines
    Michigan

    Testimonials

    This was the class I needed.

    The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.

    I finally understand how to use Excel.

    -Amanda T (Yale New Haven Hospital).

    Great class!

    We were able to cover a lot of information in one day without getting overwhelmed.

    -Maria R (Microsoft).

    Public Class Schedule

    Instructor led training is a cost effective and convenient learning platform for busy professionals. Most courses are available at over 300 locations nationwide and Online.

    The classes are taught via the RCI method by professionally certified instructors, and are usually limited to 12 or less students. Each student receives a training manual and practice problems, along with a free course retake. Click here to learn more about Instructor Led Training

    Below is a list of upcoming Oracle12c Instructor Led Class Dates:


    Location: Available Nationwide and Online
    Class Date(s):     12/9/2024 - 12/13/2024
    Course Fee : $2995






    Location: Available Nationwide and Online
    Class Date(s):     1/13/2025 - 1/17/2025
    Course Fee : $2995






    Location: Available Nationwide and Online
    Class Date(s):     2/17/2025 - 2/21/2025
    Course Fee : $2995






    Location: Available Nationwide and Online
    Class Date(s):     3/17/2025 - 3/21/2025
    Course Fee : $2995






    Location: Available Nationwide and Online
    Class Date(s):     4/14/2025 - 4/18/2025
    Course Fee : $2995






    Location: Available Nationwide and Online
    Class Date(s):     5/12/2025 - 5/16/2025
    Course Fee : $2995






    Location: Available Nationwide and Online
    Class Date(s):     6/16/2025 - 6/20/2025
    Course Fee : $2995





    Need Oracle Group Training?

    We offer private Oracle group training services for organizations looking to upskill their team members with a live-instructor.

    Training options include:

    • Onsite Training
    • Remote Training
    • Blended (Onsite and Remote Combined)

    Learn more about how Oracle Private Group Training from Business Computer Skills can help your team.

    Request a
    FREE QUOTE

    Company

    Course Types

    Support