Oracle Introduction for Experienced SQL Users

RSM Technology

Course

In London

£ 725 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Duration

    2 Days

By the end of this course, the delegate will be able to: Use SQL*Plus and SQL Developer effectively, Write SQL statements to query an Oracle Database, Create and run SQL script files, Use Oracle's numeric, character and date functions, Implement Oracle's enhanced grouping functions, Create and alter tables, indexes and views, Insert, update, merge and delete rows, Grant and. Suitable for: This course is designed for experienced SQL users who need to access and work with an Oracle Database.  This course is suitable for users of versions 9i, 10g and 11g.

Facilities

Location

Start date

London
See map

Start date

On request

About this course

Practical experience of using SQL with another relational database 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

Subjects

  • SQL

Course programme

Delegates:
This course is designed for experienced SQL users who need to access and work with an Oracle Database. This course is suitable for users of versions 9i, 10g and 11g.
Objectives:
By the end of this course, the delegate will be able to:
  • Use SQL*Plus and SQL Developer effectively
  • Write SQL statements to query an Oracle Database
  • Create and run SQL script files
  • Use Oracle's numeric, character and date functions
  • Implement Oracle's enhanced grouping functions
  • Create and alter tables, indexes and views
  • Insert, update, merge and delete rows
  • Grant and revoke access privileges
  • Access the Data Dictionary
Topics Covered:
  • Overview of Oracle Database features
  • Using SQL*Plus and SQL Developer
  • Querying the Oracle Database
  • Subqueries and in-line views
  • Numeric functions
  • Character functions
  • Common date and timestamp functions
  • Actual and hypothetical data ranking
  • Decoding data
  • Enhanced grouping features
  • Tables, indexes, views and sequences
  • External and temporary tables
  • Data manipulation and transaction control
  • Access control
  • The Data Dictionary
Requirements:
Practical experience of using SQL with another relational database is required.

See related categories

Oracle Introduction for Experienced SQL Users

£ 725 + VAT

The best Oracle courses

See all

See all