The information covered in this series helps you get started on the Oracle Certified Database Administrator and/or Certified Application Developer tracks.
Another important goal of this series is to enable you
- to create advanced SQL queries,
- write intermediate PL/SQL blocks, and
- familiarize you with Oracle's unique SQL extensions.
This course covers extensions to SQL.
This means that the course is especially designed to show you how to use Oracle's own SQL extensions within queries and other SQL commands.
By the end of this course, you will know how to:
Use advanced SQL query structures such as correlated sub-queries
Use Oracle's extensions to SQL
Write SQL to create Oracle tables, views, and indexes and the parameters used to create those structures in Oracle
Use SQL to modify or remove existing table structures and constraints
Write SQL to add, change, or delete rows in tables
Use SQL*Plus (Oracle's SQL programming environment) to create SQL command files, including commands to set titles, page
breaks, and customized column headings for your queries
In this course, you will learn and practice SQL skills with many kinds of applets, including Tooltips, SlideShow, and simulations.
Extensions for SQL is the first of three courses in the Introduction to Oracle Certification Series.
In the next lesson, you will learn about prerequisites to this course.