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)