Database Systems (CPSC-310)

Home | Index

Options - | Course | General | SQL | Oracle | Theory | More | New |

^ Course Information

Texas A&M CPSC-310 Notes
Password required!

^ General

Database System Concepts 30-Sept-97
Site providing information about the textbook
Texas A&M CPSC-310 30-Sept-97
Notes from another semester
CPSC 608 Database Systems 30-Sept-97
Student site
Database Systems Course Notes
From Northern Alberta Institute Of Technology
WWW Database courseware
From Dublin City University, Ireland. Includes information about SQL database language
Stanford CS 145 (Introduction to Databases) 26-Sept-97

^ SQL

SQL Tutorial 23-Sept-97
"The first comprehensive SQL tutorial available on the Internet".
SQL Homepage 26-Sept-97
The tutorial uses queries actually run from a database using Microsoft SQL Server.
Database Documents 23-Sept-97
Has a SQL Tutorial
SQL Tutorial 23-Sept-97
Includes examples of SQL commands.
Short Guide to SQL
SQL Tutorial 23-Sept-97
Mainly example tables and SQL statements.
SQL Tutorial
For the Illustra object-relational database.
IMAGE/SQL tutorial 23-Sept-97
Graeme Birchall
Includes SQL Cookbook - mainly in PostScript
inquiry.com: Ask the SQL Pro
Excellent list of online info. One good option is Useful Database Sites.
inquiry.com
Select Tech Tips and Search for Celko for SQL-related articles.
SQL Examples 26-Sept-97
Information from CS 360 (DataBase Management Systems) including Referential Integrity Definitions and a Database Case Study
Simplified Command Relational Algebra 26-Sept-97

^ Oracle

Oracle 7 Server SQL Language Reference Manual
Other information is the Application Programming Interface and Oracle 7 (version 7.3) Server Documentation.
Oracle General Book Index 26-Sept-97
One of the books is Oracle 7 Server SQL Reference - Table of Contents
Oracle Underground Frequently Asked Questions 26-Sept-97
Click on graphic to go to start.
Oracle Resources Center at TechnoSolutions 26-Sept-97
Nice! list of Oracle-related information.
Oracle View 26-Sept-97
Online Magazine of Oracle Users.
ORACLE User Forum 26-Sept-97
Usenet Newsgroups 26-Sept-97

^ Theory

William Kent
Has many online papers; some may be useful for CPSC 310 database theory.

^ Additional Information

Microsoft Internet Information Server Installation and Administration Guide (Chapter 8) 26-Sept-97
Includes graphics showing database access from the WWW.
Telox Guide 26-Sept-97
Includes database links.
Data Warehousing Knowledge Center 26-Sept-97

^ Newly Added Information

New! Five Rules of Data Normalization 10-Oct-97
New! Data Modeling 10-Oct-97
New! Normalization 10-Oct-97
New! Fundamentals of Database Design 10-Oct-97
New! The Relational Database Model 10-Oct-97
New! Oracle Online Tutorial 10-Oct-97
New! A Synthetic Method for Normalizing Relational Databases 10-Oct-97
New! A Well Designed Relational Database 10-Oct-97
New! Data Base Management Systems 10-Oct-97
ISQS 6339 Summer 1996 Syllabus.
New! Normalization 10-Oct-97
New! Relational Algebra and Calculus 10-Oct-97
New! An Overview of Database Management 10-Oct-97
New! CS 425 - Introduction to Database 10-Oct-97
PowerPoint application.
New! Normalization 10-Oct-97
New! Databases: Theory and Practice 10-Oct-97
New! Databases for Management (MGT 230) 10-Oct-97
New! Database System Implementation - CS245b 10-Oct-97
New! Getting Started With Oracle 10-Oct-97
New! Peter Koletzke's Oracle Home Page 10-Oct-97
New! Oracle Tutorial 10-Oct-97
New! Database Info 10-Oct-97
Includes an SQL/Oracle WWW Project
New! Toronto Oracle User Group 10-Oct-97
List of Oracle-related information on the Internet 10-Oct-97
New! Computing Science 291/391 Laboratory Manual 10-Oct-97
New! SQL*Plus - Oracle Frequently Asked Questions 10-Oct-97
New! SQL - Oracle Frequently Asked Questions 10-Oct-97
New! Gserver: Oracle - PL/SQL - WWW 10-Oct-97
From Virginia Tech's explanation - Gserver is RGS's database and information server. This page is the base document for our public Oracle-WWW resources; the focus is on PL/SQL (via the Oracle WebServer) but also with some use of Perl and Java. It has links to things we want to demo or announce publically (see mailing list link below). The demos below require a browser with good forms and table support
Tuple, Normalize, Relational, Relational Algebra, Relational Calculus, Table
Please send me additional information for CPSC 310.
j-fullerton@tamu.edu
Revised 10-Oct-97