Course Description

The Oracle Database: SQL Workshop II Ed 2 course will help you enhance your skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. You also learn to write more efficient queries using the functions supporting the timezone and regular expressions.

Learn to:

• Grant and revoke privileges and roles

• Manage schema objects and data dictionary views

• Write efficient and complex subqueries

• Use the in-built functions supporting the usage of regular expressions and time zone

Benefits to you:

This course is designed for application developers with basic SQL language skills. You learn how to use the advanced features of SQL in order to query and manipulate data within the database. You will also learn how to control privileges at the object and system level. Advanced querying and reporting techniques are explained. You will learn to use the regular expression support in SQL. You benefit by using Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is introduced as an optional tool. Demonstrations and hands-on practice reinforce the concepts.


Enroll Now - Select a section to enroll in

8:00AM to 1:00PM
Apr 04, 2020 to Jun 20, 2020
Schedule and Location
Contact Hours
Course Fee(s)
Hon CC non-credit $2,695.00
Section Notes

No meetings on April 11, May 16, 23, and 30. Certification exam is not included in this course.


Required fields are indicated by .