PL/SQL


About The Course


Course Topic Overview and Description:

In this Oracle 11g PL/SQL Bundle you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Requirements

  • Familiarity with database and programming principles

Benefits of taking this course:

  • Prepare your environment
  • Introducing Database Program Units
  • Creating and Maintaining Packages
  • Using System-Supplied Packages
  • Creating and Maintaining Database Triggers
  • Implementing System Event Triggers
  • Work with Oracle database tools
  • Understand and work language features
  • Work with DECLARE, BEGIN & EXCEPTION clause
  • Understand and use nested blocks
  • Use explicit cursors

 

The course is for 5 days. Various instructional methods will be used to teach the objectives mentioned above. The training method would be completely interactive and participative. Students will receive course materials which will be discussed during class.

Who Should Attend:

This course is designed for people that are looking to become application designers and developers, database administrators or business users and non-technical senior end users.

Related Job Functions:

  • Application designers and developers
  • Database administrators
  • Business users and non-technical senior end users

Course Delivery:

The course will be delivered using formal lectures combined with questions based on the topics. The class will be conducted both online and in-person. 

     Aepona      AIG      Ciber      Cognizant      Costco      CVS      Danya            Futrend      Futrend      KIPT      KIPT      Mphasis      NEC      OPC      Pfizer      Prokarma      T-Mobile      Trizetto      Walgreens      Xavient     

Copyright © 2015 PeopleNTech Institute of Information Technology.
All rights reserved.| Developed By PeopleNTech Software Limited