Putting America Back to Work, through advance industry specific education, providing the tools necessary to
hold the knowledge force in America, is our mission.

Overview

• Overview of Relational Databases, SQL and PL/SQL
• Discuss the theoretical and physical aspects of a relational database
• Describe the Oracle implementation of the RDBMS and ORDBMS
• Describe the use and benefits of PL/SQL

Basic SQL

• Writing Basic SQL Statements
• List the capabilities of SQL SELECT statements
• Execute a basic SELECT statement
• Differentiate between SQL statements and SQL*Plus commands

Sorting

• Restricting and Sorting Data
• Limit the rows retrieved by a query
• Sort the rows retrieved by a query

Single Row and Other Functions

• Single Row Functions
• Describe various types of functions available in SQL
• Use character, number, and date functions in SELECT statements
• Describe the use of conversion functions

Displaying Data and Joins

• Displaying Data from Multiple Tables
• Write SELECT statements to access data from more than one table using equality and nonequality joins
• View data that generally does not meet a join condition by using outer joins
• Join a table to itself

Grouping Data

• Aggregating Data Using Group Functions
• Identify the available group functions
• Describe the use of group functions
• Group data using the GROUP BY clause
• Include or exclude grouped rows by using the HAVING clause

Subqueries

• Subqueries
• Describe the types of problems that subqueries can solve
• Define subqueries
• List the types of subqueries
• Write single-row and multiple-row subqueries

Multi-Column Subqueries

• Multiple-Column Subqueries
• Write multiple-column subqueries
• Describe and explain the behavior of subqueries when null values are retrieved
• Write subqueries in a FROM clause

SQL*PLUS

• Producing Readable Output with SQL*Plus
• Produce queries that require an input variable
• Customize the SQL*Plus environment
• Produce more readable output
• Create and execute script files
• Save customizations

DML

• Manipulating Data
• Describe each DML statement
• Insert rows into a table
• Update rows in a table
• Delete rows from a table
• Control transactions

TABLES

• Creating and Managing Tables
• Describe the main database objects
• Create tables
• Describe the datatypes that can be used when specifying column definition
• Alter table definitions
• Drop, rename, and truncate tables

Constraints

• Including Constraints
• Describe constraints
• Create and maintain constraints

Views

• Creating Views
• Describe a view
• Create, alter the definition, and drop a view
• Retrieve data through a view
• Insert, update, and delete data through a view
• Create and use an inline view
• Perform Top ‘N’ Analysis

Data Dictionary

• Oracle Data Dictionary
• Describe the data dictionary views a user may access
• Query data from the data dictionary

Database Objects

• Other Database Objects
• Describe database objects and their uses
• Create, maintain, and use sequences
• Create and maintain indexes
• Create private and public synonyms
• Controlling User Access
• Create users
• Create roles to ease setup and maintenance of the security model
• Use the GRANT and REVOKE statements to grant and revoke object privilege