Database Resources and Tools

Databases are used to back a vast majority of Web sites on the Internet. Using a database can add dynamic and interactive features to your Web site and save maintenance cost and time. I still remember how excited I was when I was first introduced to D-Base, a database system, in the early ‘90s. Although it was difficult to work with D-Base, it didn’t take me long to figure out how powerful databases could be to store and manage all sorts of data.

Today, databases are used by almost all businesses to deploy mission-critical applications. Database management tools keeps on innovating and have built-in features for archiving, migration, backups, performance tuning and replication. Today we’re going to take a look at some popular and useful database resources and tools:

Getting Started

Introduction to Databases
These series of articles will introduce you to the basics of database technology and will help you get started.

Database Planning Guide
A comprehensive guide (Word Format) to database planning process. It includes templates, worksheets, questionnaires and many other resources. Wikipedia has an excellent comparison matrix of relational database management systems.

Choosing the right database management system
With so many database solutions available, you need to take good care in choosing one that has the features you need and meet your requirements.

Library of free database models
This library includes hundreds of sample database schemas for tons of topics ranging from Video Purchase to Inventory Control.

Ten of the Biggest Mistakes Developers Make With Databases
A breakdown of some of the biggest mistakes developers make with databases.

Database Optimization

Optimizing Database Queries
How to write more efficient SQL statements to speed up your database queries.

How to Normalize Your Database
Lean how to normalize your database to ensure consistency and eliminate redundancy.

Database Replication in MySQL
Learn how to performance tune your MySQL database through the creation and maintenance of multiple copies of the same database.

SQL Server Performance
A site dedicated to SQL server performance. It includes articles about performance tuning, clustering and benchmarks.

Database Management Tools

SQL Buddy
SQL Buddy is an AJAX solution to explore and manage your database online simply using a Web browser.

HeidiSQL is a graphical interface for easy management of your MySQL server and databases. It is a freeware and available for Windows only.

Navicat, unlike HeidiSQL offers more options for database management and is available for Mac and Linux as well.

Several freeware tools for database developers aimed at making database and application development faster and easier.

Remotely Hosted Database Tools

Allows you to design, create and share a database of whatever you like. The database can be easily added to your Web site and viewed in many ways, on maps or on graphs.

This tool allows you to upload your database scheme and it will generate your database abstraction layer for PHP and MySQL.

WWW SQL Designer
This tool lets you visually create your database schema and export it to different formats that can then be used to create your database.

Know any other useful database tools or resources? Submit them as a comment.