RelationalDBDesign  
prev next prev next
  Course navigation
 
Lesson 1
 Welcome to Tuning Oracle SQL
Module introduction
 
If you have already taken the first course in the Oracle8 Performance Tuning Certification Series,
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.
  1. This course is the third in the five-part Oracle8 Performance Tuning Certification Series
  2. This course takes an in-depth look into the concepts and skills you need to tune Oracle with SQL.
  3. I will teach you an understanding of the broader issues of tuning with SQL
  4. We willl delve into tuning with the Optimizers, the Explain Plan Utility, Hints, and other tuning techniques.
After completing this course, you will be able to tune all Oracle SQL and take the actions required to ensure optimal SQL performance.
Course goals
After completing the course, you will be able to:
  1. Define the major features of Oracle SQL
  2. Tune using ANSI extensions
  3. Tune using the Explain Plan Utility
  4. Understand SQL Optimizer modes
  5. Tune using the rule-based optimizer
  6. Tune using the cost-based optimizer
  7. Tune using SQL hints
  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.
  1. Performance Tuning Basics
  2. Tuning the Oracle Instance
  3. Tuning Oracle SQL
  4. Tuning the External Oracle Environment
  5. Advanced Oracle Tuning Concepts
  Learning Technologies
In this course, you'll learn and practice SQL tuning with the following applets:
  1. SlideShow
  2. MouseOver,
  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    
Oracle Describe Command Oracle Spool Command Oracle Exit Command desc oracle command
Start Server Manager Locating Oracle Home Server Manager Executable Server Manager HELP Command
Set output off - Oracle
Managing Database Objects   
Oracle Segment Role Alter extent size table Tablespace Fragmentation Quiz Operating system blocks
Oracle Extents Free Diction-Quiz Oracle Storage Concepts Describing Columns View
Coalesce Tablespace Oracle Tablespace Default Storage Fragmented TableSpace Oracle Extents Data Dictionary
Oracle Dictionary Extents Oracle storage management concepts Oracle free space Auction House Database
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   
dbms_out.put_line in sql Petstore schema pl sql dbms_output Building Queries with PL/SQL
non pl/sql variables bind and host (PGA) Program Global Area Pet Store DataModel Adding PL/SQL Comments
PL/SQL Block Conclusion Oracle Naming Conventions
Define: Truth Table Define: Unary Define: Pragma
Relational Database Analysis  
Define Primary Key Concatenated Keys Normalization First Normal Form Exercise
DB Tables Characteristics Database Design Diagram Second Normal Form - Exercise Normalization Process - Quiz
Referential Integrity Defining Foreign Keys Functional Dependencies - Exercise Normalization Database - Quiz
Relational Theory Notation Achieving 2nd Normal Form
Relational Database Design  
Design Stages in DBLC ERD Modeling CaseStudy Three Schema Architecture Database LifeCycle
Database Design - Quiz Database Design Strategy RDBMS Functions Relational DB Design
Relational DB Design Quiz Post Database Design Stages Top Down Design Relational Database Course Project
ERD Exercise Bottom-up Design