A training Course in Oracle SQL and PL/SQL

Duration

9 Saturdays

10am -5.00pm

£700

Introduction to SQL

Using SQL*PLUS Using SET and SHOW commands to control the environment Writing simple reports Prompting for user input Using the SELECTcommand Datatypes and pseudocolumns Selecting & Ordering rows & Columns

Books on ORACLE SQL, PL/SQL ....

---

Entity-relationship modelling

Capturing entities, attributes & identifiers
Describing relationships: one-to-one, one-to-many, many-to-many
Optional and mandatory relationships
Guidelines for a well-formed E-R diagram

---

Additional SQL query techniques

Handling null values
Using functions and expressions
Joining Tables
Table aliasing
SQL Functions
SQL formatting results
Oracle's SQL statement processing

---

Sub-Queries

UNION, INTERSECT and MINUS
Grouping data and applying aggregiate functions

---

Defining & Manipulating Objects in SQL

Working with tables
Schema, users and synonyms
Creating tables with CREATE TABLE
Adding, deleting and modifying data with INSERT, UPDATE, DELETE
Altering and dropping tables
The available data types
Efficient data access methods
Unique and non-unique indexes
Concatenated indexes
Utilising table clusters and hash clusters

---

Controlling Security And Maintaining Data Integrity in SQL

Constraints
The Importance of Referential Integrity
Maintaining referential integrity constraints at CREATE time

---

Transaction Processing and locking

The purpose of transactions
Controlling transactions through the use of COMMIT, ROLLBACK and SAVEPOINT
Data and Dictionary locks
Maintaining security through the use of views and roles
Creating views and synonyms
Specifying object priviledges using GRANT and REVOKE

---

Using The PL/SQL Language

PL/SQL architecture, Declaring constants, variables and records
Basic PL/SQL Programming Blocks
Incorporating SQL Statements into PL/SQL blocks
Control Logic and error handling
Defining and using conditional, iterative and sequential control
Creating exception handlers
Propagating exceptions

---

Cursors

Utilising implicit cursor attributes
Processing results with explicit cursors
Passing parameters to procedures and functions
Creating FOR-LOOP cursors
Improving updates and delete performance by using cursors

---

Advanced Server Programming

Subprograms
Creating procedures and functions
Adding parameters to procedures and functions
Packaging procedures and functions

---

Introduction to Developer 2000

What is Developer/2000?

---

Building Simple forms

How Forms interact with the Database
Running Forms
Using Forms Designer
Setting block properties/attributes
Using the Layout Editor

---

Systems Analysis & Design (via Case Study)

A step-by-step approach & techniques
Developing the logical data model
Mapping the data model to a relational model
Specifying integrity constraints
Developing the conceptual schema
Defining the data in the Data Dictionary

---

To book onto this Course or for further information please contact
BHI Net Centre
701 High Road
Seven Kings, Ilford
Essex IG3 8RH, UK

Phone : +44 (0)20 8590 2500
Fax: +44 (0)20 8590 2589

email: oracletraining@bhi-netcentre.co.uk

If this is the only frame you can see Click Here to see our full Training Portfolio