database_development_courses

Oracle Database: SQL Certified Expert

The Oracle Database: SQL Certified Expert certification validates your expertise in working with SQL.

This Skillsoft course will train you in everything you need to know to pass the exam for the Oracle Database SQL Expert certification. You'll need to sit this exam separately.


Ready to start?

Price: $1,250 AUD

At a glance

Study mode

laptop
Online

Provider

Skillsoft
Career Opportunities
Recognition

Globally recognised

Prerequisites

None

Location

Online

Course length
6 weeks
Study mode

Online


Online

Study from anywhere, when it suits you best and graduate with the identical qualification as an on-campus student.

Blended

Study part of the course online. Combine your online learning with classes or practical sessions on-campus at a college or university.

In-class

Attend classes on-campus at a university, TAFE or college and interact face-to-face with teachers and fellow students.

Assessment
Oracle exam 1Z0-047 (by external provider)
Start date

Enrol anytime.

Provider
Skillsoft

Skillsoft is the premier global provider of online IT and project management certification training courses.

If you want to be an expert of a particular software package or project management practice, a Skillsoft course will prepare you completely for the certification exam.

The certifications include Microsoft, Cisco, Oracle, Six Sigma, PRINCE2 and more.

Skillsoft's award-winning training method combines affordable computer-based training with the personal attention of instructor-led training.

Read more about
Skillsoft

What you'll learn

You'll learn how to:

  • Use the advanced features of SQL to query and manipulate data within the database
  • Control privileges at the object and system level
  • Use advanced querying and reporting techniques
  • Manipulate large data sets
  • Manage data in different time zones
  • Control access and privileges for schema objects

Course structure

8 units

  • Using SQL to query your database
  • Conversion functions, group functions and joins
  • Subqueries, set operators and data manipulation
  • Using DDL, views, sequences, indexes and synonyms
  • Controlling user access and managing schema objects
  • Data dictionary views and large data sets
  • Managing data in different time zones
  • Using subqueries and regular expressions

Skillsoft's Oracle certification training will fully prepare you for the Oracle exam 1Z0-047.

Please note that the Oracle exam is held by an external provider.

Recognition

Certification is awarded by Oracle and is globally recognised.

Ready to start?

  • Enrol in a few steps
  • Receive access to the course by email
  • Support is available as you study

Price: $1,250 AUD