Database Creation and Architecture

RelationalDBDesign		Home Search SiteMap
Advanced SQL Basic SQL DB Creation Architect Extended DB Features Managing DB Objects Oracle Net Topology
PL/SQL Programming SQL Tuning Database Analysis Database Design Oracle 8i PL/SQL PL/SQL Objects


	Lesson 1	Course Introduction Module introduction
		Welcome to Database Creation and Architecture. This course is the first of five courses in the Oracle8 Database Administration Certification Series. Taken together, these five courses teach you how to create and manage an Oracle database.
		Course goals The first part of this series focuses on architecture, database creation, and the basics of interacting with an Oracle database. After you complete this course, you'll be able to: Create a new database Find the files in a database, and identify their purpose Identify the processes that operate on a database Understand the significant memory structures of a database instance Start up and shut down a database
		Oracle certification This course, taken in conjunction with the next four courses in the Oracle8 Database Administration Certification Series, will prepare you for the following Oracle certification exam: IZ0-013, Oracle8: Database Administration 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

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