  
                     
|
| |
 |
INTRODUCTION TO ORACLE 10G SQL PROGRAMMING
| Course Description |
|
In this class, students will learn how to create, retrieve, and manipulate objects in Oracle10g Structured Query Language (SQL). Students will also be introduced to Oracle10g database features and tools.
Course Length: 2 Days
Course Tuition: $790 (US)
|
• 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
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
