Oracle Database 12c: PL/SQL I - Introduction

Catalog Home Databases, Business Intelligence & Data Science Oracle Programming

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.

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.

2-3 Days/Lecture & Lab

Application designers and database developersDatabase administratorsWeb server administrators

  • 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




< >

Recently Viewed Courses:

Copyright © 2018 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media