SQL Extensions  «Prev  Next»

Lesson 1

Oracle SQL Extensions

Welcome to the first course in the Introduction to Oracle Certification Series, Extensions for SQL. As the name implies, this series focuses on preparing you for certification in Oracle.

What is this series about?

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
  1. to create advanced SQL queries,
  2. write intermediate PL/SQL blocks, and
  3. familiarize you with Oracle's unique SQL extensions.

Course goals

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:
  1. Use advanced SQL query structures such as correlated sub-queries
  2. Use Oracle's extensions to SQL
  3. Write SQL to create Oracle tables, views, and indexes and the parameters used to create those structures in Oracle
  4. Use SQL to modify or remove existing table structures and constraints
  5. Write SQL to add, change, or delete rows in tables
  6. 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

The series

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.