Objectives
Course Outline
Upon completing this course, the learner will be able to meet these overall objectives:

  • Enhance the knowledge and understanding of Database analysis and design.
  • Enhance the knowledge of the processes of Database Development and Administration using PL/SQL
  • Enhance Programming and Software Engineering skills and techniques using PL/SQL
  • Preparation of background materials and documentation needed for Technical Support using PL/SQL
  • Use the Relational model and how it is supported by PL/SQL
  • Course Overview
  • Programming in PL/SQL
  • Creating and Running PL/SQL Code
  • PL/SQL Program Structure
  • Loop Basics
  • Exception Handlers
  • PL/SQL Program Data
  • Strings
  • Numbers, Records, Collections
  • Miscellaneous Datatypes
  • SQL in PL/SQL
  • Data Retrieval
  • Procedures, Functions, and Parameters
  • Packages
  • Triggers
  • Managing PL/SQL Code
  • I/O and PL/SQL