MCSEClasses Certification Training Boot Camp MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security Military Discounts Testimonials About Us Linux/Unix Certification MCSD Certification Home MCSE Certification MCDBA Certification Cisco Certification Security Certification Java Certification Oracle® Certification CIW Certification Jobs Boot Camp Financing Boot Camp Pricing Boot Camp Technical Schedule Contact Us


Oracle Database 19c: PL/SQL Workshop

Course Length: 5 days
Class Schedule
Call for Class Schedule

  • Hands-on instruction by a certified instructor
  • Includes all course materials and practice exams
  • Includes all certification exams
  • Onsite Testing
  • Breakfast and Lunch provided each day

If airfare and lodging are not required, the price is £575 less for 2-week courses, and £285 less for one week courses.

This course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.

Course Objectives

  • Declare Variables
  • Write Executable Statements
  • Write Control Structures
  • Create Procedures and Functions
  • Create Packages
  • Create Triggers

Who Should Attend?

  • Database Administrators
  • Developers

Course Prerequisites

Oracle Database 19c: SQL Workshop

Agenda

  • Introduction
  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Using SQL Statements Within a PL/SQL Block
  • Writing Control Structures
  • Working With Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Introducing Stored Procedures and Functions
  • Creating Procedures
  • Creating Functions
  • Debugging Subprograms
  • Creating Packages
  • Working With Packages
  • Using Oracle Supplied Packages in Application Development
  • Using Dynamic SQL
  • Creating Triggers
  • Creating Compound, DDL and Event Database Triggers
  • Design Considerations for the PL/SQL Code
  • Tuning the PL/SQL Compiler
  • Managing Dependencies

MCSEClasses.com is your best choice for Oracle Database 19c PL/SQL, Oracle Database 19c PL/SQL training, Oracle Database 19c PL/SQL certification, Oracle Database 19c PL/SQL certification boot camp, Oracle Database 19c PL/SQL boot camp, Oracle Database 19c PL/SQL certification training, Oracle Database 19c PL/SQL boot camp training, Oracle Database 19c PL/SQL boot camp certification, Oracle Database 19c PL/SQL certification course, Oracle Database 19c PL/SQL course, training Oracle Database 19c PL/SQL, certification Oracle Database 19c PL/SQL, boot camp Oracle Database 19c PL/SQL, certification Oracle Database 19c PL/SQL boot camp, certification Oracle Database 19c PL/SQL training, boot camp Oracle Database 19c PL/SQL training, certification Oracle Database 19c PL/SQL course.



mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us





Search classes by keyword:
Search classes by category:

Copyright © 2025 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.