Set up a MySQL database on Windows or Linux with help from this step-by-step beginner’s guide. Learn to design and create a database with tables, load data into your tables, and generate basic and advanced reports. You’ll also get details on how to administer, secure, and back up your database, and import data from other programs. Plus, learn to use PHP for dynamic web pages and MySQL web interfaces. Get started in no time with today’s most popular open source database and take advantage of all the features MySQL database server has to offer.
Designed for Easy Learning:
- Modules--Each concept is divided into logically organized modules (chapters), ideal for self-paced learning
- Critical Skills--Each module opens with the specific skills covered in the module
- Mastery Checks--End-of-module reviews test knowledge using short-answer, multiple-choice, and fill-in-the-blank questions
- Ask the Experts--Q&A sections throughout are filled with bonus information and helpful tips
- Progress Checks--Quick self-assessment sections check your progress
- Projects--Practical exercises show how to apply the critical skills learned in each module
Dr. John W. Horn is a recognized MySQL lecturer and trainer with Interstate Software LLC. Michael Grey is an IT professional, trainer, and writer who provides courseware development for Interstate Software, LLC. Interstate Software is the only gold-level partner with MySQL AB, the commercial MySQL company founded by the creators of the MySQL database server. Interstate Software provides authorized MySQL training and consulting.
Table of ContentsCh. 1: My SQL Overview
Ch. 2: Basic Reporting with MySQL
Ch. 3: Creating the Database
Ch. 4: Maintaining the Data
Ch. 5: Advanced Reporting
Ch. 6: Working with Windows
Ch. 7: PHP and C API
Ch. 8: Basic Administration and Backups
Most Helpful Customer Reviews
The other day I was asked to recommend a book on MySQL, which is one of the many things I am asked to do as a degreed/certified IT professional, but I digress. Knowing that most people have not yet learned the art of tech divination, I set out to find a book that would give a good basic understanding and result in the fewest phone calls for continued help from the database novice in question. While searching for this Rosetta Stone for MySQL, I came across this little gem. I skim all books I think about buying to see if the book is worth it¿s weight in paper, but this time I ended up reading the first two chapters at the bookshelf. The layout and content of this book is exactly what I would teach someone wanting to start using MySQL, and the computer jargon is kept to a minimum or clearly explained. This book delivers just what it promises: essential skills and a working understanding of MySQL with a bonus of PHP basics.
It's true! Coding can be fun! Databases can be fun! I picked up this book totally ignorant about MySQL, but came away feeling pretty confident about putting an interactive database on my site. The book reads incredibly well-- clearly the author is as good with English as she is with coding. The screen captures are particularly clear, and you feel as if you've been taken by the hand and led confidently through the minefield of coding! Each chapter has tips and a test to check you've mastered the content before you move on. It's structured so you start as a total beginner and end something of an expert. Fun examples are used throughout, in keeping with the pace and style of the book. This book will become a well-thumbed friend. Highly recommended.