Welcome to OCDatabases.org

Backup Web Site for University of Phoenix and Orange Coast Databases Classes

Please note this site is always in the process of being updated and some features and/or links may not yet work. Our apologies for this temporary inconvenience. Links to zip files of the course scripts, databases, PowerPoint slides, etc. can be found on the course pages listed below.

Database Websites on this Server

CSS417-Demo: ASP Demonstration using a Microsoft Access Database

Undergraduate University of Phoenix Course Notes

DBM380 - Database Design

DBM405 - Database Implementation

POS410 - SQL for Business

Graduate University of Phoenix Courses

CSS558/DBM500 - Database Concepts I (Graduate)

CSS559/DBM502 - Database Concepts II (Graduate)

Orange Coast Application and Office Courses

AIN102 Microsoft Access Query Design (1 day)

AIN104 Microsoft Access Reports and Forms (1 day)

AMP110 Microsoft Access Macros and Automation (1 day)

AVB201 Introduction to Microsoft Access VBA (1 day)

AVB202 Microsoft Access VBA (DAO & ADO) (1/2 day)

Orange Coast SQL & Database Courses

DBD200  - Introduction to Relational Database Design (2 days)

DBD201 - Accelerated Introduction to Relational Database Design (1 day)

SQL200 - Introduction to SQL (1 and 1/2 days)

SQL200S - Introduction to SQL Queries (1 day)

SQL200A - Introduction to MS Access SQL

SQL201W - Introduction to SQL using MySQL

SQL202 - Introduction to Transact SQL (T-SQL) (2 days)

There will be three (or more) sub-domains on this site. the above material will eventually be consolidated under these sub-domains.

ASP Demonstration using Microsoft Access

    sub-domain:    asp-demo.ocdatabases.org

University of Phoenix course Backup Material (Flexnet lectures and such)

    sub-domain:    uop.ocdatabases.org

SQL Scripts

These scripts will be referenced from the UoP sub-domain as well as other sites maintained by Dan D'Urso for Orange Coast Database Associates, D. H. D'Urso and Associates, the University of Phoenix and other related sites. The purpose is to consolidate all my public SQL scripts in one place. We have many more scripts to add over the next few weeks as we prepare a new short version MySQL course and new updates for the UoP POS410 course. Typically, referencing links will open a new window.

The SQL scripts will span four databases: Microsoft Access, MySQL, Microsoft SQL Server and Oracle.

    sub-domain:    sql-scripts.ocdatabases.org

Back