Oracle Database 12c: PL/SQL I - Introduction

PT9694
Training Summary
This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This course will also lay the foundation for the entire 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.PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.
Prerequisites
Either of the courses Oracle Database 12c: SQL Fundamentals (Levels I & II) or Oracle Database 12c: SQL Complete Library (Levels I, II, & III) are recommended prerequisites for this course.
Duration
2-3 Days/Lecture & Lab
Audience
Application designers and database developersDatabase administratorsWeb server administrators
Course Topics
  • 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
  • Beyond The Basics Explicit Cursors
  • Beyond The Basics Nested Blocks
  • Beyond The Basics Declared Subprograms

Related Scheduled Courses