Oracle SQL Fundamentals

StayAhead Training Ltd

Course

In London

£ 1,695 VAT inc.

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London

  • Class hours

    35h

  • Duration

    5 Days

By the end of this course, the delegate will be able to: Describe the structure of a relational database Use the command line features of SQL*Plus and SQL Developer Create SQL statements to select data from an Oracle database Use single row functions Use enhanced grouping functions Generate hierarchical queries Generate scripts Use SQL run time parameters Create and. Suitable for: This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for delegates intending to sit the following examinations:

Facilities

Location

Start date

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

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

Subjects

  • Controlling User Access to Database Objects

Course programme

Delegates:

This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for delegates intending to sit the following examinations:

Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007)
Oracle Database SQL Expert (IZ0-047)
Oracle Database 11g: SQL Fundamentals (IZ0-051)

Objectives:

By the end of this course, the delegate will be able to:
  • Describe the structure of a relational database
  • Use the command line features of SQL*Plus and SQL Developer
  • Create SQL statements to select data from an Oracle database
  • Use single row functions
  • Use enhanced grouping functions
  • Generate hierarchical queries
  • Generate scripts
  • Use SQL run time parameters
  • Create and alter tables, indexes and views
  • Use external tables
  • Create, update and delete records
  • Create users, profiles and roles
  • Grant and revoke access privileges
  • Access 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.

Topics Covered:
  • The Structure of a Relational Database
  • Using SQL*Plus and SQL Developer
  • The Basic SQL Select Statement
  • Using Oracle and ANSI-Compliant Inner and Outer Joins
  • Sub-Queries and Sub-Query Operators
  • In-line views and Top-'N' Analysis
  • Hierarchical Queries
  • Grouping and Sorting Output
  • Advanced Grouping Expressions and Functions
  • Character, Date and Numeric Functions
  • Timestamp and Interval Datatypes and Functions
  • CASE Expressions
  • Regular Expression Notation and Related Functions
  • Creating and Changing Tables and Views
  • Constraints and Indexes
  • Inserting, Updating and Deleting Data
  • Creating and Using External Tables
  • Multitable Insert Statements
  • Merge Rows in a Table
  • External Tables
  • Flashback Operations
  • Basic Transaction Control
  • Controlling Access to Objects
  • Data Dictionary Tables and Views

See related categories

Oracle SQL Fundamentals

£ 1,695 VAT inc.

The best Oracle courses

See all

See all