CS444 Homepage

Database Organization

• Basic Course Information
• Course Schedule
• Text Site
• Oracle On-line Documentation (see also Pheatt's main web page)
• Chapter Notes 4E
• C&B Student Information
• Installing the Oracle Client
• mathcshw1.emporia.edu help

for  files.     . for  files.

• Project Overview
• Some Suggested Projects
• Project Dates and Deliverables

• Exam 1 Study Guide
• Final Exam

• Handout 0 - Accessing Oracle
• Handout 1a - Oracle Dictionary Tables of Interest Complete Data Dictionary Description
• Handout 1b - Useful Oracle Commands
• Handout 1c - SQL*Plus Quick Reference
• Handout 2 - Relational Operator Summary
• Handout 2a - Division Operator
• Handout 3 - Simple Queries and SQL for table creation
• Handout 4 - Elements of Oracle SQL
• Handout 5 - Operators, Functions
• Handout 6 - SELECT Statement
• Handout 6a - Oracle Data Dictionary Commands
• Handout 7 - Relational Operator Summary
• Handout 7a - Joins
• Handout 7b - Oracle Dates
• Handout 7c - Join examples
• Handout 7d - Key Functions in Oracle SQL
• Handout 8 - Relational Operators
• Handout 8a - Grouping and like matters
• Handout 8b - Constraints & Triggers
• Handout 8c - Relational Algebra Symbols and Examples
• Handout 8d - Row Identification and Related Matters
• Handout 8e - Over, Rank, and Dense Rank
• Handout 9 - The Daisy Hill Puppy Farm
• Handout 9a - Normalization
• Handout 10 - Balanced Trees another B-tree description
• Handout 11 - PL/SQL
• Handout 12 - Hierarchal and Network Databases
• Handout 13 - Functional Dependencies and Normalization
• Handout 14 - Misc. Handouts
• Handout 16 - The Owner/Property Participation Constraint SQL
• Handout 17 - The Roommate problem
• Handout 18 - Specifying Referential Actions for Foreign Keys Example
• Handout 19 - Stored Procedures
• Handout 20 - Partitioning
• Handout 21 - Databases, Clusters, Tablespaces, Packages, Profiles, Users, Instances and Schema
• Handout 22 - Implementing Constraints in Oracle
• Handout 23 - Oracle PRO*C
• Handout 24 - ADODC Example
• Handout 25 - ADO Examples
• Handout 26 - Visual C MFC ODBC Examples
• Handout 27 - The Kramer Handout code
• Handout 28 - DTL
• Handout 29 - Oracle Access On Linux
• Handout 30 - Accessing ODBC with VS6 C++
• Handout 31 - Database Security
• Handout 32 - Java Database Connectivity ppt
• Handout 33 - C# cgi and Database Access
• Handout 34 - Form Item Summary

• Free on-line dictionary of computing
• Some DBMS Resources
• Tutorials Another Tutorial Yet another tutorial Another
• Intelligent Enterprise
• Oracle FAQ
• Another Oracle FAQ
• SQL Standards Home Page
• www.oracle.com
• sqlcourse2.com
• Oracle Introduction to SQL Instructions disk 1 disk 2 disk 3
• Visual Basic and Databases
• Server 2000 Documentation
• HOW TO DRAW UML DIAGRAMS
• Dia is a gtk+ based diagram creation program released under the GPL license.
• Data warehousing for Nerds SQL for Web Nerds
• Philip and Alex's Guide to Web Publishing
• SQL Cartoon

• SQL*Plus Users Guide and Reference
• SQL*Plus Users Guide and Reference for Windows NT/95
• Personal Oracle Light Programmers Guide
• Replication with Oracle Light
• Integrating Pro*C/C++ into Microsoft Visual C++
• Oracle Data Dictionary
• Some Oracle Admin more admin
• Oracle Client Installation (8i)
• OTN
  • http://otn.oracle.com/software/content.html
  • http://tahiti.oracle.com/
  • http://oracle.com/education/oln/