Oracle Database 11g - SQL Fundamentals

Lesson 1: Volume 1

• Relational Databases & SQL
• Choosing a SQL & PL/SQL Interface
• Building a Select Statement
• Restricting Data with the Where Clause
• Sorting Data with the Order by Clause
• Using the Set Operators
• Summary Functions
• Using Sub-Queries
• Aggregating Data within Groups
• Build Simple SQL Plus Reports
• Use Data Definition Language to Create and Manage Tables
• Use Data Manipulation Language to Manipulate Data
• Appendix A

Lesson 2: Volume 2

• SQL99 Join Techniques
• Enhancing Groups with Rollup and Cube
• Using the Case Expression SQL Functions: Character
• SQL Functions: Numeric
• SQL Functions: Date
• Database Objects: Relational Views
• Database Objects: Data Dictionary Storage
• Database Objects: Indexes
• Database Objects: Other Objects
• Database Objects: Security
• Data Integrity Using Constraints
• Managing Constraint Definitions
• Advanced SQL Plus Reports
• Optional – Advanced SQL Plus Reports
• Optional – Building SQL Plus Scrips
• Optional – SQL Plus Session Control

• Charleston, SC - June 4, 2012
• Columbia, SC - June 4, 2012
• Greenville, SC - June 4, 2012
• Charleston, WV - June 4, 2012
• West Valley City, UT - June 4, 2012
• Urbandale, IA - June 4, 2012
• Charleston, SC - August 6, 2012
• Columbia, SC - August 6, 2012
• Greenville, SC - August 6, 2012
• Charleston, WV - August 6, 2012
• Charleston, SC - October 8, 2012
• Columbia, SC - October 8, 2012
• Greenville, SC - October 8, 2012
• Charleston, WV - October 8, 2012
• Mechanicsburg, PA - October 15, 2012
• Charleston, SC - December 10, 2012
• Columbia, SC - December 10, 2012
• Greenville, SC - December 10, 2012
• Charleston, WV - December 10, 2012