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

...and transaction control Access control The Data Dictionary...

...Before taking any exam, delegates must ensure they have the recommended experience. Topics Covered: The Structure of a Relational Database Using SQL*Plus... Learn about: Updating and deleting rows in database tables...

...It is suitable for users of Oracle Forms from release 9i. Delegates:This course is designed to equip programmers and software developers with the... Learn about: Implementing techniques to improve performance...

...Column Objects and REF Columns Alternative Data Sources - FROM Clause Queries Alternative Data Sources - Stored Procedures Handling Server Errors Reusable... Learn about: Reusing standard components and Java Beans, To provide the skills needed to design...

...up and Restoring the Database Monitoring the Performance of the Database Using Advisors Requirements: Delegates should have an understanding of relational... Learn about: Configuring the database...

...who are required to plan and implement database backup and recovery strategies for Oracle10g databases. This course is also suitable for delegates...

...Oracle Database 11g and how these can be implemented in their current Oracle installations. Topics Covered: Installing Oracle Database 11g Software Creating...

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

...Resource Manager Automating management tasks with the Scheduler Who will the Course Benefit? This Oracle Database 11g Release 2 DBA - Part II course...

...Use different tuning methodologies Use the database advisors to proactively tune. Suitable for: Database administrators, application developers and technical...

...Data Produce Reports Use Discoverer Plus & Discoverer Viewer. Suitable for: This course is designed for personnel requiring the skills necessary to query... 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...

...a Business Area Granting End User Privileges Simple, Complex and Custom Folders Managing Folders Managing Folder Items Importing and Exporting from...

...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: To provide the skills needed to install, Administer and support Oracle 10g AS...

...managing the finances of a cost centre or department. Delegates: This course is designed for users in a finance department or anyone with devolved responsibility... Learn about: Interrogate and modify them...

...Topics Covered: Overview of the Oracle Account Payables process Supplier Set Up Supplier Management Enter, Review and Approve Supplier Invoices Adjust... Learn about: Process invoices, Credit notes and payments, Submit reports...

...Invoices Process Prepayments Process Holds and Releases Enter and Process Credit and Debit Memos Process Employee Expense Reports Process Single Payments... Learn about: Submit reports, Credit notes and payments, Locations and items; create quotations...

...Manage Requisition Process Receipts and Returns Topics Covered: Requisitions Shop for Items from a Store Browse Categories View a Requisition Use Shopping... Learn about: Make corrections and record details of any returns...