Course

In Manchester, London, Birmingham and 3 other venues

£ 995 + VAT

Description

  • Duration

    3 Days

By the end of this course, the delegate will be able to; describe the basic structure of a relational database, use the command line features of SQL*Plus, use SQL Developer to access an Oracle Database, create SQL statements to select data from an Oracle Database and yse SQL run time parameters. Delegates will also be able to use aggregate functions, use numeric, character, date, conversion and miscellaneous functions, use subqueries, create and alter tables, indexes and views, create.

Facilities

Location

Start date

Birmingham (West Midlands)
Spring House, 3010 The Crescent, Solihull Parkway, Birmingham Business Park Birmingham, B37 7YE

Start date

On request
Bristol (Avon)

Start date

On request
Edinburgh (Midlothian/Edinburghshire)

Start date

On request
Leeds (West Yorkshire)

Start date

On request
London
See map
3-5 Crutched Friars, EC3N 2HR

Start date

On request
Manchester (Greater Manchester)

Start date

On request
See all (6)

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

Course programme

By the end of this course, the delegate will be able to; describe the basic structure of a relational database, use the command line features of SQL*Plus, use SQL Developer to access an Oracle Database, create SQL statements to select data from an Oracle Database and yse SQL run time parameters. Delegates will also be able to 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 and use the Data Dictionary.Note: Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience. Course content
  • The Structure of a Relational Database
  • UsingSQL*Plus
  • UsingSQLDeveloper
  • The BasicSQLSelect Statement
  • Selecting Data from Multiple Tables
  • Inner Joins, Outer Joins and Self Joins
  • Grouping and Sorting Output
  • Sub-queries and In-line Views
  • Character, Date and Numeric Functions
  • SQL*Plus Run-time Parameters and Variables
  • Creating and Changing Tables and Views
  • Constraints and Indexes
  • Inserting, Updating and Deleting Data
  • Basic Transaction Control
  • Controlling Access to the Database
  • Related Data Dictionary Tables and Views

Oracle SQL

£ 995 + VAT