HOME
 

Oracle Introduction for Experienced SQL Users

StayAhead Training
Course summary
2 days
895 GBP excl. VAT
London
Professional Training

Course description

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.

Versions supported 11gR2, 12cR2, 18c, 19c.

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
  • Oracle PL/SQL
  • Oracle Database 12cR2 Administration
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.
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

Expenses

£895.00

Continuing Studies

Follow on courses: Oracle PL/SQL, Oracle Database 12cR2 Administration

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

About provider

StayAhead Training: Linux, Oracle, SQL, Professional IT Courses

Live Virtual Training with our live Course Instructor is offered for all our courses.  Take the course from the comfort of your office, home or any location of your choice, nationally and internationally.  Public schedule and Closed Company courses.  Flexibility...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Oracle Introduction for Experienced SQL Users.

  Contact the provider

  Get more information

  Register your interest

Contact info

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

 Show phone number
www.stayahead.com

Reviews

Average rating 5

Based on 4 reviews

Christine
(5)
As a novice to SQL I found the training very informative. Interesting speaker, very patient.
Saleh Sulaiman
(5)
We enjoyed the course and the instructor was very helpful to us .The documents were organized well.
Faizan
(5)
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.
Request information

Find out more about this Oracle Introduction for Experienced SQL Users course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here