• What is SQL?
• What Can SQL do?
• SQL is a Standard
• RDBMS

Basic SELECT Statement
• Selecting All Columns
• Selecting Specific Columns
• Writing SQL Statements
• Column Heading Defaults
• Arithmetic Expressions
• Using Arithmetic Operators
• Operator Precedence
• Using Parentheses
• Defining a Null Value

• Limiting Rows Using a Selection
• Limiting the Rows Selected
• Using the WHERE Clause
• Character Strings and Dates
• Comparison Conditions
• Using Comparison Conditions
• Other Comparison Conditions

• SQL Function
• Two Types of SQL Functions
• Single-Row Functions
• Single-Row Functions
• Character Functions
• Character Functions
• Case Manipulation Functions
• Using Case Manipulation Functions
• Character-Manipulation Functions

• Obtaining Data from Multiple Tables
• Cartesian Products
• Generating a Cartesian Product
• Types of Joins
• Joining Tables Using Oracle Syntax
• What is an Equijoin?
• Retrieving Records with Equijoins
• Additional Search Conditions Using the AND Operator
• Qualifying Ambiguous Column Names
• Using Table Aliases

• What Are Group Functions?
• Types of Group Functions
• Group Functions Syntax
• Using the AVG and SUM Functions
• Using the MIN and MAX Functions
• Using the COUNT Function
• Using the DISTINCT Keyword
• Group Functions and Null Values
• Using the NVL Function with Group Functions
• Creating Groups of Data
• Creating Groups of Data: The GROUP BY Clause Syntax
• Using the GROUP BY Clause
• Grouping by More Than One Column

• Objectives
• Using a Subquery to Solve a Problem
• Subquery Syntax
• Using a Subquery
• Guidelines for Using Subqueries

• Data Manipulation Language
• Adding a New Row to a Table
• The INSERT Statement Syntax 8-5
• Inserting New Rows
• Inserting Rows with Null Values
• Inserting Special Values
• Inserting Specific Date Values

• Database Objects
• Naming Rules
• The CREATE TABLE Statement
• Referencing Another User?s Tables
• The DEFAULT Option
• Creating Tables
• Tables in the Oracle Database
• Querying the Data Dictionary 9-10
• Data Types
• DateTime Data Types

• What are Constraints? • Constraint Guidelines • Defining Constraints • The NOT NULL Constraint • The UNIQUE Constraint • The PRIMARY KEY Constraint • The FOREIGN KEY Constraint

• Database Objects
• What is a View?
• Why use Views?
• Simple Views and Complex Views
• Creating a View
• Retrieving Data from a View
• Querying a View
• Modifying a View
• Creating a Complex View

• Database Objects
• What is a Sequence?
• The CREATE SEQUENCE Statement Syntax
• Creating a Sequence
• Confirming Sequences
• NEXTVAL and CURRVAL Pseudocolumns
• Using a Sequence
• Modifying a Sequence

• Objectives
• Controlling User Access
• Privileges
• System Privileges
• Creating Users
• User System Privileges
• Granting System Privileges
• What is a Role?
• Creating and Granting Privileges to a Role
• Changing Your Password
• Object Privileges

• The SET Operators
• Tables Used in This Lesson
• The UNION Operator
• Using the UNION Operator
• The UNION ALL Operator
• Using the UNION ALL Operator
• The INTERSECT Operator
• Using the INTERSECT Operator
• The MINUS Operator
• SET Operator Guidelines

• Review of Group Functions
• Review of the GROUP BY Clause
• Review of the HAVING Clause
• GROUP BY with ROLLUP and CUBE Operators
• ROLLUP Operator
• ROLLUP Operator Example
• CUBE Operator

• What Is a Subquery?
• Subqueries
• Using a Subquery
• Multiple-Column Subqueries
• Column Comparisons
• Pairwise Comparison Subquery
• Nonpairwise Comparison Subquery
• Using a Subquery in the FROM Clause
• Scalar Subquery Expressions
• Scalar Subqueries: Examples
• Correlated Subqueries
• Using Correlated Subqueries

Review of the INSERT Statement
• Review of the UPDATE Statement
• Overview of Multitable INSERT Statements
• Overview of Multitable INSERT Statements
• Types of Multitable INSERT Statements
• Multitable INSERT Statements
• Unconditional INSERT ALL
• Conditional INSERT ALL
• Conditional FIRST INSERT
• Pivoting INSERT
• External Tables