Oracle Database

Course Duration: 3 Months

Course fee: Contact us for fee detail.

Description:
NITT provides Oracle Database Training that can lower IT costs, while maintaining security. Expand your business with a broad portfolio as a database administrator. Learn how this technology enables your business to consolidate onto database clouds and engineering systems. Deep dive into Oracle Exadata and Oracle Database Appliance courses led by industrial expert and certified instructors. Explore Oracle Database categories.

Course Outline

Introduction to Oracle

  • Introduction
  • Data
  • Database
  • DBMS & RDBMS

DB Installation

Oracle DB Structure

Schema, Other Objects

SQL Intro

SQL Developer

SQL Query

  • Retrieving Data Using SQL Statement
  • Restricting and Sorting Data
  • Using Single Row Functions to Customized Output
  • Using Conventional Functions
  • Conditional Expressions
  • Reporting Aggregate Data Using Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Sub Query
  • Set Operators
  • Manipulating Data
  • Using DDL Statements
  • Creating Other Schema Objects

Oracle Fusion 11g Forms

  • Developer Forms Intro
  • Introduction to Oracle Form Builder
  • Forms Environment
  • Running Oracle Forms
  • Create Basic Form
  • Create Master Detail Form

Working with Data Blocks

Working with Text Items

Create LOVs and Editors

Create Additional Input Items

Creating Non Input Items

Canvas

  • Creating Windows and Content Canvases
  • Working with Other Canvas Types

Triggers

  • Introduction to Triggers
  • Producing Triggers
  • Debugging Triggers
  • Adding Functionality to Items
  • Run Time Messages and Alerts
  • Query Trigger

Validation

Navigation

Transaction Processing

Writing Flexible Code

Sharing Objects and Code

Multiple Form Application

Reports

  • Introduction to Reports Builder
  • Creating Simple Report”
  • Reporting Control with Parameters
  • Creating Master Detail Report
  • Creating Group Wise Report
  • Creating Matrix Report

Other Certifications

  • Agile Product Lifecycle Management 9 Implementation Specialist
  • MySQL 5.6 Database Administrator (Oracle Certified Professional-OCP)
  • Oracle 11g Data Warehousing (Certified Implementation Specialist)
  • Oracle Database 11g Administrator (Oracle Certified Professional-OCP)
  • Oracle Database 11g Security (Certified Implementation Specialist)
  • Oracle Database 11g SQL Tuning (Oracle Certified Expert-OCE)
  • Oracle Database 12c Administrator (Certified Professional-OCP)
  • Oracle RAC (Oracle Certified Expert-OCE)
  • Oracle WebLogic Server 12c (Oracle Certified Professional-OCP)