|
Class 1:
- Introduction
- Writing Basic SQL Statements
- Restricting and Sorting Data
- Single Row Functions
- Displaying Data from Multiple Tables
Class 2:
- Aggregating Data by Using Group Functions
- Writing Sub queries
- Producing Readable Output with isql *Plus
- Manipulating Data
Class 3:
- Creating and Managing Tables
- Including Constraints
- Creating Views
Class 4:
Class 5:
Class 6:
- Using Set Operators
- Oracle Date time Functions
- Enhancements to the GROUP BY Clause
- Advanced Sub queries
Oracle Database Administration
Class 7:
- Oracle Architectural Components
- Getting Started with the Oracle Server
- Managing an Oracle Instance
Class 8:
- Creating a Database Data Dictionary Contents and Usage
Class 9:
- Maintaining the Control File
- Maintaining Redo Log Files
Class 10:
- Managing Table spaces and Data files
- Storage Structures and Relationship
Class 11:
- Managing Undo Data
- Managing Indexes
- Maintaining Data Integrity
Class 12:
- Managing Password Security and Resources
- Managing Users
- Managing Privileges
- Managing Roles
|
