Book 6

Managing Data with MySQL

• Chapter 1: Getting Started with Data Data is the key to any high-powered web application. Learn how data works, become familiar with SQL, MySQL, and the PHPMyAdmin tool.
• Chapter 2: Managing Data with MySQL Write SQL code by hand. Select data from a database, edit records, and export your data in various formats.
• Chapter 3: Normalizing Your Data Writing a database is one thing, but getting your data to act properly is quite another. Learn how to use the rules of data normalization to build well-defined databases.
• Chapter 4: Putting Data Together with Joins Once you've built a normalized database, everything behaves well, but it doesn't look like what the user expects. Use functions, views, and joins to extract data in any format you want.
• Chapter 5: Connecting PHP to a MySQL Database The single most marketable skill in web development is to build a web-enabled database. Create a series of PHP programs that can read and write to a MySQL database on your server.