Oracle Introduction for Experienced SQL Users

2 days @ £725.00  
S6

Oracle Introduction for Experienced SQL Users Course Overview

The Oracle Introduction for Experienced SQL Users course is designed to give experienced SQL users practical experience in accessing an Oracle Database.  This course is suitable for users of versions 9i, 10g and 11g.

Skills Gained

The delegates will practise:

  • Using SQL*Plus and SQL Developer to access the database
  • Creating and running SQL script files
  • Querying the database
  • Using Oracle's numeric, character and date functions
  • Implementing Oracle's enhanced grouping features
  • Creating and altering tables, indexes and views
  • Inserting, updating, merging and deleting rows
  • Granting and revoking access privileges
  • Retrieving information from the data dictionary

Who will the Course Benefit?

Anyone with practical experience of the SQL language who needs to migrate their existing skills to Oracle.

Course Objectives

The Oracle Introduction for Experienced SQL Users course provides the skills necessary to query and update an Oracle Database using SQL*Plus and SQL Developer.

Requirements

Practical experience of using SQL with another relational database is required.

Follow-On Courses

NOTE: Course technical content is subject to change without notice.

Oracle Introduction for Experienced SQL Users Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION

  • Oracle - a brief overview
  • Users and roles
  • Object naming rules
  • Oracle datatypes
  • The data dictionary
  • Using SQL*Plus
  • Entering and executing SQL statements
  • Creating, editing and running SQL scripts
  • Using SQL Developer
  • Starting SQL Developer
  • Configuring a Connection
  • Navigation Tabs
  • SQL Worksheet

Session 2: QUERYING THE DATABASE

  • Overview of the basics
  • Traditional Oracle v. ANSI-standard table joins
  • Set operators
  • Using aggregate functions
  • Subqueries and in-line views
  • Using the WITH clause
  • Hierarchical queries

Session 3: NUMERIC AND CHARACTER FUNCTIONS

  • Using the table dual
  • Numeric functions
  • Formatting numeric output
  • Character functions and string concatenation

Session 4: DATE AND TIME FUNCTIONS

  • Default date and timestamp formats
  • Accessing the current date and time
  • Date and time arithmetic
  • Date functions
  • Formatting date and time output
  • Conversion functions

Session 5: MISCELLANEOUS FUNCTIONS

  • NVL and NVL2
  • DECODE
  • The simple CASE expression
  • The searched CASE expression

Oracle Introduction for Experienced SQL Users Training Course

Course Contents - DAY 2

Session 6: ENHANCED GROUPING FEATURES

  • The ROLLUP extension
  • The CUBE extension
  • The GROUPING function
  • The GROUPING_ID function
  • The GROUPING SETS extension

Session 7: TABLES, INDEXES AND VIEWS

  • Creating tables
  • Defining datatypes
  • Specifying constraints
  • Table, column and constraint operations
  • Recovering dropped tables
  • Temporary tables
  • External tables
  • Index-organized tables
  • Handling B-tree indexes
  • Creating and using views
  • Creating and using sequences

Session 8: MANAGING DATA

  • Inserting rows
  • Updating rows
  • Deleting rows
  • Verifying updates
  • Multi-table inserts
  • Merging rows
  • Basic transaction control

Session 9: ACCESS CONTROL

  • System privileges
  • User accounts and roles
  • Granting and revoking object privileges
  • Using synonyms

Session 10: THE DATA DICTIONARY

  • Data dictionary tables
  • Querying the data dictionary
  • Useful SQL statements

Follow-On Courses


       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking

In London




May also be run upon request at:

Centres


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

 

MOD Career Transition

Ministry Of Defense - Career Transition Partnership

 

We have created our website to the following W3C standards, this helps makes our pages easier to use for you.

Valid HTML 4.01 Transitional

Valid CSS!

If you find a non-compliant page on our site, please let us know and we will endeavour to fix it immediately.
 

Publicly Scheduled
Training Locations
London centre:
6 Long Lane
Barbican
London
EC1A 9HF
UK

telephone:
+44 (0)20 7600NoSkype 6116
Manchester centre:
St James Court
30 Brown Street
Manchester
M2 1DH
UK
Birmingham centre:
The Enterprise Suite
9th Floor Centre City Tower
5-7 Hill Street
Birmingham
B5 4UA
UK
Bristol centre:
Apex House
Westerleigh Business Park
Turner Drive
Yate
Bristol
BS37 5YX
UK
Leeds centre:
Halsbury House
Chancellor Court
21 The Calls
Leeds
LS2 7EH
UK
Edinburgh centre:
16 St Mary's Street
Edinburgh
Scotland
B3 2HJ
UK
Please contact our London office for all enquiries.

telephone:
+44 (0)20 7600NoSkype 6116

or email:

info@
stayahead.com



 

Top  |  Go back  

Print Friendly

Printer friendly version of the Oracle Introduction for Experienced SQL Users outline