Oracle courses

...Examining the Efficiency ofSQLStatements usingSQLTrace and Autotrace Using Hints to Influence Execution Plan Identifying Unused Indexes PL/SQL Tuning Issues...

...staff who wish to gain a comprehensive understanding of how to perform the more advanced tasks whilst developing and maintaining an Oracle Database. This course is for programmers...

...Change management Database automation Storage management Fault diagnosis High-availability Security Partitioning Etc. At regular intervals, hands-on practicals...

...Date and Numeric Functions SQL*Plus Run-time Parameters and Variables SQL*Plus Control Parameters Producing Reports with SQL*Plus Creating and Changing...

...Define a Receipt Class Set up Bank Transaction Codes Import Electronic Bank Statements Automatic Statement Reconciliation Manual Reconciliation of Unreconciled...

...PREREQUISITES: Delegates should be familiar with Web browsers and a good knowledge of Windows applications is required. DURATION: 2 days. Hands...

...This course describes, via examples and hands-on exercises, the Oracle database and its architecture. Emphasis is placed not only on what Oracle's features...

...and INTERVAL Functions and Literals Overview of Analytic Functions Ranking Data by Value and Percentile Providing Cumulative, Moving and Centered Aggregates...

...a Physical Standby Database Data Protection Modes Log Transport Services Data GuardSQLApply Architecture Create a Logical Standby Database Switchover...

...Financials Awareness Seminar, delegates will have gained an understanding of the capabilities of the main Oracle Financials modules and how they integrate with each other...

...Concepts & Facilities or equivalent knowledge. Summary: Designed for the Oracle beginner-DBA in particular and the Oracle apprentice-DBA in general...

...Designers Orchestrating web Services web Service basics The evolution of SOAP, WSDL and UDDI Introducing the concepts of service orchestration Design principles...

...a Business Area Granting Access to a Business Area Granting End User Privileges Simple, Complex and Custom Folders Managing Folders Managing Folder Items...

...who have budgetary responsibility or departmental purchasing officers. Learning Objectives By the end of this Oracle Purchasing (PO) course delegates...

...processes and schema objects. Summary: This course discusses all of the Oracle index options: B*tree Bitmap Hash Partitioned Index clustered table...

...in querying and updating an Oracle database Together with the SQL course, this course covers the major topics required for the following Oracle examinations...

...Built-in Procedures and Functions User Interface Objects PL/SQL Libraries and Database Program Units Canvases and Windows Reusing Objects and Properties...

...Oracle R12 Inventory course is designed for end users working either within a Finance department or in stores or equivalent areas. Learning Objectives...

...Getting Started Entering and Executing SQL Statements Editing SQL Statements Creating, Editing and Executing SQL Files Using SQL Developer What is Oracle...

...in organisations with large systems who are planning to migrate to Oracle 10G from an earlier release or who have already done so. This course is aimed...