Oracle Fundamentals

Course

In London, Bristol, Edinburgh and 3 other venues

£ 1,695 VAT inc.

Description

  • Class hours

    35h

  • Duration

    5 Days

By the end of this course, the delegate will be able to: Select data from an Oracle Database using SQL*Plus and SQL Developer Create SQL statements to select data from an Oracle Database Use SQL run time parameters Use aggregate functions Use numeric, character, date, conversion and miscellaneous functions Use subqueries Create and alter tables, indexes and views Create. Suitable for: This course is designed primarily for administrators, developers and support personnel who need to access and work with an Oracle Database.

Facilities

Location

Start date

Birmingham (West Midlands)
See map
C/O Netcom Training Solutions, 6th Floor, Quay Side Tower, Broad Street, Birmingham B1 2hf, B5 4UA

Start date

On request
Bristol (Avon)
See map
C/O Computerworld, Apex House, Westerleigh Business Park, Turner Drive, Yate, BS37 5YX

Start date

On request
Edinburgh (Midlothian/Edinburghshire)
See map
16 St Mary'S Street, EH1 1SU

Start date

On request
Leeds (West Midlands)
See map
Halsbury House, Chancellor Court, 21 The Calls, LS2 7EH

Start date

On request
London
See map
6 Long Lane, Barbican, EC1A 9HF

Start date

On request
Manchester (Greater Manchester)
See map
C/O Yses, St James Court, 30 Brown Street, M2 1DH

Start date

On request
See all (6)

About this course

An understanding of IT.  Some practical programming experience would prove advantageous.

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

  • Using PL/SQL Index-By table built-in functions

Course programme

Delegates:

This course is designed primarily for administrators, developers and support personnel who need to access and work with an Oracle Database.

Objectives:


By the end of this course, the delegate will be able to:
  • Select data from an Oracle Database using SQL*Plus and SQL Developer
  • Create SQL statements to select data from an Oracle Database
  • Use SQL run time parameters
  • Use aggregate functions
  • Use numeric, character, date, conversion and miscellaneous functions
  • Use subqueries
  • Create and alter tables, indexes and views
  • Create, update and delete records
  • Manage sequences and synonymns
  • Access the Data Dictionary
  • Describe the Basic Structure of a PL/SQL Block
  • Use PL/SQL IF Statements, Expressions and LOOP Constructs
  • Declare and use Cursors
  • Use record types and PL/SQL Tables
  • Handle Errors and Exceptions within PL/SQL Scripts


Note:

Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.

Topics Covered:


  • The Structure of a Relational Database
  • Using SQL*Plus and SQL Developer
  • The Basic SQL Select Statement
  • Selecting Data from Multiple Tables
  • Grouping and Sorting Output
  • Character, Date and Numeric Functions
  • SQL*Plus Run-time Parameters and Variables
  • Creating and Changing Tables, Indexes and Views
  • Inserting, Updating and Deleting Data
  • Related Data Dictionary Tables and Views
  • The Structure of a PL/SQL Block
  • Declaring and Using Variables and Constants
  • Using SQL Statements in PL/SQL
  • PL/SQL Programming Constructs
  • Declaring and Using Cursors
  • Exceptions and Error Handling
  • Record Types and PL/SQL Tables

Requirements:

An understanding of IT. Some practical programming experience would prove advantageous.

Oracle Fundamentals

£ 1,695 VAT inc.