Adobe Dreamweaver CS5 with PHP: Training from the Source

Lesson 5. Designing and Building Your Own Database

What You Will Learn

In this lesson, you will:

• See how a database stores information

• Understand the principles behind efficient database structure

• Explore the different data types stored in MySQL

• Define the database table for a user registration system

• Understand the effect of collation on how database records are sorted

• Pick the appropriate database engine

• Create MySQL user accounts and assign privileges

• Import existing data from an external file

Approximate Time

This lesson takes approximately 2 hours to complete.

Lesson Files

Media Files:

None

Starting Files:

None

Completed Files:

lesson05/states.sql

Having a content management system like WordPress build a database for ...