All Brands   >   Oracle   >   Oracle Database Introduction to SQL

CMDBID: 105242 | Course Code: OC12CISQL SQL | Duration: 5 Days
Overview >

This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Learn To:

  • Understand the basic concepts of relational databases ensure refined code by developers.
  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML).
  • Control database access to specific objects.
  • Manage schema objects.
  • Manage objects with data dictionary views.
  • Retrieve row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.
  • Create and query external tables.

Benefits to You:

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Learn Advanced Features of SQL:

This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered.

Use Development Tools:

The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g and 11g audience.

Please note: This course is a combination of Oracle Database: SQL Workshop I and Oracle Database: SQL Workshop II courses.

Skills >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-25 out of 41
Location
Start Date
Price
London, United Kingdom
12th Oct 2020
£2678
Manchester, United Kingdom
12th Oct 2020
£2678
LVC, Australia
12th Oct 2020
$6500
LVC, Australia
12th Oct 2020
$6500
LVC, Australia
12th Oct 2020
$6500
LVC, United States
19th Oct 2020
$4500
LVC, United Kingdom
19th Oct 2020
£2678
LVC, New Zealand
19th Oct 2020
$6500
LVC, Germany
19th Oct 2020
€4000
LVC, France
19th Oct 2020
€4000
LVC, Italy
19th Oct 2020
€4000
LVC, Spain
19th Oct 2020
€4000
LVC, United States
19th Oct 2020
$4500
LVC, New Zealand
19th Oct 2020
$6500
LVC, United States
19th Oct 2020
$4500
New York, United States
9th Nov 2020
$4500
Auckland, New Zealand
9th Nov 2020
$6500
Wellington, New Zealand
9th Nov 2020
$6500
Chicago, United States
9th Nov 2020
$4500
San Francisco, United States
9th Nov 2020
$4500
Paris, France
9th Nov 2020
€4000
Berlin, Germany
9th Nov 2020
€4000
Madrid, Spain
9th Nov 2020
€4000
Milan, Italy
9th Nov 2020
€4000
LVC, Australia
16th Nov 2020
$6500

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. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

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.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes