hrs Specialised Training to meet your needs

Home Up The Team Public Courses Customised Consultancy

sql

                         

Introduction to SQL

Assumptions and pre-requisites

Delegates should have some experience of programming

Course Outline

What is Oracle?

  • Relational Database concepts
  • Entity Relationship modelling
  • SQL is an interface language
  • Client/Server and n-tier configuration
  • Development environments

Using SQL*Plus

  • Editing
  • Using files
  • Bind Variables
  • Spooling the results
  • DESCRIBE

Basic SELECT statement

  • columns
  • tables
  • aliases
  • WHERE clause
  • ORDER BY clause

Joins

  • Oracle joins
  • ANSI joins

Basic Functions

  • Data Conversion
    • Basic datatypes
    • to_char, to_date, to_number
  • String functions
    • e.g. substr and concatenation
  • Conditional functions
    • DECODE
    • CASE
  • Dealing with NULLs
  • Aggregate functions

GROUP BY and HAVING

Subqueries

Transactions

  • How they work
  • INSERT
  • Using sequences
  • Using returning
  • UPDATE
  • DELETE
  • COMMIT and ROLLBACK

Creating Tables

Basic Data Integrity

  • Primary Key
  • Foreign Key
  • Introduction to indexes

Using Views

Acessing tables not owned by yourself

  • Privileges
  • Synonyms
[RETURN TO LIST OF COURSES]

 

[Home] 

Send mail to pleasering@oracle-training.co.uk with questions or comments about this web site.
Copyright © 2003 hrs
Last modified: February 11, 2003