|
||
Lesson 1
|
Managing Database Objects Course Introduction
|
|
| Welcome to Managing Database Objects. This course is the third of five courses in the Oracle8 Database Administration Certification Series. Taken together, these five courses teach you to create and manage an Oracle8 database. | ||
|
Course goals This course focuses on the database structures within an Oracle database. After completing this course, youll be able to
|
||
|
Oracle certification This course, taken in conjunction with the other four courses in the Oracle8 Database Administration Certification Series, will
prepare you for the following Oracle certification exam:
This database administration exam is one of five that you must pass in order to earn certification as an Oracle8 database administrator. |
||
| Advanced Structured Query Language |
| Characteristics of SQL | Group By Clause | Sub-Select Statements | Sub-Select Equals Clause |
| Basic Structured Query Language |
| DB Normalization - Exercise | Relational DB Analogy | Relational vs. Flatfile | Customer Table Example |
| SQL Approaches - Quiz | SQL-92 |
| Database Creation Architecture |
| Managing Database Objects |
| Oracle Network Topology |
| Location Independence | Transparent NS | Distributed Databases | Searching Oracle Topology |
| Hardware Independence | |||
| Oracle SQL Tuning |
| Heuristics Based Optimizer | Oracle Explain Plan Utility | SQL Tuning Quiz | Decode ansi standard sql |
| PL/SQL Programming |
| Relational Database Analysis |
| Relational Database Design |