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.

Audience >
Skills Gained >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-25 out of 78
Location
Duration
Start Date
Price
LVC, Australia
5 Days
9th Aug 2021
$6250
LVC, France
5 Days
9th Aug 2021
€3500
LVC, Germany
5 Days
9th Aug 2021
€3500
LVC, Australia
5 Days
9th Aug 2021
$6250
LVC, Australia
5 Days
9th Aug 2021
$6250
LVC, New Zealand
5 Days
9th Aug 2021
$6250
LVC, New Zealand
5 Days
9th Aug 2021
$6250
LVC, United States
5 Days
9th Aug 2021
$4500
LVC, United States
5 Days
9th Aug 2021
$4500
LVC, Italy
5 Days
9th Aug 2021
€3500
LVC, Spain
5 Days
9th Aug 2021
€3500
LVC, United States
5 Days
9th Aug 2021
$4500
LVC, United Kingdom
5 Days
9th Aug 2021
£3000
London, United Kingdom
5 Days
16th Aug 2021
£3000
Melbourne, Australia
5 Days
6th Sep 2021
$6250
Auckland, New Zealand
5 Days
6th Sep 2021
$6250
Sydney, Australia
5 Days
6th Sep 2021
$6250
Wellington, New Zealand
5 Days
6th Sep 2021
$6250
Madrid, Spain
5 Days
6th Sep 2021
€3500
Milan, Italy
5 Days
6th Sep 2021
€3500
Berlin, Germany
5 Days
6th Sep 2021
€3500
Chicago, United States
5 Days
6th Sep 2021
$4500
New York, United States
5 Days
7th Sep 2021
$4500
Paris, France
5 Days
7th Sep 2021
€3500
LVC, United Kingdom
5 Days
7th Sep 2021
£3000

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