Oracle SQL Extended

Duration: 
1 days
Codes: 
SQL

Overview

This course is highly interactive and consists of theory coupled with plenty of practical sessions. It will introduce delegates to the creation, security and maintenance of objects in an Oracle database.

Together with Oracle SQL, this course provides the perfect prerequisite knowledge to embark on training for Oracle PL/SQL Programming, or administrative roles such as Oracle Database Administration.

On completion of the course delegates will be able to:

  • Create and maintain a range of database objects
  • Control access to those objects for different users and roles
  • Identify the appropriate objects for use with particular aspects of query design

Audience

This course is aimed at those already experienced with SQL for data retrieval. It covers the use and maintenance of other database objects and facilities and how this enhances the running and construction of SQL scripts.

This course is suitable for all recent versions of Oracle, up to and including 12c.

Prerequisites

Delegates should have a good basic understanding of Oracle SQL. Previous attendance of our Oracle SQL course is highly recommended.

Course Outline

  • Database Definition
  • Tables
  • Table constraints
  • Temporary tables
  • External tables
  • Different types of indexes
  • Index only tables
  • Partitioned tables
  • Clusters
  • Views
  • Synonyms
  • Sequences
  • Oracle Data Dictionary
  • Data dictionary view categories
  • Data dictionary view relationships
  • Data dictionary usage
  • Oracle Security Facilities
  • System privileges
  • Object privileges
  • Access control for users and roles

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Somerset Bath1 400 £400 2019-11-08