Courses in Bath

...to be able to provide the day-to-day administration of an Oracle 10G/11G based system. The class is based on the Oracle Enterprise Edition...

...flashback functions RMAN enhancements Log Miner Data Transfer and Storage Asynchronous Change Data Enhanced Table Functions Enhanced MERGE functionality...

...SQL new features New operators: cross join, natural join, using, on Outer join operators Case expression enhancements Constraint enhancements New SQL functionality...

...The course is for experienced Oracle Version 10.2 DBAs. DURATION: 2 days. Hands on. OBJECTIVES: This event is designed to bring existing R10.2 DBAs...

...Working with SORTS, TOTALS, Percentages Drilling the Data Graphing Data Workbook maintenance Working with SQL and setting options Using SQL functions...

...Discoverer support for Oracle Applications Creating Ad Hoc Queries Using the Workbook Wizard Creating a simple query and viewing the Output Customizing...

...This course is ideal for: Database administrators, Developers, Power end users proficient in basic SQL, Data warehouse support team, First line support...

...records Associative arrays (index by tables) Multiple inserts Table functions (pipelined and parallel) Using ref cursors Diagnosing contention Explicit...

...Learn to find out where this performance ceiling is and at what level the current system is running. Essentially there are two main avenues for RDBMS optimisation...

...Using Oracle AS Management Tools · Using the EM Application Server Control · Using the Command-Line Interface · Identifying Service Status Managing & Configuring...

...Oracle Application Express (formerly HTML DB) is a Web-based application development tool integrated with Oracle9i Database Release 2 and all releases of Oracle Database...

...They will be able to provide support and advice to users of an Oracle database up to and including 9i. Suitable for: The course is for support staff...

...system on which the database is mounted (e.g. Unix, Windows etc). DURATION: 2 days. Hands on. OBJECTIVES: On completion of the course delegates will be able...

...On completion of the course delegates will be able to: - Describe the principal features of an Oracle 10G based system. - Describe the principal building...

...of an Oracle database without recourse to external assistance. This course is suitable for Oracle release 9i & 10G. COURSE CONTENT: Monitoring Database...

...maintenance and configuration of databases. Students will also gain the ability to administer users, perform backups, recover a database, use the...

...ROLLUP as an extension to the group by clause to produce subtotal values Using CUBE as an extension the group by clause to produce subtotal values Using...

...Introduction Reverse Engineering Entities Relationships PHYSICAL TRANSACTION Introduction: The Real System-Logical to Physical Conversion Implementing...

...It is also an essential element in managing the risks inherent in change and innovation. PRINCE2 is a comprehensive, structured project management method... Learn about: Prince 2, Project Manager...

...practical introduction to the PRINCE2 method. AUDIENCE: All staff who will undertake a significant role in a PRINCE2 project including project managers... Learn about: Project Management, Project Manager, Prince 2...