SrivenInfoTech

Courses Offered

DotNet | Java | TIBCO | Testing | Data Wareghousing | Oracle | SAP | PHP | SQL
SharePoint | C | C++ | Projects

Oracle

Course Contents Click Here

Oracle 9i

DBMS concepts
Oracle Architecture and Terminology
Introduction to SQL and Data types
1. SQL Statements, Working with SELECT statement
1. Operators usage in SELECT
1. Order by Clause, Functions and Group Functions
1. Revision of last three classes (Optional)
1. Conversion functions
1. Decode, Case and miscellaneous
Group by and having clauses
Nested queries
Integrity constraints and executions of DDL,DML,
Joins
DB Objects in Oracle 9i
Security
Exercise and Revision of SQL
Introduction to PLSQL, Block Structure
Conditional Statements and Loops
Types of variables, their declaration and scope
Exception Handling
Cursors
Sub programs, Procedures
Functions
Packages
Database Triggers
Revision/Doubts

Oracle 10g

Developer 2000

Introduction to D2k
Oracle Form Module
Master-detail relationship
Layout editor and Property palette
Block Items
Triggers
Alerts
LOVs
Canvases and Windows
Visual Attributes, Property classes and object groups
Form Parameters
Menus
Oracle Reports
Types of reports
Types of columns
Miscleneous concepts in reports
Hands-on exercises on forms and reports

Oracle Apps Technical

Oracle SQL and PLSQL
Developer 2000
Introduction to Oracle Applications
Coding Standards
Database stuff and file system
Custom Application development
Form development in Apps environment
Query find and row-lov implementation
Report generation in Apps environment
XML publisher reports
Message dictionaries
Interfaces (GL_INTERFACE)
DFF(Descriptive flex fields)
KFF(Key flex fields)
Oracle Workflow builder
Introduction and explanation on Oracle Alerts
Miscellaneous topics in Oracle Applications(Imp)
Revision/Doubts

Oracle Apps(Financials)

Introduction to Oracle Apps FinancialsUniverse Designer
Modules GL, AP, AR, CM and FA
- General Ledger (GL)
- Accounts Payable (AP)
- Accounts Receivable (AR)
- Cash Management (CM)
- Fixed Assets (FA)
Application Implementation Methodology (AIM)
Fundamentals of System Administration
Oracle 11i Footprint

Send Your Query
Name:	*
Country:
State:
City:
Email:	*
Skype ID:
Contact No:	-
Course Interested:	*
	Online Offline *
Subject:	*
Message:	*


*Note:All Fields Are Required....................
Chat-IDs : Yahoo ID: sriveninfotech, Skype ID: sriveninfotech