Oracle

What is Oracle?

Oracle is world’s largest RDBMS (Relational Database Management System) which is the 1st RDBMS in the world which introduced the concept of Objects in RDBMS because of which it is also called as ORDBMS(Object Relational Database Management System).

What Oracle does?

With the help of Oracle, we can create various objects like Tables, Views, Indexes, Cluster, Sequence, Procedure, Function, Package, Triggers, Synonym which will help in storing data in Database and retrieving records on the basis of business logic. A very simple example of knowing how Oracle has made our lifes easier is ATM machines installed at various parts of World with the help of which we can do operations on our bank accounts 24*7.

Not only we can withdraw money from ATMs, we can also do various operations like :
  • Deposit of Cash / Cheque
  • Mini Statement
  • Balance Enquiry Pin Change
  • Cheque Book Request etc.

ERP INTRODUCTION

SQL
  • Introduction
  • Writing Basic SQL Statement
  • Restricting & Sorting Data, Single Row Functions
  • Displaying Data From Multiple Tables
  • Aggregating Data Using Group Functions
  • Sub-Queries
  • Producing Readable Output With iSQL*Plus
  • Manipulating Data, Creating and Managing Tables
  • Including Constraints
  • Creating Views & Other Database Objects
  • Controlling User Access
  • Oracle 9i Extensions to DML and DDL Statements
PL/SQL
  • Introduction
  • Declaring Variables, Writing Executable Statements
  • Interacting With The Oracle Server
  • Creating Procedures, Functions & Packages
ORACLE APPLICATIONS ARCHITECTURE APPS FILE SYSTEM DESIGNING CUSTOM APPLICATION
  • Create & Register DB User
  • Create Base Path
TABLE CREATION & REGISTRATION
  • WHO Columns
APPLICATION DEVELOPER
  • Form Design & Registration
  • Define Functions
  • Create Menus
SYSTEM ADMINISTRATOR
  • Create Application Users
  • Create Responsibilities
  • Create Data Groups
MAINTAIN APPLICATION SECURITY
  • Non Form Function
  • Menu Exclusions
IMPLEMENTING LOV
  • IMPLEMENTING ROW LOV
IMPLEMENTING QUERY FIND WINDOW IMPLEMENTING MASTER DETAIL CONCURRENT PROGRAMS
  • Requests
  • Define Request Groups
  • Request Sets
  • Value Set
  • Reports
CONCURRENT PROCESSING
  • Overview of Concurrent Processing
  • Life Cycle of a Concurrent Request
  • Concurrent Managers
  • Parallel Concurrent Processing
REQUEST WINDOW FLEXFIELDS
  • Descriptive Flexfields
  • (Enable Existing DFF)
  • Descriptive Flexfields
  • (Creation)
  • Key Flexfields
  • Concepts
What's 5 + 15 =

class for demo

NEW BATCH STARTED

Noida
Jamia Nagar Batch
Maharani Bagh Batch
Patna

Our COURSES

Partners

query button