Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Java Programming
Print PageIntroduction to Oracle 9i SQL
Description:
This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database.
View other Oracle Courses
View other Oracle Courses
- Cost: Price on application
- Duration: 3 Days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
none required
RELATIONAL DATABASES & SQL::
About Relational Databases
Elements of SQL
Elements of SQL
USING SQL*PLUS::
About SQL *Plus
Using the MS Windows SQL *Plus Tool
Using the ISQL *Plus Tool
Entering Commands and Syntax
Using the MS Windows SQL *Plus Tool
Using the ISQL *Plus Tool
Entering Commands and Syntax
BUILDING A SELECT STATEMENT::
About the Select Statement
Selecting Columns
Using Alias Names
Selecting Columns
Using Alias Names
BUILDING A WHERE CLAUSE::
About Logical Operators
Equality Operator
Boolean Operator
Null & Between Operators
Finding Text Strings
In Operator
Equality Operator
Boolean Operator
Null & Between Operators
Finding Text Strings
In Operator
ORDERING THE RESULT TABLE::
About the Order by clause
Multiple Column Sorts
Specifying the sort sequence
About Null Values within Sorts
Using Column Aliases
Multiple Column Sorts
Specifying the sort sequence
About Null Values within Sorts
Using Column Aliases
PSEUDO COLUMNS & FUNCTIONS::
About Pseudo Colums & Functios
Using ROWID
Using ROWNUM
Using the functios
Using the Dual Table
Session Timezone Function
Using ROWID
Using ROWNUM
Using the functios
Using the Dual Table
Session Timezone Function
JOINING TABLES::
About Joins
Inner Joins
Reflexive Join
Non Key Join
Outer Join
Inner Joins
Reflexive Join
Non Key Join
Outer Join
USING SET OPERATORS::
About the Set Operators
Set Operator Examples
Set Operator Examples
SUMMARY FUNCTIONS::
About Summary Functions
Summary Function with Distinct
Summary Function with Distinct
USING SUBQUERIES::
About Subqueries
Standard Subqueries
Correlated Subqueries
Standard Subqueries
Correlated Subqueries
CREATING & SELECTING GROUPS::
About Summary Groups
Finding groups with the base tables
Selecting data from the base tables
Selecting groups from the result table
Finding groups with the base tables
Selecting data from the base tables
Selecting groups from the result table
SQL*PLUS COMMANDS::
About SQL *Plus Commands
More about Script Files
Invoking Operating System Commands
Saving Session Output
More about Script Files
Invoking Operating System Commands
Saving Session Output
BUILD SIMPLE SQL*PLUS REPORTS::
About the SQL *Plus report Features
Session Output with set
Format column output with Column
Defining Reort Beaks with Break
Produce Subtotals with Commute
Session Output with set
Format column output with Column
Defining Reort Beaks with Break
Produce Subtotals with Commute
SQL DATA DEFINITION LANGUAGE::
About SQL DDL
Create Table Statement
Alter Table Statement
Drop Table Statement
Supportive Statements
Create Table Statement
Alter Table Statement
Drop Table Statement
Supportive Statements
SQL DATA MANIPULATION LANGUAGE::
About SQL DML
About the Insert Statement
About the Delete Statement
About the Update Statement
About Transactions
Truncate Table
Complex Table References
About the Insert Statement
About the Delete Statement
About the Update Statement
About Transactions
Truncate Table
Complex Table References