Oracle SQL - Oracle Training

The Knowledge Academy

Course

In Cardiff

£ 1,495 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Course

  • Location

    Cardiff (Wales)

  • Duration

    3 Days

  • Start date

    Different dates available

The Knowledge Academy Oracle SQL 3 day course covers the following topics:

Our Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL

Facilities

Location

Start date

Cardiff
See map
Castle Street, CF10 1SZ

Start date

Different dates availableEnrolment now open

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

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Subjects

  • Writing
  • IT
  • Database
  • SQL
  • Database training
  • MySQL
  • Data Collection
  • Database Design
  • Tables
  • Query

Course programme

Pre-requisites

There are no pre-requisites for this course, although an understanding of databases would be beneficial.

Who is this course for?

Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database.

What will I Learn?

  • Creating SQL statements to query database tables
  • Using standard aggregate functions and related SELECT statement clauses
  • Implementing extended SQL functions
  • Joining Tables
  • Using subqueries
  • Creating and altering tables and views
  • Inserting, updating and deleting rows in database tables

Course Outline

  • Relational database concepts
  • Using SQL*plus
  • Using SQL developer
  • Retrieving data with the select statement
  • Aggregate functions
  • Joining tables
  • Basic subqueries and set operators
  • Numeric, character and date functions
  • Conversion and miscellaneous functions
  • SQL parameters
  • Complex subqueries
  • Managing data
  • Managing tables
  • Managing indexes and views
  • Managing sequences and synonyms

This course covers the topics required for the Oracle exam 1Z0-051: Oracle Database 11g: SQL Fundamentals I. This course does not include this examination and needs to be purchased separately via Pearson Vue.

Additional information

Designed for enterprise grid computing, the most cost effective way to manage information. We are the largest provider of IT Technical training globally GUARANTEED LOWEST PRICE IN THE INDUSTRY Learn how to create, manage & support Oracle 11g Databases Market leader for computer hardware and enterprise software products  Improve your revenue stream by performing at a higher level Our Oracle 11g courses include course materials and exam preparation Courses delivered by world class Oracle instructors in luxury venues  

See related categories

Oracle SQL - Oracle Training

£ 1,495 + VAT

The best SQL Server courses

See all

See all