RelationalDBDesign  
prev next prev next
  Course navigation
 
Lesson 1
Course introduction
Programming PL/SQL using Oracle 8i
 
This course introduces you to the object-oriented paradigm within the context of Oracle8i, then focuses on the SQL and PL/SQL commands for creating, modifying, and manipulating data within objects such as object tables and related object tables. This course also covers nested tables, varrays, LOBs, object types, and objects embedded within relational tables.
You ’ll learn the steps necessary to create and use methods written in PL/SQL to manipulate data within objects.
This is the first course in the five-part Oracle8i New Features Certification Series. Taken in conjunction with the other courses within this series, this course will also prepare you to pass the Oracle8i New Features for Administrators certification exam. Along the way, you’ll work on a series of course projects and exercises that will give you a chance to put your new skills to use in the context of actual business scenarios.

Course goals
Completing the course, you will be able to:
  1. Describe the SQL enhancements that allow you to query object and related object tables
  2. Flatten nested tables and query them
  3. Update object tables
  4. Insert and delete rows in object tables
  5. Analyze dangling references
  6. Update nested tables and varrays
  7. Insert and delete rows in nested tables and varrays
  8. Create and use methods for object types
      In this course, you will learn and practice your skills with two kinds of widgets:
  1. the SlideShow,
  2. the MouseOver.
Learning bridges
oracle-image

When you see this icon you can click it to go to a learning bridge.
The series
New Features for PL/SQL is the first of five courses in the Oracle8i New Features
Certification Series.
In the next lesson, the prerequisites for this course will be discussed.
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