Database Products

• MySQL - Open Source Database
• PostgreSQL
• Microsoft SQL Server
• Oracle Corporation
• Sybase Inc
• IBM DB2

SQL

• Introduction to SQL
• Transact-SQL Reference
• Oracle Documentation

Articles

• A Relational Model of Data for Large Shared Data Banks - E.F. Codd
• An introduction to Database Normalization
• Normal Form Definitions & Examples
• What is XQuery
• Interactive Online SQL Training
• SQL.ORG Online Resources

ER Diagramming Tools http://www.databaseanswers.com/modelling_tools.htm

Additional Tools and Sites

• MySQL Forge
• MySQL Developer Zone
• TOAD
• CodeBase
• Oracle Development Tools
• Database Development Tools
  

The basic properties of a database transaction ACID: Atomicity, Consistency, Isolation, and Durability.

* Atomicity - The entire sequence of actions must be either completed or aborted. The transaction cannot be partially successful.

* Consistency - The transaction takes the resources from one consistent state to another.

* Isolation - A transaction's effect is not visible to other transactions until the transaction is committed.

* Durability - Changes made by the committed transaction are permanent and must survive system failure.