Relational Database and SQL Overview
- Review of Relational Database Terminology
- Relational Database Management Systems
- Introduction to SQL
- Oracle Versioning and History
- Logical and Physical Storage Structures
- Connecting to a SQL Database
- Datatypes
- Sample Database
|
Using Oracle SQL*Plus
- SQL*Plus
- The SQL Buffer
- Buffer Manipulation Commands
- Running SQL*Plus Scripts
- Tailoring Your SQL*Plus Environment
- Viewing Table Characteristics
- SQL*Plus Substitution Variables
- Interactive SQL*Plus Scripts
- Using iSQL*Plus
|
| |
|
SQL Queries - The SELECT Statement
- The SELECT Statement
- The CASE...WHEN Statement
- Choosing Rows with the WHERE Clause
- NULL Values
- Compound Expressions
- IN and BETWEEN
- The LIKE Operator
- Creating Some Order
|
Scalar Functions
- SQL Functions
- Using SQL Functions
- String Functions
- Numeric Functions
- Date Functions
- Conversion Functions
- Date Formats
- Oracle Pseudocolumns
|
| |
|
SQL Queries - Joins
- Selecting from Multiple Tables
- Joining Tables
- Self Joins
- Outer Joins
- Types of Outer Joins
|
Aggregate Functions and Advanced Techniques
- Subqueries
- Correlated Subqueries
- The EXISTS Operator
- The Aggregate Functions
- Grouping Rows
- Combining SELECT Statements
|
| |
|
Data Manipulation and Transactions
- The INSERT Statement
- The UPDATE Statement
- The DELETE Statement
- Transaction Management
- Concurrency
- Explicit Locking
- Data Inconsistencies
- Loading Tables From External Sources
|
Data Definition and Control Statements
- Standard Datatypes
- Defining Tables
- Constraints
- Inline Constraints
- Modifying Table Definitions
- Deleting a Table Definition
- Controlling Access to Your Tables
|
| |
|
Other Database Objects
- Views
- Creating Views
- Updatable Views
- Sequences
- Synonyms
|
Appendix A - The Data Dictionary
- Introducing the Data Dictionary
- DBA, ALL, and USER Data Dictionary Views
- Some Useful Data Dictionary Queries
|
