|
||
Lesson 1 |
Welcome to Tuning Oracle SQL Module introduction |
|
|
If you have already taken the first course in the Oracle8 Performance Tuning Certification Series,
Course goals Performance Tuning Basics, or the second course, Tuning the Oracle Instance, much of the information in this module will not be new to you. Because each course is unique, however, make sure that you read the course-specific information about what you should expect in this course.
After completing the course, you will be able to:
|
||
|
The OCP exam series
Upon completion of this course, you will have the skills required to quickly identify and correct non-optimal SQL.
You will also develop the knowledge necessary to prepare you to pass Exam 4 in the Database Administrator Track of the Oracle Certified Professional (OCP) exam series. If you want to read more about the Oracle Certified Professional (OCP) program and learn the best strategies for passing the OCP exams. If you have already taken the first course in this series, then you may already be somewhat familiar with this material. In either case, this PDF file provides you with a helpful resource for preparing to pass an OCP. |
||
|
The five-part series
The five courses in the series allow you to delve in detail into the various concepts that comprise Oracle performance tuning.
|
||
|
Learning Technologies In this course, you'll learn and practice SQL tuning with the following applets:
|
||
|
The series
Tuning Oracle SQL is the third of five courses in the Oracle8 Performance Tuning Certification Series
Certification Series. |
||
| The next lesson discusses the prerequisites for the course. | ||
| 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 |