Oracle SQL

Course

In Swansea

£ 995 + VAT

Description

  • Type

    Course

  • Location

    Swansea (Wales)

  • Duration

    3 Days

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. 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. Use the Data Dictionary. Suitable for anyone who needs to access and work with an Oracle Database.

Facilities

Location

Start date

Swansea
See map
Ground Floor, Sun Alliance House, 166-167 St Helens Road, SA1 4DQ

Start date

On request

About this course

An understanding of IT is required.

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

Computeraid is the largest supplier independent computer training and consultancy company in South Wales, training around 20,000 people days annually. Computeraid is supplier-independent so does not sell hardware or software. As well as training thousands of staff from hundreds of smaller companies Computeraid also works with many of the largest organisations in the region. References from all sources are excellent. We offer a range of commercial training options, funded courses and subsidised consultancy. With training centres in Swansea, Cardiff, Neath and Carmarthen we are within easy reach of businesses throughout South Wales.

Company History

Computeraid was founded in 1988 and celebrated its 10th anniversary year by being awarded the Western Mail "Welsh Small Business of the Year" award. Our qualified and dedicated tutors have provided training solutions for thousands of businesses over the last twenty years.

Computeraid is an Investors in People organisation.

Course Objectives

• 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
• 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
• Use the Data Dictionary

Course Contents

  • The Structure of a Relational Database
  • Using SQL*Plus
  • Using SQL Developer
  • The Basic SQL Select 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

Course Details

This is a three-day course running from 9:30 am - 4:30 pm.
Courses run in Cardiff.

Prerequisites

An understanding of IT is required.

What Next?

Oracle PL / SQL
This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.

Oracle SQL

£ 995 + VAT