Tom Trollen's
CIS119 Links
|
|
Tom Trollen's |
|
Companion web site Has online quizes & answers to the Test Your Thinking exercises.
An article by Tim McLellan. Covers tables, keys, table relationships, and referential integrity.
Database Design and Data Redundancy
My own article introducing the data hierarchy, keys & relationships and data redundancy.
An article from databases.about.com. Provides an overview of SQL and the types of commands it contains.
Retrieving Data With SQL Queries
An article from databases.about.com. Covers basic SELECT statements, WHERE clauses, column headings, and DISTINCT.
Has lessons for many SQL statements and clauses. Use the navigation list on the left.
Retrieving Data From Multiple Tables with SQL Joins
An article from databases.about.com that covers inner and outer joins.
An article by Sanjay Mishra that covers inner- and outer-joins. It presents both the traditional Oracle (+) operator and the new join syntax.
An interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer SQL, PostgreSQL and Access.
Has articles, tutorials, FAQ's, sample code, discussion forums for SQL, ASP, C#, VB, and XML.
IT Toolbox - Oracle Knowledge Base
Has articles, tutorials, FAQ's, sample code, discussion forums.
Top | BPC110 | CIS117 | CIS119 | CIS217 | GBS221 | CIS Home
Page maintained by Tom Trollen. Feedback welcome.
Last updated: 01/12/2007