Oracle courses

...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...

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

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

...and dimensional modelling (DM) as competing alternatives, the presentation will focus on the use of DM techniques when developing and implementing a very large data warehouse...

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

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

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

...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...

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

...and Updating Rows Using Complex SubqueriesCreating Hierarchical QueriesUsing ROLLUP, CUBE and GROUPING SETS Group By EnhancementsImplementing the GROUPING...

...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 Business Area Granting Access to a Business Area Granting End User Privileges Simple, Complex and Custom Folders Managing Folders Managing Folder Items...

...Skills GainedThe delegates will practise:Creating Workbooks and WorksheetsCreating Table and Crosstab layoutsFormatting WorksheetsUsing GraphsUsing... Learn about: Data analysis, Oracle 10g...

...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...

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

...recovery and flashback operations. During this course, you gain experience with a variety of Oracle tools including Oracle Enterprise Manager (OEM)... Learn about: Database training...

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