Course Content :
SQL:

1. Writing Basic SQL SELECT Statements:
2. Restricting and Sorting Data:
3. Single-Row Functions:
4. Displaying Data from Multiple Tables:
5. Aggregating Data Using Group Functions:
6. Subqueries:
7. Producing Readable Output with iSQL*Plus
8. Manipulating Data
9. Creating and Managing Tables
10. Including Constraints
11. Creating Views
12. Other Database Objects
13. Controlling User Access
14. SQL Workshop Workshop Overview
15. Using SET Operators
16. Oracle Datetime Functions
17. Enhancements to the GROUP BY Clause
18. Advanced Subqueries
19. Hierarchical Retrieval
20. Oracle Extensions to DML and DDL Statements

Administration Introduction:

1. Oracle Architectural Components
2. Getting Started with the Oracle Server
3. Managing an Oracle Instance
4. Creating a Database
5. Using Data Dictionary and Dynamic Performance Views
6. Maintaining the Control File
7. Maintaining Redo Log Files
8. Managing Tablespaces and Datafiles
9. Storage Structure and Relationships
10. Managing Undo Data
11. Managing Tables
12. Managing Indexes
13. Maintaining Data Integrity
14. Managing Password Security and Resources
15. Managing Users
16. Managing Privileges
17. Managing Roles
18. Auditing
19. Loading Data into a Database
20. Using Globalization Support