Course Outline
1. Storing Information in Tables
• Introduction
• The Parts of the Table
2. Getting Information from a Table
• The Select Statement
• The Select Clause
• The Where Clause
• The Order By Clause
3. Compound Conditions in the Where Clause
• Compound Conditions in the Where Clause
• Constant Values
• Punctuation Matters
4. Saving Your Results
• Saving Your Results in a New Table or View
• Modifying the Data in a Table
5. Modifying Data Through a View
• Transactions
• Modifying Data Through a View
• Finding Information about Tables and Views
6. Creating Your Own Tables
• Creating Tables
• Changing Tables
• Tables with Duplicate Rows
• Loading a Large Amount of Data from a Flat File
7. Formats, Sequences, and Indexes
• Formats
• Sequences
• Indexes
• Finding More Information in the Data Dictionary
8. Data Integrity
• Referential Integrity
• The Delete Options and Update Options of RI
• Variations of referential Integrity
• Other Types of Constraints
9. Row Functions
• Introduction to Row Functions
• Number Functions
• Text Functions
• Date Functions
10. Using Row Functions
• Other Functions
• Using the Documentation of Row Functions
• Creating Patterns of Numbers and Dates
11. Summarizing Data
• Introduction to the Column Functions
• Maximum and Minimum
• Count
• Sum and Average
• Nulls and Distinct Dates
12. Controlling the Level of Summarization
• Dividing a Table into Groups of Rows and Summarizing Each Group
• Eliminating Some of the Summarized Data
• Restrictions on Summarization
13. Inner Joins
• Introduction to Joins
• Inner Joins of Two Tables
• Variations of the Join Condition
• Applications of Joins
14. Outer Joins
• Introduction to Outer Joins
• Applications of Outer Joins
15. Union and Union All
• Unions
• Unconventional Unions
• Applications of a Union
• Set Intersection and Set Difference in Oracle
16. Cross Joins and Self Joins
• Cross Joins
• Self Joins
17. Combining Tables in a Production Database
• Methods of Losing Three or More Tables
• Losing Information
• Caring About Efficiency of Your Computer
• Standardizing the Way that Tables Are Joined
18. If-Then-Else and Subqueries
• If-Then-Else Logic
• Parameter Queries
• SubQueries
• Applications of Subqueries
• Older Features of Subqueries
19. Modifying Data in Tables
• Insert Statement
• Update Statement
• Delete Statement
• Commit and Rollback
20. Creating Your Own Tables
• Create Table command
• Primary Keys
• Changing Tables
• Loading Existing Data Sets
|
