Below is a screenshot from the Microsoft Access relationship designer of the bookstore database. This database is one of the main ones used in our classes. It comes from SQL Clearly Explained by Jan Harrington. You can download the scripts to build this database at SQL Scripts. There are versions for both Oracle and SQL Server.
Pages
Labels
1st normal form
Books
calculated fields
case
cloud
concatenation
cube
database design
database diagram
database scripts
downloads
erd
except
first normal form
intersect
median
mode
MySQL
normal forms
normalization
outer join
pos410
PowerPoints
rollup
sql scripts
sql201w
sql202
sql206
sql212
sql302
text schemas
Total lines
union
visio
Welcome
Showing posts with label downloads. Show all posts
Showing posts with label downloads. Show all posts
Tuesday, February 21, 2012
Thursday, February 9, 2012
Resources
PowerPoint Presentations of our SQL Classes can be found on SlideShare.
Script files that can be downloaded and run can be found on Box.net. The script files are arranged both by database and by course.
Script files that can be downloaded and run can be found on Box.net. The script files are arranged both by database and by course.
Subscribe to:
Posts (Atom)