Career Enabler™ - Oracle Developer Training & Certification Courses
 800 Ratings

Oracle Authorized Training Partner Expert Chat

#1 Offshore IT Training Company

Guarantee to Run the Classes

Get Trained by Industry Expert

Overview

The course covers several concepts and terminologies, including Developer and DBA Technologies. The curriculum also consists of sessions on Programing with SQL/PLSQL, Performance Tuning Features and Database Designing.

Students additionally undergo simulated internship, which is a unique Koenig offering where students prepare themselves for on-the-job requirements. Candidates face real life scenarios where they need to develop small applications, and then have to apply learnt technologies. This training is ideal for people who are new to the technology. It provides high end practical exposure necessary for becoming an IT professional.

Course Content / Exam(s)

Schedule for Career Enabler™ - Oracle Developer

Course Name Exam # Duration (days)
Introduction to RDBMS

Course Content

Course : Introduction to RDBMS

    1
    Oracle Database: Introduction to SQL

    Course Content

    Course : Oracle Database: Introduction to SQL

    • Using the SET Operators
    • Introduction to Data Definition Language
    • Using Conversion Functions and Conditional Expressions
    • Reporting Aggregated Data Using the Group Functions
    • Displaying Data from Multiple Tables Using Joins
    • Using Subqueries to Solve Queries
    • Managing Tables using DML statements
    • Controlling User Access
    • Manipulating Data
    • Managing Data in Different Time Zones
    • Introduction to Data Dictionary Views
    • Creating Sequences, Synonyms, Indexes
    • Creating Views
    • Managing Schema Objects
    • Retrieving Data by Using Subqueries
    • Manipulating Data by Using Subqueries
    • Introduction
    • Retrieving Data using the SQL SELECT Statement
    • Restricting and Sorting Data
    • Using Single-Row Functions to Customize Output
    1Z0-0615
    11g: Program with PL/SQL

    Course Content

    Course : 11g: Program with PL/SQL

    • Introduction
    • 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
    1Z0-1445
    11g: Advanced PL/SQL

    Course Content

    Course : 11g: Advanced PL/SQL

    • PL/SQL Programming Concepts Review
    • Designing PL/SQL Code
    • Using Collections
    • Manipulating Large Objects
    • Using Advanced Interface Methods
    • Performance and Tuning
    • Improving Performance with Caching
    • Analyzing PL/SQL Code
    • Profiling and Tracing PL/SQL Code
    • Implementing VPD with Fine-Grained Access Control
    • Safeguarding Your Code Against SQL Injection Attacks
    1Z0-1463
    FMW11g: Build Applications with Oracle Forms

    Course Content

    Course : FMW11g: Build Applications with Oracle Forms

    • Using WebUtil to Interact with the Client
    • Introducing Multiple Form Applications
    • Running a Forms Application
    • Working in the Forms Builder Environment
    • Creating a Basic Form Module
    • Creating a Master-Detail Form
    • Working Data Blocks and Frames
    • Working with Text Items
    • Creating LOVs and Editors
    • Creating Additional Input Items
    • Creating Noninput Items
    • Creating Windows and Content Canvases
    • Working with Other Canvas Types
    • Producing and Debugging Triggers
    • Adding Functionality to Items
    • Displaying Run-Time Messages and Alerts
    • Using Query Triggers
    • Validating User Input
    • Controlling Navigation
    • Overriding or Supplementing Transaction Processing
    • Writing Flexible Code
    • Sharing Objects and Code
    5
    Oracle Reports Developer 10g: Build Reports

    Course Content

    Course : Oracle Reports Developer 10g: Build Reports

    • Introduction to Oracle Reports Developer
    • Designing and Running Reports
    • Exploring Oracle Reports Developer
    • Creating a Paper Report
    • Enhancing a Basic Paper Report
    • Managing Report Templates
    • Creating a Web Report
    • Enhancing Reports Using the Data Model: Queries and Groups
    • Enhancing Reports Using the Data Model: Data Sources
    • Enhancing Reports Using the Data Model: Creating Columns
    • Enhancing Reports Using the Paper Layout
    • Controlling the Paper Layout: Common Properties
    • Controlling the Paper Layout: Specific Properties
    • Web Reporting
    • Extending Functionality Using XML
    • Creating and Using Report Parameters
    • Embedding a Graph in a Report
    • Enhancing Matrix Reports
    • Coding PL/SQL Triggers
    • Extending Functionality Using the SRW Package
    • Maximizing Performance Using OracleAS Reports Services
    • Building Reports: Efficiency Guidelines
    5
    Oracle Application Express: Developing Web Applications

    Course Content

    Course : Oracle Application Express: Developing Web Applications

      1Z0-4505
      Overview of Advanced Technologies

      Course Content

      Course : Overview of Advanced Technologies

      • Application Express other modules
      • Performance Tuning Options
      • Database Administration
      • Data Warehouse
      • Apps Technical/ DBA Technologies
      • Database Migration/ Integration
      1
      Simulated Internship&trad;

      Course Content

      Course : Simulated Internship&trad;

        3
        Oracle Database 11g: SQL Tuning Workshop Release 2

        Course Content

        Course : Oracle Database 11g: SQL Tuning Workshop Release 2

        • Exploring the Oracle Database Architecture
        • Introduction to SQL Tuning
        • Introduction to the Optimizer
        • Interpreting Execution Plans
        • SQL_PLAN View
        • Application Tracing
        • Optimizer: Table and Index Operations
        • Optimizer Join Methods
        • Optimizer: Other Operators
        • Case Study: Star Transformation
        • Optimizer Statistics
        • Using Bind Variables
        • Using SQL Tuning Advisor
        • Using SQL Access Advisor
        • Using Automatic SQL Tuning
        • SQL Performance Management
        1Z0-1173
        Total 36

        Career Enabler™ - Oracle Developer Benefits

        This course will cover the following modules:

        Upon Completion of this Course, you will accomplish following:-

        • Introduction to RDBMS
        • Introduction to SQL
        • 11g: Program with PL/SQL
        • 11g: Advanced PL/SQL
        • 11g: Administration Workshop I
        • 11g: SQL Tuning Workshop Release 2
        • FMW11g: Build Applications with Oracle Forms
        • Oracle Reports Developer 10g: Build Reports
        • Oracle Application Express: Developing Web Applications NEW 
        Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle Developer Training Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

        Enquire Now

         


         
        Loading...

        Processing data, please wait...