Comprehensive Oracle PL/SQL

PT27250
Summary
The course provides a comprehensive introduction to PL/SQL, Oracle’s procedural language extension to SQL. PL/SQL is used to write stored procedures, packages, and database triggers. PL/SQL will be of particular interest to individuals developing applications in a client-server or multi-tier environment. This course can be taught for any Oracle version. This course is intended to provide experienced Oracle developers with the advanced SQL skills needed to effectively design and code complex queries and applications required to solve enterprise business problems. Coding examples and workshops serve to reinforce the material presented in class. This course can be taught for any Oracle version, including through Oracle 18c.
Prerequisites
Oracle SQL or equivalent experience
Duration
5 Days/Lecture & Lab
Audience
Programmers and Database Administrators responsible for the development or maintenance of application systems which access an Oracle database. Programmers, Analysts, Database Administrators, and Users who require advanced SQL techniques to access data in an Oracle database.
Topics
  • Overview of PL/SQL
  • Variables and Constants
  • PL/SQL Executable Statements
  • Embedding SQL Within PL/SQL
  • Explicit Cursors
  • Handling Exceptions
  • PL/SQL Stored Programs
  • Oracle 18c New Features
  • Next Level Multi-table Operations
  • Grouping Data
  • Analytic Functions
  • Hierarchical Queries
  • INSERT and MERGE
  • Introduction to SQL Performance
  • Flashback Query
  • Oracle 18c New Features

Related Scheduled Courses