www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

Introduction to Oracle SQL Training Course UK

Dates and full course list

Introduction to Oracle SQL Course Overview

Course Code:	ORC0010
Price:	£1000
Duration:	3 days
Date:
Who should attend:	The course is suitable for any personnel involved in the maintenance of Oracle applications and databases and for users with some technical knowledge who wish to extend that knowledge and for end users who wish to construct their own reports. The course is a pre-requisite for the Database Administration and PL/SQL Courses.
Prerequisite Skills:	Delegates should have a good knowledge of their operating system.

To enable the creation, manipulation, extraction of data from an Oracle database it is essential to have a thorough understanding of the SQL Language. The course takes you through creating and populating relational data structures, querying that data and using SQL*Plus as a reporting tool. The course is organised into chapters covering the course objectives in a lecture format interspersed by sets exercises designed to illustrate the points covered and are completed by the delegate.

Course Content

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

Course Objectives

1. Create and maintain Oracle tables.
2. Insert, update, delete data from Oracle tables.
3. Produce complex queries.
4. Format queries in to Reports.

Oracle 9i Intro to SQL Training Course Outline

Introduction to SQL.

What is SQL and what is it used for?

Data Dictionary

Using the Data Dictionary

The SELECT Statement

Mandatory Clauses
The WHERE Clause
The ORDER BY Clause

Substitution Variables

Lexical and Bind variables

Functions

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

Sub-queries

Queries within Queries
Basic Sub Queries
Complex Sub Queries
EXISTS and NOT EXISTS Clauses

Joining Tables

Cartesian Products
Standard Table Joins
Self Referencing Table Joins
Inner and Outer Joins

Report Formatting

Page Settings
Page Titles
Page Numbering

Views

Creating Views
Restricting Data Access with Views
Simplifying Database Design

Users, Privileges and Synonyms, Security

Changing your password
Allowing Other Users Access to Your Tables

Data Manipulation

Inserting Data Into Tables
Updating Data
Deleting Data

Table Locking

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

Nested functions

Advanced SQL*Plus Techniques

Generating SQL from SQL
Spooling Output
Copying Tables

SQL*Plus Performance Tuning, using Explain Plan

Basic Performance Tuning
Performance Information using Explain Plan Utility

Associated Courses

Oracle 9i Intro to PL/SQL
Oracle 9i DBA
Oracle 9i New Features
Oracle 9i Performance Tuning