Oracle SQL Training: Introduction to Oracle 11g SQL Programming

Oracle 11g SQL Training Outline

• Relational Databases & SQL
• About Relational Databases
• Elements of SQL
• Choosing A SQL & PL/SQL Interface
• About Database Connections
• About Bind Variables
• Using SQL Developer
• Using SQL*PLUS
• Using Application Express
• Building A Statement
• About the Select Statement
• Using Alias Names
• Restricting Data with the Where Clause
• About Logical Operators
• Equality Operator
• Boolean Operators
• Null & Between Operators
• Is [Not] Null Operator
• [Not] Between Operator
• Finding Text Strings
• [Not] Like Operator
• Regexp_Like()
• In Operator
• Sorting Data with the Order By Clause
• About the Order By Clause
• Multiple Column Sorts
• Specifying the Sort Sequence
• About Null Values within Sorts
• Using Column Aliases
• Pseudo Columns & Functions
• Using Rowid
• Using Rownum
• Using the Functions
• Sysdate
• User & Uid
• Using the Dual Table
• Sessiontimezone Function
• Joining Tables
• About Joins
• Inner Join
• Reflexive Join
• Non-Key Join
• Outer Join
• Using the Set Operators
• About the Set Operators
• Set Operator Examples
• Summary Functions
• About Summary Functions
• Summary Functions with Distinct
• Using Sub-Queries
• About Sub-Queries
• Standard Sub-Queries
• Correlated Sub-Queries
• Aggregating Data within Groups
• About Summary Groups
• Finding Groups within the Base Tables
• Selecting Data from the Base Tables
• Selecting Groups from the Result Table
• Build Simple SQL*PLUS Reports
• Format Column Output with Column
• Defining Report Breaks with Break
• Produce Subtotals with Compute
• Use Data Definition Language to Create & Manage Tables
• Create Table Statement
• Not Null
• Default
• Alter Table Statement
• Drop Table Statement
• Supportive Statements
• Describe
• Rename
• Use Data Manipulation Language to Manipulate Data
• About the Insert Statement
• About the Delete Statement
• About the Update Statement
• About Transactions
• Rollback
• Commit
• Savepoint
• Set Transaction
• Truncate Table
• Complex Table References
• SQL99 Join Techniques
• Cross Joins
• Natural Joins
• Inner Joins
• Outer Joins
• Anti Joins
• Using Named Subqueries
• Enhancing Groups with Rollup & Cube
• Using Rollup
• Using Cube
• Using the Case Expression
• SQL Functions: Character
• String Formatting Functions
• Ascii Codes Functions
• Pad & Trim Functions
• String Manipulation Functions
• String Comparison Functions
• Phonetic Search Functions
• SQL Functions: Numeric
• About the Numeric Functions
• Null Value Functions
• SQL Functions: Date
• Date Format Functions
• Date Arithmetic Functions
• Database Objects: Relational Views
• About Database Objects
• About Relational Views
• Updating View Data
• Maintaining View Definitions
• Alter View
• Drop View
• Database Objects: Data Dictionary Storage
• About the Data Dictionary
• Object-Specific Dictionary Views
• User_Updatable_Columns
• Understanding the Data Dictionary Structure
• Database Objects: Indexes
• About Indexes
• Use B-Tree Indexes
• Database Objects: Other Objects
• More About Creating Tables
• About Sequences
• Alter Sequence & Drop Sequence
• Alter Sequence
• Drop Sequence
• About Synonyms
• Drop Synonym
• Create Schema Authorization
• Database Objects: Security
• User Passwords
• Object Security
• Data Using Constraints
• About Constraints
• Not Null Constraint
• Check Constraint
• Unique Constraint
• Primary Key Constraint
• References Constraint
• Defining Constraints On Existing Tables
• Managing Constraint Definitions
• Renaming & Dropping Constraints
• Enabling & Disabling Constraints
• Deferred Enforcement
• Set Constraints
• Handling Constraint Exceptions
• Constraints with Views
• Data Dictionary Storage
• Advanced SQL*PLUS Reports
• Break
• Compute
• Column
• Ttitle & Btitle
• Conclusion

© 2008 Sideris Courseware Corporation