Oracle Introduction for Experienced SQL Users
Course Outline
 
 

Oracle Introduction for Experienced SQL Users

Duration: 2 days

Course Code: OIEU

Taster Sessions

Course Overview

S7

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 10g, 11g and 12c.

The delegate will learn and acquire skills as follows:

  • 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

Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.


 

Course Contents

Oracle Introduction for Experienced SQL Users Training Course

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

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


Oracle Introduction for Experienced SQL Users

Duration: 2 days
RRP: £895.00 exc. VAT 

Course Code: OIEU

Course Dates

Upcoming Scheduled Events - next 12 months

Location Start Date Spaces Book
London 08 Nov 2018 Spaces StayAhead - Course Running Book
London 14 Feb 2019 Spaces StayAhead - Course Running Book
London 25 Apr 2019 Spaces StayAhead - Course Running Book
London 11 Jul 2019 Spaces StayAhead - Course Running Book
Virtual Events StayAhead Virtual Courses available You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.
 
 

Course Reviews

As a novice to SQL I found the training very informative. Interesting speaker, very patient.

Christine - Customer Service - Academic


We enjoyed the course and the instructor was very helpful to us .The documents were organized well.

Saleh Sulaiman - ORACLE SYSTEM APPLICATION DEVELOPER - Defence


This was a very enlightening course. Although having worked with SQL before, and knowing quite a lot of oracle SQL there were still a few things I had no knowledge of. This course has equipped me with far more knowledge than I had before.

Faizan - Junior Application Developer - Government


More Course Reviews....

Very good training which fulfilled my expectations. Very good documentation as well.

Cyril - Developer


 
 
 
 

 
Home Let Us Call You Enquiry
 

 

Course Deliveries

Public Scheduled and Closed
Virtual
UK and Overseas

OUG

Oracle User Group - Membership Benefits

OUG

Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

StayAhead
Flexibility

Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!




Our Course Curriculum

 
 
 
 
 



Our Ratings


+44 (0)20 7600 6116
Copyright © 2018 StayAhead Training Ltd
Cookies   /   Privacy Policy
sales@stayahead.com