SQL

    This is the SQL home page.  It is referred to by various course home pages.  It contains links to the sample database and to the folders for numbered units.  The folder names are descriptive of the topics of the units.  Inside the folders you will find the files for these units, including the PowerPoint presentations.

    Here are files on the sample database:

newcardealdesign.doc  This document contains the Access generated entity-relationship diagram for the database.

newcardealschemas.doc  This document contains schemas for all of the tables in the database.

newcardealcontents.doc  This document shows the contents of the tables in the database.

newcardeal_access2000.mdb  This is the database in an old version of Access.  It is possible to use the database with newer versions of Access too.

newcardeal_openoffice3.2.odb  This is the database in OpenOffice Base.

            Here is a folder containing documentation on a movie database.  You may want to familiarize yourself with this database because SQL test questions will be based on it.

MovieDatabase

    Here are the folders for the units:

Unit1Introduction  SQL Unit 1, An Introduction to Relational Databases

Unit2SelectionAndProjection  SQL Unit 2, Simple SQL Queries with Selection and Projection

Unit3Joins  SQL Unit 3, Joins

Unit4FunctionsAndCalculatedFields  SQL Unit 4, Built-in Functions and Calculated Fields

Unit5GroupByAndHaving  SQL Unit 5, Aggregation, GROUP BY, and HAVING

Unit6ViewsAndTemporaryTables  SQL Unit 6, Views and Temporary Tables

Unit7SetOperations  SQL Unit 7, Set Operations

Unit8SubqueriesWithIn  SQL Unit 8, Subqueries with IN, Joins, and Other Topics

Unit9CorrelatedSubqueries  SQL Unit 9, Correlated Subqueries

Unit10CreatingTablesConstraintsAndIndexes  SQL Unit 10, Creating Tables, Adding Constraints, and Defining Indexes

Unit11ChangingDBContentsAndDesign  SQL Unit 11, Inserting, Updating, and Deleting Data; Changing the Database Design

Unit12MSAccessInformation  SQL Unit 12, Creating Tables, Keys, and Constraints in Access.  (Applied assignment:  Small Project.)

Unit13FinalProject  SQL Unit 15, Final Project

Unit14EntitiesAndRelationships  SQL Unit 13, Chapters 3-6 from Watson, Entities and Relationships

Unit15DataModeling  SQL Unit 14, Chapter 7 from Watson, ER Modeling, Assignment, No Notes

Unit16EasyPHPInformation  SQL Unit 16, EasyPHP and MySQL

Unit17Normalization  SQL Unit 17, Chapter 8 from Watson, Normalization

Unit18RelationalModelAndAlgebra  SQL Unit 18, Chapters 9 and 10 from Watson, The Relational Model and Relational Algebra

Unit19HashJoinAndB+Trees  SQL Unit 19, Chapter 11 from Watson, Data Structure and Storage (Hashing, B+ Trees, etc.)

Unit20ObjectOrientedModelingAndDesign  SQL Unit 20, Chapter 12 from Blaha and Rumbaugh, (Object-Oriented) Domain Analysis

Unit21ObjectOrientedDesignAndDatabases  SQL Unit 21, Chapter 19 from Blaha and Rumbaugh, Databases (Derived from O-O Model)