StayAhead Training Ltd courses

...Professional examination (IZ0-007) Oracle Database SQL Expert (IZ0-047) Oracle Database 11g: SQL Fundamentals (IZ0-051) Objectives: By the end of this course... Learn about: Controlling User Access to Database Objects...

...By the end of this course, the delegate will be able to: Use SQL*Plus and SQL Developer effectively Write SQL statements to query an Oracle Database Create...

...character, date, conversion and miscellaneous. Suitable for: This course is designed for anyone who needs to access and work with an Oracle Database... Learn about: Updating and deleting rows in database tables...

...FilesThe JInitiator Java ClientBuilt-in Optimisation FeaturesPerformance ConsiderationsMigration Issues... Learn about: Implementing techniques to improve performance...

...for delegates intending to sit the Oracle PL/SQL Developer OCA examination #1Z0-141: Oracle Forms: Build Internet Applications . Note: Exams are not included... Learn about: Reusing standard components and Java Beans, To provide the skills needed to design...

...tasks on Oracle Database 10g. The course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks... Learn about: Configuring the database...

...Complete and Incomplete Database Recovery Recover a Database from Non-Critical Losses Perform Logical Backups with Export and Import Utilities Use...

...administer, monitor, backup and support Oracle Database 11g. Objectives: This course is designed to provide the knowledge and skills needed to maintain...

...Data Recovery Advisor and Flashback Transaction Management using Flashback and LogMiner RMAN New Features Data Pump Data Compression Data Guard Improvements...

...administering and troubleshooting an Oracle 11g database. Examinations This course covers the main topics of the Oracle exam #1Z0-052 Oracle Database... Learn about: Creating and Managing an Oracle Database, Installing and Configuring Oracle...

...Recovery Strategy Validate the Recovery Strategy Session 2: ORACLE RECOVERY STRUCTURES AND PROCESSES Architectural Components of Backup and Restore Redo...

...By the end of the course, delegates will be able to: Use different tuning methodologies Use the database advisors to proactively tune a database Use...

...ItemsCustomising Display PropertiesConditions and ParametersReporting on your ResultsScheduling ReportsCustomising, Importing and Exporting ReportsAdvanced... Learn about: Creating Workbooks and Worksheets...

...At the end of this course the successful delegate will be able to:- Create Discoverer Workbooks View, Create, Modify and Run ad hoc Queries Chart and Analyse...

...Grant and Control User Access Understand the relationship between Application Server and Discoverer Components Configure Discoverer for the Web Topics Covered...

...At the end of this course the successful delegate will be able to:- Complete a basic setup of the Apache HTTP Server Setup and configure the Oracle... Learn about: Administer and support Oracle 10g AS, To provide the skills needed to install...

...for managing the finances of a cost centre or department. Objectives: By the end of this course, delegates will have an understanding of the capabilities... Learn about: Interrogate and modify them...

...Suitable for: This course is designed for users in Finance and Accounts Payable departments. Delegates: This course is designed for users in Finance and Accounts Payable departments... Learn about: Submit reports, Process invoices, Credit notes and payments...

...and Refunds Generate Payment Batch Processing Period Closing Process Run Accounts Payable Reports... Learn about: Submit reports, Credit notes and payments, Locations and items; create quotations...

...lists Make a non-catalog request The Checkout process Sending for Approval Adding Attachments Copy a Requisition Change a Requisition Edit Requisition... Learn about: Make corrections and record details of any returns...