|
| Database Normalization BasicsThis article explains the basics of database normalization terminology. A basic understanding of this terminology is helpful when discussing the design of a relational database. |
|
|
| 5 Rules of Data NormalizationDescribes the 5 Rules of Data Normalization: Eliminate repeating groups, eliminate redundant data, eliminate columns not dependent on key, isolate independent multiple relationships, and isolate semantically related multiple relationships. |
|
|
| Database NormalizationWell normalized data makes programming (relatively) easy, and works very well in multi-platform, enterprise wide environments. Non-normalized data leads to heartbreak. The first three normal forms: No repeating groups, must depend on entire primary key, and must depend directly on the primary key. |
|

|
| Database Overview TutorialFree online Database Overview tutorial. FindTutorials.com provides hundreds of free online IT tutorials. Tutorials range from entry level texts on using word processors through to advanced techniques in web development/database design and network routing. |
|
|
| Overview of the Relational ModelThis document is an informal introduction to relational concepts, especially as they relate to relational database design issues. |
|
|
| WDVL: DatabasesIntroduction to databases for the Web by Selena Sol. Learn how to use a database to manage, retrieve and display your e-commerce site's inventory. This tutorial consists of four sections: Database Basics, Retrieving and manipulating Data, CGI Interfaces to SQL Databases and Java Database Connectivity. |
|
|
| Test Your Knowledge of SQL Server Performance TuningIn case you need a little escape from work, a challenge, or you just want to learn a little more, here is a 20 question quiz to test your knowledge about SQL Server performance tuning and optimization. The quiz covers SQL Server performance tuning basics that apply to every version of SQL Server. |
|