Oracle SQL

Verhoef Training Ltd.

Short course

In Bath

£ 1,300 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Short course

  • Level

    Intermediate

  • Location

    Bath

  • Duration

    3 Days

This course introduces delegates to the concepts of relational databases and provides an in-depth look at SQL in order to retrieve and manipulate data from an Oracle database.

Facilities

Location

Start date

Bath (Somerset)
See map
11 Kingsmead Square, BA1 2AB

Start date

On request

About this course

Utilise the SQL language to retrieve data from an Oracle database

Use the SQL Developer tool

Edit, store and recall queries, format results, and create standard queries and reports

This course is perfect for those who wish to gain a comprehensive understanding of how the Oracle Structured Query Language (SQL) is used for data retrieval and reporting.

Delegates should be computer literate with a good knowledge of the standard editor available on their target hardware platform.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • SQL
  • Oracle
  • Database
  • Data
  • Data Management
  • Oracle SQL
  • Structured Query Language
  • Relational Database
  • Tables
  • Querying

Teachers and trainers (1)

Parnel Gomez

Parnel Gomez

Verhoef Trainer

Course programme

Relational database theory
Overview of oracle
ISO (incorporating ANSI and BSI) standards
Oracle architecture
Oracle background processes
SQL Developer
Filtering by rows and columns
Filtering for distinct or unique values
Use of the Between, Like & In operators
Handling Null values
Filtering with a compound Where clause
Sorting results
Perform a calculation
Use of column alias
Deriving values
Data types
Substitution variables
Inner joins (Pre and Post SQL99)
Outer joins (Pre and Post SQL99)
Combining inner and outer joins
Conversion functions
Date functions
Character functions
Numeric functions
Aggregate Summary functions
Group By clause
Having.clause
Nested sub-queries
Multi-column sub-queries
Correlated sub-queries
Exists clause
Inline views
Case statement examples
Decode vs. Case
Union
Intersect
Minus
Insert records
Insert via a Select clause
Multi-table inserts
Update records
Delete records
Transactions
Locking
Introduction To Analytic Functions
Cube, rollup & grouping
Partitioned outer join
Analytic Summary Functions
Hierarchical queries
Overview Of Explain Plan Facility
Overview of Indexes

See related categories

Oracle SQL

£ 1,300 + VAT

The best Oracle courses

See all

See all