|
This page
indexes SQL tutorial scripts related to the various SQL courses from
Orange Coast Database Associates in Orange County, California. The
course scripts are more or less in the same order as we cover them in
a class. Other scripts are alphabetical.
The courses
are two to three modules of 1/2 day each. They are intended for
beginning SQL programmers, analysts, power users and others who need
to query SQL data. They are not aimed at certification prep although
they can be a good basis for further study. click on the title to
download the script.
Bookstore
database Oracle build script - Oracle script to build the
bookstore database, the main database used in most of our courses.
This database is used in SQL Clearly Explained by Jan Harrington.
Bookstore
database MSSQL
build script - SQL Server script to build the bookstore
database, the main database used in most of our courses. This
database is used in SQL Clearly Explained by Jan Harrington.
The following are additional SQL scripts that may be used by our
instructors or referenced during a class. Click on the title to
download the script.
EmployeeDept
- A simple SQL Server script to build the Employees and Departments
database found in many old database texts. It is the main database
used in anthony Molinaro's SQL Cookbook. The main tables are EMP and
DEPT. It is just about the same as the sample Scott database supplied
with Oracle minus a couple tables.
Northwind
- The classic Microsoft sample database found almost everywhere. This
is Microsoft's SQL Server install script.
Pets
- SQL Server Script to build a super simple database with one fact
table. Includes a couple queries to demonstrate the rollup and cube
operators. In the future we may add a couple of dimension tables to
turn this database into a true star schema. I forget where we got
this one.
Premiere
Products
- Access Jet SQL script to build the Premiere Products sample
database used in Pratt's Guide To SQL. Create an ODBC connection to
an empty Access database. Then use a query front end that supports
ODBC. WinSQL is one simple one. Premiere Products sells appliances.
The design holds the quoted price as well as the list price.
Pubs
- Microsoft's SQL Server script to build the long standing Pubs
sample database used by SQL Server and Sybase.
UPAtttractions
-
SQL Server script to build the Upper Peninsula attractions database.
This is one of the databases used in Jonathan Gennick's Pocket Guide
to SQL.
Submit the
form below to be notified of new SQL scripts or PowerPoint slides.
We are always
looking for referrals. Click below to learn more about our referrals program.
Learn more
about our SQL courses.
 |
