By using our website you agree to our use of cookies.

Oracle Introduction for Experienced SQL Users

2 Day Course
Code OIEU

Book Now - 1 Delivery Method Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

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.

Objectives

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
View detailed Course Modules

Target Audience

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

Additional Information

  • 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.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Collapse all

Introduction (13 topics)

  • 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

Querying the Database (7 topics)

  • 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

Numeric and Character Functions (4 topics)

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

Date and Time Functions (6 topics)

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

Miscellaneous Functions (4 topics)

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

Enhanced Grouping Features (5 topics)

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

Tables, Indexes and Views (11 topics)

  • 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

Managing Data (7 topics)

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

Access Control (4 topics)

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

The Data Dictionary (3 topics)

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

Prerequisites

Experience of using SQL with another relational database is required.

Oracle Development Training Courses

Course PDF

Print

Share this Course

Share

Recommend this Course

Sections