Tom Trollen's
CIS119 Links

Description: Description: Description: U:\BPC110\stretchy_header_left.jpg

 Textbook's companion web site Has answers to the Test Your Thinking exercises.

Database Design and Data Redundancy

My own article introducing the data hierarchy, keys & relationships and data redundancy.

Retrieving Data With SQL Queries

An article from databases.about.com. Covers basic SELECT statements, WHERE clauses, column headings,  and DISTINCT.

SQL Fundamentals

An article from databases.about.com. Provides an overview of SQL and the types of commands it contains.

SQL Tutorial

From w3Schools.com. Has lessons for many SQL statements and clauses. Use the navigation list on the left.

SQL Course2

From DatabaseJournal.com. An interactive SQL tutorial.

A Gentle Introduction to SQL

From SQLZoo.net. An interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer SQL, PostgreSQL and Access.

DatabaseJournal.com

Articles and tutorials for Oracle, MS SQL Server, Access, DB2, MySQL, PostGreSQL,and PHP.

Retrieving Data From Multiple Tables with SQL Joins

An article from databases.about.com that covers inner and outer joins.

Full Outer Joins in Oracle9i

An article by Sanjay Mishra that covers inner- and outer-joins. It presents both the traditional Oracle (+) operator and the new join syntax.

DevDex.com

Articles, tutorials, FAQ's, sample code, discussion forums for SQL, ASP, C#, VB, and XML.

IT Toolbox - Oracle Knowledge Base

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/20/2010

Disclaimer