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.
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)