• Title: Creating your MySQL Database: Practical Design Tips and Techniques
• Author(s) Marc DeLisle
• Publisher: Packt Publishing (November 25, 2006)
• Permission: Read for Free Provided by the Publisher (Packt)
• Paperback: 108 pages
• eBook: PDF
• Language: English
• ASIN: 1904811302
• ISBN-13: 978-1904811305
• Share This:  

Book Description

Creating your MySQL Database: Practical Design Tips and Techniques: A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.

If you're creating a dynamic web application using open-source tools, then you're probably going to be setting up a MySQL database. Getting the design of this database right for your application and its data is vital, but it's often an intimidating and little-known process for non-developers and developers alike.

Written by the creator of the popular phpMyAdmin tool, this book is a short but complete guide on how to design good data structures for MySQL. Anyone working with applications that use a MySQL database backend will benefit greatly from the advice and techniques in this book. Although a working knowledge of both SQL and MySQL is assumed, the book is suitable for both beginners and intermediate users alike. Whether you read it through and absorb the advice or work through it on a live project, the efficiency and maintainability of your databases will certainly improve as a result.

For most of us, setting up the database for an application is often an afterthought. While you don't need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective. This book doesn't set out to make you an expert in data analysis, but it does provide a quick and easy way to raise your game in this essential part of getting your application right!

• Marc Delisle is a member of the MySQL Developers Guild - which regroups community developers - because of his involvement with phpMyAdmin. He started to contribute to this popular MySQL web interface in December 1998, when he made the first multi-language version. He has been actively involved with the phpMyAdmin project since May 2001 as a developer and project administrator.

• Amazon

• MySQL
• PostgreSQL
• SQL - The Structured Query Language
• Database Theory and Systems

• Creating your MySQL Database: Practical Design Tips and Techniques (Marc DeLisle)
• The Mirror Site (1) - PDF
• The Mirror Site (2) - PDF

• MySQL Notes for Professionals

  When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to solve MySQL problems from scratch.

• MySQL Essentials (Neil Smyth)

  This ebook is designed to provide a step by step path to proficiency with MySQL, a fully featured, scalable relation database management system. The book covers everything needed to successfully build, maintain and secure MySQL based databases.

• Essential MySQL (Krzysztof Kowalczyk)

  This book provides clear and concise explanation of topics for programmers both starting to learn the MySQL programming as well as those diving in more complex topics. Examples are linked to online playground that allows you to play with them.

• MySQL (Wikibook)

  This book teaches you how to work with MySQL - a popular relational database management system. You will learn how to download and install MySQL on your Windows or Linux system. You will learn how to access MySQL through the command line or GUI, how to create a database, how to query a database, sort results, and much more.

• MySQL Tutorials (Jan Bodnar, et al)

  This tutorial is a step-by-step tutorial for everyone who's ready to learn about the database software most commonly used for storing information behind some of today's most popular websites and online applications.

• MySQL to DB2 Conversion Guide (Whei-Jen Chen, et al)

  This book is an informative guide that describes how to convert the database system from MySQL to DB2 on Linux and the steps that are involved in enabling the applications to use DB2 instead of MySQL.

• Intrusion Detection Systems with Snort: using MySQL and PHP

  This book provides detailed information about using SNORT as an IDS and using Apache, MySQL, PHP and ACID to analyze intrusion data. It contains custom scripts, real-life examples for SNORT, and to-the-point information about installing SNORT IDS so readers can build and run their sophisticated intrusion detection systems.

• Managing and Using MySQL, 2nd Edition (George Reese, et al)

  This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration.

• MySQL and mSQL (Randy Jay Yarger, et al.)

  This book is all you need to make use of MySQL or mSQL. It takes you through the whole process from installation and configuration to programming interfaces and basic administration. Includes reference chapters and ample tutorial material.