Training >> Courses >> Oracle Developer 9i

PL/SQL

Course Description

This course covers the objectives of Exam #1Z0-007 and Exam #1X0-147, which are the two required exams for Oracle Developer Certified Associate (OCA).  This course provides in depth coverage of SQL and Oracle PL/SQL.  Oracle SQL*PLUS will be also be introduced in this course.  In addition to designing SQL*PLUS reports, create Oracle procedures, functions and packages using PL/SQL program logic, trainees would learn to create and interact with database objects as well as create programs using Oracle Procedure Builder.

Course Objectives:

·	Student will learn how to design and create database tables and develop stored programs, database triggers and packages
·	Create and deploy SQL*PLUS reports and PL/SQL programs using Oracle Procedure Builder
·	Write program logic in PL/SQL and distinguish it with database level logic

Course Contents:

·	Introduction
·	Developing Simple PL/SQL Blocks
·	Declaring Variables
·	Writing Complex Queries
·	Stored Programs and Database Triggers
·	Controlling Flow in PL/SQL Blocks
·	Looping Constructs
·	Composite Datatypes
·	Declaring PL/SQL Tables
·	Cursors
·	Attributes
·	Handling Exceptions

Find out more about Amfasoft’s education offerings