| |
On this page you will find details of Training Centres offering classroom based instructor led courses.
A summary of the range of courses offered by each Training Centre is provided along with full contact details. For an overview of the course contents for each provider, simply click on a subject area within their listing and you will be presented with a list of courses offered by that particular provider.
Training courses in our "Oracle Courses" school
|
This course is designed for Network Administrators, Database Administrators, Technical Support Analysts and System Administrators and gives delegates a firm foundation in fundamental database administration tasks, loading and transporting for databases and the utilities used to perform these activities. The course also includes an introduction to networking concepts and configuration parameters and how to solve common network problems. Delegates will configure network parameters so that database clients and tools can communicate with the Oracle database server. This course addresses backup and recovery techniques and examines various backup, failure, restore and recovery scenarios. Delegates examine backup methodologies based on business requirements in a mission critical enterprise. Delegates use multiple strategies and Oracle Recovery Manager to perform backups and restore and recovery operations. Two interactive workshops are included in this course to provide delegates with the opportunity to walk through numerous real-world networking, backup and recovery case studies.
Certification: For students studying towards Oracle9i Database Administrator certification, this course provides the core knowledge for exam 1Z0-033 (Oracle9i: DBA Fundamentals II).
Delegates must have an understanding of basic operating system commands (eg move, copy, delete files). Delegates must also have attended course O9iDBAI (Oracle9i: DBA Fundamentals I).
Price: £2207.00
Full training course details
|
|
|
This course is intended for Network Administrators, Database Administrators, System Administrators, Application Developers, MIS Managers and Technical Support Personnel.
Certification: For students studying towards Oracle8i DBA certification this course provides the core knowledge for exam 1Z1-024 (Enterprise DBA – Part 2 -Performance Tuning).
Delegates should have attended DBA1A (Enterprise DBA – Part 1 – Architecture and Administration). They would also benefit from having Oracle7, Oracle8 or Oracle8i database administration experience and a thorough knowledge of Oracle architecture. Experience with Oracle Performance Manager and Oracle Enterprise Manager would also be beneficial.
Price: £2207.00
Full training course details
|
|
|
This course is designed for Database Administrators, Technical Support Analysts and System Administrators. It will give the Oracle database administrator (DBA) a firm foundation in basic administrative tasks and provide the necessary knowledge and skills to create and manage the structures of an Oracle9i database. The course teaches delegates to use an administration tool to start-up and shutdown a database, create a database, manage file and database storage and manage users and their privileges. The course also teaches delegates to organise the database and to move data into and between databases under different environments.
Certification: For students studying towards Oracle9i Database Administrator certification, this course provides the core knowledge for exam 1Z0-031 (Oracle9i: DBA Fundamentals I).
Delegates must have attended course SQLINT (Introduction to Oracle9i: SQL). An understanding of stored procedures, functions and packages concepts would be beneficial.
Price: £2008.00
Full training course details
|
|
|
This course is intended for Application Developers, System Analysts, Database Administrators and Technical Support Personnel. This course offers delegates an extensive introduction to data server technology and covers the concepts of relational/object relational databases, as well as the powerful SQL programming language. Delegates are shown how to create and maintain database objects and to store, retrieve and manipulate data. Delegates learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators and hierarchical retrieval. Delegates also learn to write SQL and SQL*Plus script files using iSQL*Plus tool to generate report-like output.
Certification: For students studying towards OCP certification, this course provides the core knowledge for exam 1Z0-007 (Introduction to Oracle 9i: SQL).
Delegates must be familiar with data processing concepts and techniques.
Price: £1822.00
Full training course details
|
|
|
This course is designed for Oracle Application Developers and Technical Support Professionals. Delegates will build and test interactive Internet applications. Working in a graphical user interface (GUI) environment, delegates will learn how to customise forms with user input items such as check boxes, list items and radio groups. They will also learn how to modify data access by creating event-related triggers.
Display form modules in multiple windows and use a variety of layout styles
Deploy form modules on the Web Implement triggers to enhance functionality to interact with GUI controls
Implement triggers to communicate with users
Implement triggers to supplement validation and control navigation
Implement triggers to modify default transaction processing
Implement triggers to control user interactions
Reuse objects and code
Link one form module to another
Create form modules, including components for database interaction and GUI controls
Delegates should have attended SPLI (Introduction to Oracle : SQL & PL/SQL) or INSPLI (Introduction to Oracle for Experienced Users) and DPP (Develop PL/SQL Program Units).
Price: £1822.00
Full training course details
|
|
|
This course is designed for Oracle Application Developers and Technical Support Professionals. Delegates will have an opportunity to broaden their building skills using Oracle Forms Developer. Delegates will create multiple-form Internet applications and learn how to manage multiple transactions across modules. Delegates will also practice enhancing their applications with custom menus, reports and charts. Finally, the course teaches delegates to enhance the user interface for Web-deployed forms using Java Beans.
Ensure application security with Oracle8i database roles
Implement triggers that respond to function keys, mouse movement and mouse button actions and Window manipulation
Create and manage multiple form Internet applications
Manage transaction processing in multiple form Internet applications
Create, modify and attach menu documents to Oracle Forms Developer Internet applications
Choose appropriate data sources for data blocks
Work with Oracle8i objects in Form Builder
Enhance the user interface with Java Beans
Include charts and reports in Oracle Forms Developer Internet applications
Delegates should have attended SPLI (Introduction to Oracle : SQL & PL/SQL) or INSPLI (Introduction to Oracle for Experienced Users) and DPP (Develop PL/SQL Program Units).
Price: £1436.00
Full training course details
|
|
|
This database administration course is intended for those who are responsible for managing, maintaining and supporting Oracle version 8.
At the end of the course delegates will be able to create and manage database users, implement a security system to control their activities, define a backup strategy and perform recovery in the event of a system failure and tune the database to optimize performance.
Knowledge of the target operating system is helpful. Delegates should also be competent in the skills covered by the PTR Oracle SQL*Plus Fundamentals course.
Price: £1240.00
Full training course details
|
|
|
The course works on the principle that “if you have done it you will understand it”. Therefore do expect this course to involve you a great deal in discussions, workshops and especially examination of the system hands on. By the end of the course you will be familiar with Oracle’s client interface, the SQL*PLUS monitor and with simple SQL queries. In particular, you will come to understand the technical language surrounding Oracle and will gain immediate credibility talking to the experts you will inevitably have to work with. Furthermore, by understanding the technology, the descriptions of risk will become immediately understood.
This hands-on course is intended for auditors and security specialists who are aware their businesses use Oracle based products, but do not understand the database platform and therefore the risks it may carry. You will learn how Oracle is built and a concept of what the various categories of user do on the database and the risks they carry.
Hands on labs will show you how to scan the system for objects, especially sensitive tables. And to find out who can do what to them. Further more, in this age of web technology, the concept of the authenticated user accessing parts of your data is passing away. It could be anyone!
Before coming on the course, delegates should feel confident inputting instructions on a command line and accessing files on a filing system. Some exposure to a database environment is useful.
Price: £1020.00
Full training course details
|
|
|
This course provides an introduction to Oracle SQL*Plus and is aimed at programmers and other developers producing systems using Oracle database software.
At the end of the course delegates will be able to use Oracle SQL*Plus to create and maintain Oracle databases.
A good knowledge of computing principles, no formal programming experience necessary.
Price: £855.00
Full training course details
|
|
|
This intensive course is intended for IT professionals who already have a through knowledge of SQL in another relational database environment, but who are now working in an Oracle environment, including Application Developers, System Analysts, Database Administrators and Technical Support Personnel. This course gives delegates an understanding of Oracle’s relational and object relational database management systems through the powerful SQL language. The SQL commands, functions and operators supported by oracle as extensions to standard SQL are emphasised. Delegates learn to create and maintain database objects such as tables, indices, views, constraints and sequences. Delegates also learn to store and retrieve by using advanced techniques such as grouping sets, SET operators and hierarchical retrieval. Delegates also learn how to manipulate data. Finally, delegates learn to write SQL script files using iSQL*Plus tool and to generate report-like output.
Certification: For students studying towards OCP certification, this course provides the core knowledge for exam 1Z0-007 (Introduction to Oracle9i: SQL).
Delegates must have a thorough working knowledge of standard ANSI SQL or SQL in another relational database environment. Familiarity with relational database concepts is also required.
Price: £772.00
Full training course details
|
|
|
The goal of this fourteen-day accelerated course is to provide IT professionals with the advanced knowledge and skills necessary to administer the world's leading database systems and applications. This is a performance-based course designed upon the job-related tasks an advanced professional must perform using new or modified features in the Oracle® systems.
The Training Camp's Program for Oracle 8i & 9i DBA Certified Professional Certification affords students the ability to live, learn, and take the vendor exams on-site at our education centres throughout the US and Europe. Our program is delivered in a distraction-free, immersed environment with on-site, deluxe accommodations - utilizing a curriculum adapted specifically for accelerated learning.
Our instructors are seasoned industry professionals (ranging from renowned authors to senior information technology consultants) with extensive real-world knowledge that is effectively relayed throughout our Oracle Training Camps. The program instructor shall be available at all times to provide individual and group attention, lead lab exercises and practice sessions, and ensure the students’ success. Our attention to detail shows in our unsurpassed instruction and customer service, our classroom and testing facilities, and our individual and corporate success stories.
From the skilful crafting of our unique curriculum to our careful selection of courseware to every detail of your training comfort, The Training Camp is the best way to obtain your Oracle Certification. Other training providers cannot match our commitment to quality instruction-led training and top-notch educational facilities.
Price: £0.00
Full training course details
|
|
|
