ORACLE Fundamentals

Catalyst Learning
London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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 LOOP Constructs
Declare and use Cursors
Use record types and PL/SQL Tables
Handle Errors and Exceptions within PL/SQL Scripts

Topics Covered:

The Structure of a Relational Database
Using SQL*Plus
The Basic SQL Select Statement
Selecting Data from Multiple Tables
Grouping and Sorting Output
Character, Date and Numeric Functions
SQL*Plus Run-time Parameters and Variables
Producing Reports with SQL*Plus
Creating and Changing Tables, Indexes and Views
Inserting, Updating and Deleting Data
Controlling Access to the Database
Related Data Dictionary Tables and Views
The Structure of a PL/SQL Block
Declaring and Using Variables and Constants
Using SQL Statements in PL/SQL
PL/SQL Programming Constructs
Declaring and Using Cursors
Exceptions and Error Handling
Record Types and PL/SQL Tables

Requirements:

An understanding of IT. Some practical programming experience would prove advantageous.
...''

Phone:0800 953 0387

School Address:

175 Tottenham Court Road
London, W1T 7NU
UK

Jobs & Resumes: London
Houses & Roommates: London

Linux System Administration (LPI)
Linux Advanced System Administration (LPI)
Lotus
Nortel Networks
MCDST, MCSA, MCSE, MCDBA, MCAD, MCSD
Novell
Relational Databases
Introduction to SQL
ORACLE Overview
PL/SQL
Oracle Program with PL/SQL
PL/SQL Web Applications
SQL Performance Tuning
Forms Web Deployment
DBA Fundamentals
Oracle Database 10g DBA using Enterprise Manager
10g Discoverer for Administrators
Oracle 10g Application Server Administration
Oracle 11i System Administration

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.