Advanced SQL

Catalog description

This course provides students with advanced SQL skills that allow them to write effective queries against single and multiple tables; manipulate data in tables; create database schema objects; create indices and constraints; alter existing schema objects; create and query external tables; and learn to use the advanced features of SQL in order to query and manipulate data within the database. Students also learn to control privileges at the object and system level and will be able to work with date-time functions available in the Oracle Database. In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus will be introduced as an optional development tool. This course is one of three Oracle certification training courses.