September 5, 2008

Talking Data: Unravel the SQL and Database Mysteries

Understanding how databases work and learning basic SQL (Structured Query Language) techniques is crucial for any type of web development that requires you to store your data in a database. No matter what DBMS you use for your own website (SQL Server, MySQL, Oracle, etc.), the basics of design and retrieving data are the same.

Here is a great e-book (.pdf) covering all the topics to get you started.

Topics Covered:

Database Design
Normalisation
Simple SQL Queries
Database Performance Tuning
SQL Server Stored Procedures
SQL: Cross Joins, UNION, Case Expressions, Paging and Duplicates
Working with Strings