Homepage › IT, Computing, Telecommunications Courses › Database Administration Courses › Oracle Courses

Introduction to Oracle 9i/10g Programming (SQL PLUS & SQL)

in PTR Associates Ltd (England)

Classes Course

Place:

Wokingham

Price:

£725 + VAT

Duration:

2 Days

Start:

30/11/2008 calendar
See course programme

Requirements:

A good knowledge of computing principles, no formal programming experience necessary.

Course objectives:

On this course, students will learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools.? The course is targetted at application developers, database administrators, system administrators and users who write applications and procedures that access an Oracle 10g database.

PTR Associates Ltd

PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company ...

Contact course provider

Request information

Contact directly and with no obligation with

PTR Associates Ltd

You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.

* Compulsory fields

*Name *Surname

*E-mail

*Country/ region *Area/ County

*I would like more information on

By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.

I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:

:| :) ;)

Average Fast Very fast

Course details

Type Course Duration 2 Days

Method / place Contact course provider Classes in Wokingham where

Course objectives On this course, students will learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools.? The course is targetted at application developers, database administrators, system administrators and users who write applications and procedures that access an Oracle 10g database.

Requirements	A good knowledge of computing principles, no formal programming experience necessary. see more

Price	£725 + VAT

Get direct information on how to enrol, venues and availability...

Oracle courses (from other course providers)

Oracle
We Teach You
Distance - £50 + VAT

Oracle Series
Sales 101 Ltd
Online - £75 + VAT

Compare the selected courses

+ oracle Courses + Oracle Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

Introduction to Oracle 9i/10g Programming (SQL PLUS & SQL)

Relational Database and SQL Overview

Review of Relational Database Terminology

Relational Database Management Systems

Introduction to SQL

Oracle Versioning and History

Logical and Physical Storage Structures

Connecting to a SQL Database

Datatypes

Sample Database
Using Oracle SQL PLUS

SQL PLUS

The SQL Buffer

Buffer Manipulation Commands

Running SQL PLUS Scripts

Tailoring Your SQL PLUS Environment

Viewing Table Characteristics

SQL PLUS Substitution Variables

Interactive SQL PLUS Scripts

Using iSQL PLUS
SQL Queries - The SELECT Statement

The SELECT Statement

The CASE...WHEN Statement

Choosing Rows with the WHERE Clause

NULL Values

Compound Expressions

IN and BETWEEN

The LIKE Operator

Creating Some Order
Scalar Functions

SQL Functions

Using SQL Functions

String Functions

Numeric Functions

Date Functions

Conversion Functions

Date Formats

Oracle Pseudocolumns
SQL Queries - Joins

Selecting from Multiple Tables

Joining Tables

Self Joins

Outer Joins

Types of Outer Joins
Aggregate Functions and Advanced Techniques

Subqueries

Correlated Subqueries

The EXISTS Operator

The Aggregate Functions

Grouping Rows

Combining SELECT Statements
Data Manipulation and Transactions

The INSERT Statement

The UPDATE Statement

The DELETE Statement

Transaction Management

Concurrency

Explicit Locking

Data Inconsistencies

Loading Tables From External Sources
Data Definition and Control Statements

Standard Datatypes

Defining Tables

Constraints

Inline Constraints

Modifying Table Definitions

Deleting a Table Definition

Controlling Access to Your Tables
Other Database Objects

Views

Creating Views

Updatable Views

Sequences

SynonymsAppendix A - The Data Dictionary

Introducing the Data Dictionary

DBA, ALL, and USER Data Dictionary Views

Some Useful Data Dictionary Queries

see the full course programme

on request

get more information on the programme directly from PTR Associates Ltd.

Request information for free

Get direct information on how to enrol, venues and availability...

Venues and dates


Where	Wokingham, 21a Peach Street see map
When	Start: 30/11/2008 Finish: 01/12/2008 See calendar

Get direct information on how to enrol, venues and availability...

Ex-students

Opinions

Have you attended this course?

Voice your opinion and help thousands of other users

Get direct information on how to enrol, venues and availability...

On PTR Associates Ltd

Provider description

PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.

Advantages of studying with PTR Associates Ltd

Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment Lecturer Expertise - vendor certified with real-world product experience

Course provider history

PTR Associates Ltd was established in 1989.

Specialises in

Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

All courses

by PTR Associates Ltd on emagister.

See list of courses

Get direct information on how to enrol, venues and availability...

Most searched for in Oracle

Introduction to Oracle 9i/10g Programming (SQL PLUS & SQL)

in PTR Associates Ltd (England)

PTR Associates Ltd

Request information

Availability?How do I enrol?Where can I get more information?

Course details

Oracle courses (from other course providers)

Course programme

Introduction to Oracle 9i/10g Programming (SQL PLUS & SQL)

on request

Venues and dates

Ex-students

Opinions

On PTR Associates Ltd

Provider description

Advantages of studying with PTR Associates Ltd

Course provider history

Specialises in

All courses

Most searched for in Oracle

Information related to Oracle

Availability?
How do I enrol?
Where can I get more information?