Welcome to OCDatabases.org

Backup Web Site for POS410 Course

Database Websites on this Server

CSS417-Demo: ASP Demonstration using a Microsoft Access Database

POS410 - SQL for Business

    Lecture 1 (Flexnet Week 2) - Basic Data Retrieval  

    SQL Scripts to build a sample database and tables

    Diagram of the Database

    Lecture 2 (Flexnet Week 3) - Joins and Sub-queries

    SQL Scripts for Basic (and not so Basic) Joins

    SQL Scripts for Joins and Sub-queries with GROUP BY and HAVING

    SQL Tutorial - Link to FirstSQL.com concise tutorial based on C.J. Date's famous three tables.