Oracle Introduction for Experienced SQL Users

Oracle Introduction for Experienced SQL Users

2 days @ £795.00 exc. VAT 

Course Code: OIEU

25 Years - The IT Training specialist

Upcoming Scheduled Events - next 12 months

Location Start Date Spaces Book
London 18 Dec 2017 Spaces StayAhead - Course Running Book
London 05 Mar 2018 Spaces StayAhead - Course Running Book
London 24 May 2018 Spaces StayAhead - Course Running Book
London 13 Aug 2018 Spaces StayAhead - Course Running Book

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.

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 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
Home Let Us Call You Enquiry

Place A booking





Print Friendly



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




Book further course dates
StayAhead Locations

If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or sales@stayahead.com to enquire if we can accommodate your venue requirements.


Quick Search...


New Search
Enquiry
StayAhead Promo 3


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

Course Certification

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

Programming, Java, Web Dev, SQL, NoSQL, MySQL & MariaDB

Linux, Red Hat, Oracle Linux, SUSE & LPI

UNIX, Solaris, AIX & HP-UX

UNIX 
AIX 
HP-UX 

GDPR, Business Analysis, ITIL & Prince2

See what our clients say . . .

Having previously undertaken a similar course in the past I expected this course to not be especially beneficial, however this was not the case at all. I have garnered some very useful new skills and knowledge. The trainer's subject knowledge and delivery are a credit to himself and Stayahead. I was constantly engaged and rarely found myself requiring a repeat of the coursework but when needed he was more than helpful in explaining where I was struggling.

Laurence - Operations Support - Finance - September 2017

More Reviews

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