StayAhead Training Ltd courses

...By the end of this course, the delegate will be able to: Describe the structure of a relational database Use the command line features of SQL*Plus... Learn about: Controlling User Access to Database Objects...

...work with an Oracle Database. This course is suitable for users of versions 9i, 10g and 11g. Delegates: This course is designed for experienced SQL users...

...Use SQL run time parameters Use aggregate functions Use numeric, character, date, conversion and miscellaneous functions Use subqueries Create and alter tables... Learn about: Updating and deleting rows in database tables...

...Suitable for: This course is designed to equip programmers and software developers with the main techniques of deploying Forms on the web. It is suitable... Learn about: Implementing techniques to improve performance...

...6i Certified Professional examination #1Z0-132: Build Internet Applications Examination II . Together with the Forms - Part I course, this course is suitable... Learn about: To provide the skills needed to design, Reusing standard components and Java Beans...

...of the database and in carrying out basic administration tasks. The focus is on using Enterprise Manager to teach delegates how to carry out basic management of the database... Learn about: Configuring the database...

...Sources Use Automatic Database Management Monitor and Manage Storage Use Automatic Storage Management Monitor and Manage Memory Control Database Resources...

...successful and efficient day-to-day operations of Oracle Database 11g. The course will give experienced Oracle 9i database administrators practical experience in installing...

...This course is designed to provide the knowledge and skills needed to maintain successful and efficient day-to-day operation of Oracle Database...

...suitable for personnel who need to administer, monitor and support an Oracle Database 11g Release 1 or Release 2 database. Course Objectives This Oracle... Learn about: Creating and Managing an Oracle Database, Installing and Configuring Oracle...

...This course introduces delegates to the main concepts of Oracle backup and recovery. They will learn how to plan and implement a backup and recovery strategy using...

...Workload Repository Tune the SGA and Shared Pool Tune the data block buffers Automatic Shared Memory Management PGA and temporary space Checkpoint...

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

...and Worksheets Create and Manipulate Graphs Graphical Analysis Pivoting Data Drilling Data Sorting Data Creating and Managing Queries Using Summaries Creating...

...This course is designed for personnel responsible for the configuration and management of Oracle Discoverer with a relational datasource. Delegates:This...

...the configuration and management of the Oracle 10g Application Server. Delegates: This course is designed for personnel responsible for the configuration... Learn about: To provide the skills needed to install, Administer and support Oracle 10g AS...

...Ledger Overview Set of Books Chart of Accounts Structure Account Flexfield Design Accounting Calendars Functional currency Navigation General Ledger Inquiries... 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...

...up steps relating to Purchasing and how they affect the system in daily use. By the end of this course delegates will also be able to use Oracle Payables... Learn about: Credit notes and payments, Submit reports, Locations and items; create quotations...

...Delegates will learn how to: Manage Requisition Process Receipts and Returns. Suitable for: This course is designed primarily for end users of Oracle iProcurement... Learn about: Make corrections and record details of any returns...