·         INFO 366 Syllabus

 

·         Projects

1.      Project Description,

2.      Project Document Guideline

 

Course Slides

Week 1

·         Introduction: Computer Organization;

·         DBA

·         DBA_howto;

·         Oracle Memory Internals;

·         Oracle Disk Internals;

·         File Organization

·         Review Disks, Disk Parameters;

Week 2-3

·         Database Installation;

·         Indexing;

·         Single Level Index Example;

·         multi-level index, B Tree, B+ Tree examples;

·         Tuning Table and Index

·         Examples: Create Table, Create TableSpace, Create Index

 Homework 1

Week 4

·         Database Tuning –Process, Memory;

·         Data Integrity Constraints;

·         Foreign Key Constraints;

·         Example-foreign key constraints

Week 5-6

·         Part 1: Mid-term Exam,

·         User and Resource Control;

·         creating profiles; creating user;

·         Database Tuning-User and Rollback Data Spaces, Recovery, Backup

 

Week 7

Homework 2,

·         User_Profile

·         TableSpace_Data_File  

·         Oracle Architecture Overview,  Storage Concepts and Setting, 

 

Week 8 Redo Log File, Backup and Recovery, SQL Loader

Week 9 Physical DB Tuning,   Physical DB Queries Tuning,  DB Tuning Class