Mississauga College of Technology

Tel: 905.232.8628 Fax: 905.232.1672

Address: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5

E-mail: info@mississaugacollege.com

Advance Oracle PL/SQL   <OAPL113>

Scope

The course will cover PL/SQL and its advance features.

Objective

The candidate shall be able to apply concept and skills in production database industry and its environment.

Topics

  • Introduction to PL/SQL
  • Declaring Variables and Writing Executable statements
  • Interacting with the Oracle Server and Writing control Structures
  • Working With Composite Data Types
  • Writing Explicit Cursors Advance Explicit cursor Concepts
  • Creating Procedures and Functions
  • Handling Exceptions
  • Managing Subprograms
  • Creating Packages and Package Concepts
  • Working with Oracle Supplied Packages
  • Manipulating Large Objects
  • Creating Database Triggers
  • Advance Trigger Concepts
  • Managing local, and remote dependencies

Achievements

The Instructor lead practice sessions will reinforce students to work independently and confidently in the production environment.

Pre-requisites

SQL, knowledge of Database

Audience

Programmers, Analysts, pursuing to become a PL/SQL programmer, DBA, Project leader

Duration:39 hours

Fee:$880.00

Copyright © 2012 Mississauga College of Technolog All Rights Reserved
Call Today: 905-232-8628
blogger
linkedin
twitter
facebook
EmailEmail: info@mississaugacollege.com
AddressAddress: 240-33 City Centre Dr. Mississauga, ON. L5B 2N5
Developed by Jimvisual