| |
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 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: £999.99
Full training course details
|
|
|
This course teaches you the Data Manipulation Language (DML) statements for the Structured Query Language (SQL), including SELECT, INSERT, UPDATE and DELETE. You will discuss simple and some complex ways of joining data. This course includes abundant hands-on exercises. At the end of the course, you will be able to query and modify data in an Informix database.
Delegates should be familiar with relational databases.
Price: £999.99
Full training course details
|
|
|
The objective of this course is to provide a comprehensive understanding of the advanced use of structured query language (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL.
The course will provide delegates with the ability to carry out advanced, complex Data Manipulation Statements (DML) to query on, and change the contents of a relational database and extends this to programming in the Transact-SQL language to create SQL scripts, Stored Procedures and Triggers.
Delegates should be familiar with the Microsoft SQL Server SQL Language to the level of the PTR SQL for SQL Server course.
Price: £999.99
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: £999.99
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: £999.99
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: £999.99
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: £999.99
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: £999.99
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: £999.99
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: £999.99
Full training course details
|
|
|
