Birmingham - Bristol - Cambridge - Coventry - Edinburgh - Glasgow - Kingston - Leeds - London - Manchester - Slough

Oracle training courses and schools
DBA/OCA/OCP

School: Catalyst Learning
[All Courses]

DBA Fundamentals
Course Format: Classroom
By the end of this course, the delegate will have been given practical experience in creating and managing an Oracle9i database and in using the various Oracle backup and recovery commands. The delegate will also have had practical experience in configuring Net Architecture, the Oracle Shared Server and the Listener. Experience of troubleshooting backup and recovery and simple network problem...
 

Forms Web Deployment
Course Format: Classroom
By the end of this course, the delegate will be able to customise Forms Services and successfully deploy Oracle Forms applications within a browser. Topics Covered: Introduction to Oracle Forms Services The OC4J Component The Forms Servlet and Forms Listener Servlet The Main Configuration Files Default Deployment The RunForm Tester Customising Forms Services The formswe...
 

SQL Performance Tuning
Course Format: Classroom
By the end of the course, the delegate will be able to tune applications for optimal performance; optimize SQL queries for faster access and tune code to reduce disk I/O and reduce network traffic. Topics Covered: Tuning Database Applications for Optimal Performance Managing Statistics Creating and Using Indexes and Clusters Creating and Using Views Structuring SQL Statements...
 

PL/SQL Web Applications
Course Format: Classroom
By the end of this course, the delegate will be able to construct web-based applications using the PL/SQL Web Toolkit and related packages. Topics Covered: Database and Application Servers The Client Browser Application Server and URL Request Handling Structure of Uniform Resource Locators Introduction to HTML and Basic HTML Tags Accessing Web-based PL/SQL Procedures Ba...
 

Oracle Program with PL/SQL
Course Format: Classroom
By the end of this course, the delegate will be able to write PL/SQL programs, manage stored program units, implement package constructs and handle Large Objects programmatically. The content of the course covers all the topics required for the Oracle 9i PL/SQL Developer Certified Associate Examination #1Z0-147. Topics Covered: The PL/SQL Program Structure Variables and Constants ...
 

ORACLE Fundamentals
Course Format: Classroom
By the end of this course, the delegate will be able to: Select data from an Oracle Database using SQL*Plus Generate simple reports from selected data Create and alter tables, indexes and views Create, update and delete records Grant and revoke access privileges Access the Data Dictionary Describe the Basic Structure of a PL/SQL Block Use PL/SQL IF Statements, Expressions and L...
 

PL/SQL
Course Format: Classroom
By the end of the course, the delegate will be able to write programs which use some or all of the primary PL/SQL programming constructs. Together with the PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle 9i PL/SQL Developer Certified Associate Examination #1Z0-147. Together with the SQL course, this course is suitable for delegates inten...
 

ORACLE Overview
Course Format: Classroom
This seminar is designed to give delegates an understanding of the concepts of an Oracle database, its capabilities and features. A product overview that covers the basic features of the Oracle database such as Oracle architecture, database objects, transaction processing and security. By the end of this seminar delegates will be able to identify the main features that are available with an O...
 

Introduction to SQL
Course Format: Classroom
On completion of the course, the delegate will have a basic understanding of the structure of a relational database and the functions of a DBMS. They will have a working knowledge of the ANSI Standard Structured Query Language (SQL) allowing them to access database tables. Topics Covered: Introduction to Databases Functions of a DBMS Benefits of a DBMS Relational Database Stru...
 

Relational Databases
Course Format: Classroom
On completion of this course, delegates will have an understanding of the structure of a Relational Database Management System and have sufficient knowledge to converse with RDBMS professionals. Topics Covered: Introduction to Databases Database Management Systems Database System Development Conceptual Data Models Entities Attributes Relationships Constraints Assump...
 

Page(s):- 1 2 3 4 5 6 7 8 9 10 11 12 [ Popular Topics ] [ Schools Only ]