| |
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.
Refine your search for "Database Training Courses"
A sample of courses in our "Database Training 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 Informix Dynamic Server and Informix Dynamic Server.2000 system administrators. Delegates will learn how to configure, initialize and administer one or more database servers, configure and test client connectivity and manage memory and disk usage.
An understanding of the UNIX operating system and the vi editor (basic commands only). A knowledge of relational database design and Informix SQL to the levels covered in the Relational Database Design and Informix SQL Part 1 courses respectively. Experience of UNIX administration would also be beneficial.
Price: £1850.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 course teaches you how to use the Transact-SQL language to query and program Microsoft SQL Server 2000 in a Windows 2000 Server environment. This course also assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
To ensure your success, we recommend you first take the following Element K courses or have equivalent knowledge:
Price: £1400.00
Full training course details
|
|
|
This course teaches you how to install, configure, administer, and troubleshoot Microsoft SQL Server 2000 in a Windows 2000 Server environment. This course also assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-228, Installing, Configuring, and Administrating Microsoft SQL Server 2000 Enterprise Edition.
To ensure your success, we recommend you first take either the
Windows 2000 for Windows NT Administrators: or have equivalent knowledge.
Price: £1400.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
|
|
|
