Course Detail
  • Oracle 12c maintains a scalable, highly available enterprise platform and reduces complexity by using the powerful new tools and cloud enhancements of Oracle Database 12c. Determine the way to build and populate Oracle databases, perform effective queries, design applications and secure your enterprise data. Oracle Database 12c: the whole course contains a comprehensive appendix covering commands, keywords, features and functions.You will get in-depth PL/SQL also as important information on managing large databases and using Oracle engineered systems.The Oracle12c certification helps in validation of your understanding of the Oracle Database 12c technology and sets the stage for your future progression.

Course Module
    • Introduction to PL/SQL
    • Declaring PL/SQL Variables
    • Writing Executable Statements
    • Using SQL Statements Within a PL/SQL Block
    • Writing Control Structures
    • Working with Composite Data Types
    • Using Explicit Cursors
    • Handeling Exceptions
    • Introduction Stored Procedures and Functions
    • Creating Procedures
    • Creating Functions
    • Debugging Subprograms
    • Creating Packages
    • Using Oracle-Supplied Packages in Applications Development
    • Using Dynamic SQL
    • Creating Triggers
    • Creating Compound, DDL, and Event Database Triggers
    • Design Considerations and PL/SQL Code
    • Tuning the PL/SQL Compiler
    • Managing Dependencies
    • Oracle Cloud Overview

Course Description
  • The learner must be skilled in working with windows environment.

  • Duration 2 Months
  • Course Type Offline