Sams Teach Yourself MySQL in 24 Hours

Overview

Sams Teach Yourself MySQL in 24 Hours teaches the reader everything from basic installation to using MySQL in Web application development.

First, the basic concepts of database design are taught, and then the reader jumps right into planning and creating a database. The book then walks the reader through all the basics of using MySQL - working with tables and data, using MySQL¿s query functions, using transactions, and database administration - before the reader finally learns ...

See more details below
Paperback
$28.20
BN.com price
(Save 5%)$29.99 List Price
Other sellers (Paperback)
  • All (51) from $1.99   
  • New (12) from $11.96   
  • Used (39) from $1.99   
Sending request ...

Overview

Sams Teach Yourself MySQL in 24 Hours teaches the reader everything from basic installation to using MySQL in Web application development.

First, the basic concepts of database design are taught, and then the reader jumps right into planning and creating a database. The book then walks the reader through all the basics of using MySQL - working with tables and data, using MySQL¿s query functions, using transactions, and database administration - before the reader finally learns to put everything together to properly create the foundation database for a Web-based application.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
You know the conventional wisdom on MySQL: trusty little database, great for web applications, speedy, reliable, and you can’t beat the price. But (there’s always a but!) without crucial features like transactions, definitely not enterprise-ready. Well, with the long-awaited 4.x upgrades, the MySQL people are finally dealing with that last objection -- which means this already popular package is likely to spread even more rapidly. Whether your application is grassroots or pinstripes, read SAMS Teach Yourself MySQL in 24 Hours and you’ll be ready.

Julie Meloni walks you through all the bread-and-butter tasks you’ll want to master with MySQL 4.0, including transactions (though stored procedures, moved back to 4.1, isn’t here yet). She starts with the absolute basics: simple database design; using the MySQL client; creating and populating your database tables; selecting, modifying, and deleting data. Gradually, you’ll build your skills; first modifying table structures, then using MySQL’s many built-in functions in your queries.

There’s a full section on administering your MySQL server, covering optimization, tuning, backup, and restore. And, for the programmers among us, complete introductions on using MySQL with both Perl and PHP. With this book, you’re a lot closer to mastering MySQL than you thought. (Bill Camarda)

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks For Dummies®, Second Edition.

Read More Show Less

Product Details

  • ISBN-13: 9780672323492
  • Publisher: Sams
  • Publication date: 4/28/2002
  • Series: Sams Teach Yourself Series
  • Pages: 350
  • Product dimensions: 7.16 (w) x 9.05 (h) x 0.86 (d)

Meet the Author

Julie Meloni is the technical director for i2i Interactive, a multimedia company located in Campbell, CA (that's just down the street from San Jose). She's been developing Web-based applications since the Web first saw the light of day and remembers the excitement surrounding the first GUI Web browser. She is the author of several books and articles on Web-based programming languages and database topics, and you can find translations of her work in several languages, including Chinese, Italian, Portuguese, and Polish.

Read More Show Less

Table of Contents

Introduction 1
Pt. I Introduction to MySQL and Relational Databases 5
Hour 1 Introducing MySQL 7
Hour 2 Understanding Database Terminology 17
Hour 3 Learning the Database Design Process 25
Pt. II Setting Up Your Environment 37
Hour 4 Using the MySQL Client 39
Hour 5 Securing MySQL 53
Pt. III Learning to Plan for Your Database-Driven Applications 63
Hour 6 Planning and Creating Your Database 65
Hour 7 Creating Your Database Tables - Part I 73
Hour 8 Creating Your Database Tables - Part II 83
Pt. IV Working with Your Tables 95
Hour 9 Populating Your Database Tables 97
Hour 10 Selecting Data from Your Tables 111
Hour 11 Advanced Usage of SELECT Statements 125
Hour 12 Modifying and Deleting Data 135
Hour 13 More About DELETE 147
Hour 14 Modifying Table Structure 157
Pt. V Using Built-in Functions in MySQL Queries 167
Hour 15 Using MySQL String Functions 169
Hour 16 Using MySQL Numeric Functions 181
Hour 17 Using MySQL Date and Time Functions 193
Pt. VI Using Transactions 207
Hour 18 Transactions Overview 209
Hour 19 Practical Transaction Usage 217
Pt. VII Administering Your MySQL Server 225
Hour 20 Optimizing and Tuning Your Database 227
Hour 21 Backing Up and Restoring Your Database 237
Hour 22 Basic Administrative Commands 245
Pt. VIII Interfacing with MySQL 257
Hour 23 Using MySQL with Perl 259
Hour 24 Using MySQL with PHP 271
Pt. IX Appendices 287
App. A Installing MySQL 289
App. B Using MyODBC 299
App. C Reserved Words 311
App. D Practical MySQL/PHP Examples 315
Index 339
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)