Oracle SQL Part 1: Introduction

Course Information

Objectives

At the end of the course the delegate should be able to :

Understand Oracle terminology.
Insert, update, and delete data from Oracle tables.
Produce query output from oracle data.
Understand and use the data dictionary.
Format queries in to Reports.

Target Student

The course is suitable for any personnel involved in the maintenance of Oracle applications and databases who have little or no knowledge of SQL.and who wish to construct their own queries and reports as well as basic update, insert and delete operations. The course is a pre-requisite for the Database Administration and PL/SQL range of courses.

Prerequisites

A reasonable degree of computer literacy is required. No previous knowledge of SQL is required.

1. Introduction to SQL.

What is SQL and What is it Used For?
Identifying table Structures
Using the Data Dictionary

2. The SELECT Statement

Mandatory Clauses
SELECT and FROM Clauses
The WHERE Clause
Filtering data – including and excluding records
The ORDER BY Clause
Sorting operations

3. Using Functions to convert, format and summarize data.

Numeric, Character, and Miscellaneous Functions
Group Functions SUM,AVG,COUNT,STDDEV
GROUP BY and HAVING Clauses

4. Joining Tables.

Standard Table Joins
Cartesian Products
Inner and Outer Joins
Self Referencing Table Joins
ANSI compliant statements

5. Basic Sub-queries.

Queries within Queries
Basic Sub Queries correlated and uncorrelated
EXISTS and NOT EXISTS Clauses

6. Data Manipulation

Inserting Data Into Tables
Updating Data
Deleting Data

7. Creating Simple Scripts and Saving Output.

Saving your Queries
Generating SQL from SQL
Spooling Output
Substitution Variables.
Lexical and Bind variables

8. Report Formatting.

SQLPLUS environment settings
Page Settings
Page Titles
Page Numbering

9. Users, Privileges and Synonyms and Security.

Changing your password
Understanding Oracle data security.

10. able Locking.

Commit and Rollback
Table and Row Level Locking
Assigning your own Locking Level

11. SQL*Plus Performance Tuning, using Explain Plan

Basic Performance Tuning
Table and Row Level Locking
Assigning your own Locking Level

12. Export Report Using SQL Developer**

Private Courses

We can arrange your own private Oracle course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

Delivery Options:

At Your Offices

Virtual Online

Training Centres

What Our Clients Think

Very good introduction. Well paced and suited a range of experience levels.

Felicity Howdle - Health Education England

This has been by far one of the most useful and well planned/executed training courses I have ever attended. For this to have been achieved remotely just adds to how impressive it was managed.

Trevor Stratton - Lincolnshire County Council

Very good course. I've been using the software constantly in the last three months and still learnt a lot.

George Martin - NHS North of England

This course was excellent and I am delighted with how much I have achieved. The trainer was very friendly and approachable.

Rosie Heath - Licensed Trade Charity

Trainer was very engaging, spent time explaining topics clearly.

Laura Choake - Desoutter Industrial Tools

Very clear instruction, pace was kept moving, great snippets of advice given.

Robert Montgomery - Liberty Aluminium Technologies

Oracle SQL Part 2: Creating and Maintaining objects in SQL and SQL*Plus