SQL Star

Enquiry

 
 
 
 

Student Courses

Individual Modules

************* Downloads *************

 
Oracle Certification Red Hat Certification

Module Overview
Oracle 10g: PL/SQL [40 Hrs]

    Pre-Requisites for Course
      Oracle 10g: SQL

    Professional Certification Awarded
      Oracle Certified Associate (OCA)

   * Official Curriculum from Oracle

Module-1
* Oracle 10g: PL/SQL............................................................................ (Details)

Introduction to PL/SQL
Declare PL/SQL Identifiers
Write Executable Statements
Interaction with the Oracle Server
Control Structures
Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures
Stored Functions and Debugging Subprograms
Packages
Deploying Packages
Implement Oracle-Supplied Packages in Application Development
Dynamic SQL
Design Considerations for PL/SQL Code
Triggers
Creating Compound, DDL, and Event Database Triggers
PL/SQL Compiler
Manage PL/SQL Code
Manage Dependencies

 

Student Enquiry Form


Name*
Date of Birth*
Email ID*
Mobile No.*
Last Qualification*
Year of passing*
Current Status*
Course interested in*
Preferred SQL Star Centre*