StayAhead Training Ltd courses

...the delegate will be able to: Describe the structure of a relational database Use the command line features of SQL*Plus and SQL Developer Create SQL statements... Learn about: Controlling User Access to Database Objects...

...and SQL Developer Querying the Oracle Database Subqueries and in-line views Numeric functions Character functions Common date and timestamp functions Actual...

...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: Reusing standard components and Java Beans, To provide the skills needed to design...

...This course aims to give delegates practical experience in installing Oracle Database 10g software, configuring the database, performing basic monitoring... Learn about: Configuring the database...

...Delegates will learn how to monitor and improve database performance. They will also learn how to control database resources using Resource Manager...

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

...The course will give experienced Oracle database administrators practical experience in installing, configuring, administering and implementing an Oracle Database...

...day-to-day operations of an Oracle 11g database. The Oracle Database 11g administrator will gain practical experience in setting up, administering... Learn about: Creating and Managing an Oracle Database, Installing and Configuring Oracle...

...Checkpoints and Archives Multiplexing Control Files and Redo Logs Types of Database Failure Session 3: MEMORY MANAGEMENT Automatic Shared Memory Management...

...Delegates will be introduced to the main concepts of Oracle performance tuning and will gain practical experience in analyzing and tuning database performance...

...FeaturesAnalytical FunctionsDiscoverer Viewer... 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...

...Introduction to Discoverer Concepts Creating and Maintaining the EUL Creating Business Areas Managing and Developing a Business Area Granting Access...

...Cache Setup and configure the PL/SQL Gateway Configure Logging Establish Security. Suitable for: This course is designed for personnel responsible... Learn about: Administer and support Oracle 10g AS, To provide the skills needed to install...

...of the Oracle General Ledger system and will have gained the skills necessary to perform every day tasks. Topics Covered: Oracle Financials Overview General... Learn about: Interrogate and modify them...

...process invoices, credit notes and payments, submit reports, close accounts payable periods and transfer accounting details to the General Ledger... Learn about: Submit reports, Process invoices, Credit notes and payments...

...By the end of this course delegates will be able to use Oracle Purchasing to manage the procurement process. They will also know how to manage suppliers... Learn about: Submit reports, Credit notes and payments, Locations and items; create quotations...

...who may have no other involvement with Oracle Financials. No prior knowledge will be assumed. Objectives: Delegates will learn how to: Manage Requisition... Learn about: Make corrections and record details of any returns...