Oracle SQL Extended

Oracle SQL Extended

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 including 12c, 18c, and 19c.

Prerequisites

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

Duration

1 day. Hands on.

NOTE: This course may be combined with Oracle SQL and run over a total of four days, please contact us for more information.

Course Objectives

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

Course Content

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

Virtual Courses

ALL of our courses can be delivered virtually. And our Bath public schedule of courses are now available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

Public Courses

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...