Ebook - Mastering MySQL 4

Book Description
MySQL Can Do More, and Now You Need to Know More

MySQL has proved it can compete with the big names in database management, such as SQL Server and Oracle, and with MySQL 4 this is truer than ever. Mastering MySQL 4 is your one-stop resource for all the information you need to create, maintain, use, and extend a MySQL database. It's also essential reading for anyone developing database applications in a MySQL environment. If you're new to MySQL, this is a great way to get up and running--fast. If you're upgrading, it will help you get all you can out of new features and support. Coverage includes:

• Installing MySQL
• Adding, removing, and updating records
• Choosing appropriate table types
• Choosing appropriate data types
• Optimizing MySQL queries
• Designing a database
• Normalizing table structure
• Maintaining and repairing databases
• Backing up and replicating data
• Managing user permissions and security
• Optimizing the MySQL server
• Extending MySQL
• Developing database applications

Sample
Buy It In

Eboo k - Creating your MySQL Database: Practical Design Tips and Techniques

Book Description
This book is an innovative and essential 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. 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. The book covers: Asking users the right questions to collect relevant data for the system you are building Detecting bad structures Sound data-naming techniques, for both table and column names Modeling data with future growth in mind Implementing security policies with data privileges and views Tuning the structure for performance Producing system documentation (data dictionary, relational schema) Testing the model with appropriate SQL queries This book takes a practical approach, implementing all theoretical concepts with examples. It is a fast-paced tutorial that focuses on critical decisions that you need to make every time you build MySQL databases. It is rich with tips and advice from an experienced practitioner. The book is ideal for 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. Chapter 1: Introduction Chapter 2: Data Collection Chapter 3: Data Naming Chapter 4: Data Grouping Chapter 5: Data Structure Tuning Chapter 6: Case Study: An Airline System

Sample

Buy It In

Ebook - The Definitive Guide to MySQL, Second Edition

Description

This is the second edition of Kofler’s acclaimed MySQL book, updated and expanded to cover MySQL 4.0, the most recent production release of the popular Open Source database, which boasts more than four million users worldwide.

Like the first edition, this revision, which has been renamed as The Definitive Guide to MySQL, Second Edition to reflect the breadth and depth of Kofler’s coverage of the topic, provides a thorough introduction to the installation, configuration, implementation, and administration of MySQL. In addition, Kofler also demonstrates how MySQL can be used in conjunction with various other technologies to create database-driven Web sites, and gives practical advice on database design. Kofler also shows what’s coming up next in MySQL 4.1.

The Definitive Guide to MySQL, Second Edition, is an irreplaceable resource for MySQL novices and experts alike.

Buy It In