Course Outline :

Oracle Database 11g: SQL Fundamentals Course 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 Select 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

Appendix A
• Reference Information
• Sql Ddl Statement Reference
• Sql Dml Statement Reference
• Sql Transaction Control Statement Reference
• Sql Operators Reference

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 Integrity 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