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
$27.16
BN.com price
(Save 9%)$29.99 List Price
Other sellers (Paperback)
  • All (50) from $1.99   
  • New (13) from $8.52   
  • Used (37) 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

(NOTE: Each chapter concludes with a Summary, Q&A, and Workshop.)

Introduction.

I. INTRODUCTION TO MYSQL AND RELATIONAL DATABASES.

Hour 1. Introducing MySQL.

What Is a Relational Database? What Is MySQL? Communicating with MySQL.

Hour 2. Understanding Database Terminology.

Basic Elements Explained.

Hour 3. Learning the Database Design Process.

The Importance of Good Database Design. Types of Table Relationships. Understanding Normalization. Following the Design Process.

II. SETTING UP YOUR ENVIRONMENT.

Hour 4. Using the MySQL Client.

Working with the MySQL Command-Line Interface. Working with the MySQL Administration Tools. Other Interfaces to MySQL.

Hour 5. Securing MySQL.

Basic Security Guidelines. Introducing the MySQL Privilege System. Working with User Provileges.

III. LEARNING TO PLAN FOR YOUR DATABASE-DRIVEN APPLICATIONS.

Hour 6. Planning and Creating Your Database.

Determine Your Goals. Conceptualize the Tables. Creating the Database.

Hour 7. Creating Your Database Tables-Part I.

Learning the MySQL Data Types. Learning the Table Creation Syntax.

Hour 8. Creating Your Database Tables-Part II.

Identifying Keys in Your Tables. Adding Indexes to Your Tables. When to Use, or Not to Use, Keys and Indexes. Finalizing Your Table Creation Statements. Issuing Your Table Creation Statements.

IV. WORKING WITH YOUR TABLES.

Hour 9. Populating Your Database Tables.

Using the INSERT Command. Importing Data from Other Databases.

Hour 10. Selecting Data from Your Tables.

Using the SELECT Command. Using WHERE in Your Queries. Using Operators in WHERE Clauses. String Comparison Using LIKE.

Hour 11. Advanced Usage of SELECT Statements.

Using the GROUP BY Clause. Using SELECT Within INSERT Statements. Selecting from Multiple Tables. Using JOIN.

Hour 12. Modifying and Deleting Data.

Using the UPDATE Command to Modify Records. Using the REPLACE Command. Using the DELETE Command.

Hour 13. More About DELETE.

Deleting Related Records. Listing Tables and Databases Before Deleting Them. Using the DROP Command.

Hour 14. Modifying Table Structure.

Using DESCRIBE to View Table Structure. Renaming Tables. Using the ALTER Command.

V. USING BUILT-IN FUNCTIONS IN MYSQL QUERIES.

Hour 15. Using MySQL String Functions.

Frequently Used String Functions. Obscure String Functions.

Hour 16. Using MySQL Numeric Functions.

Using Numeric Functions in Queries.

Hour 17. Using MySQL Date and Time Functions.

Using Date and Time Functions in Queries. Formatting Dates and Times. Performing Date Arithmetic. Special Functions and Conversion Features.

VI. USING TRANSACTIONS.

Hour 18. Transactions Overview.

What Are Transactions? Transaction-Safe Table Types in MySQL.

Hour 19. Practical Transaction Usage.

Converting Tables to Transaction-Safe Table Types. Using Transactions in Your Applications.

VII. ADMINISTERING YOUR MYSQL SERVER.

Hour 20. Optimizing and Tuning Your Database.

Building an Optimized Platform. MySQL Startup Options. Optimizing Your Table Structure. Optimizing Your Queries.

Hour 21. Backing Up and Restoring Your Database.

Database Backup Overview. Using mysqlhotcopy. Using the BACKUP TABLE and RESTORE TABLE Commands. Using myisamchk.

Hour 22. Basic Administrative Commands.

Using the FLUSH Command. Using the SHOW Command.

VIII. INTERFACING WITH MYSQL.

Hour 23. Using MySQL with Perl.

Getting Access to Perl. Connecting to MySQL with Perl. Executing Queries. Working with MySQL Data.

Hour 24. Using MySQL with PHP.

Getting Access to PHP. How PHP Works. Connecting to MySQL with PHP. Working with MySQL Data.

IX. APPENDICES.

Appendix A. Installing MySQL.

How to Get MySQL. Installing MySQL 3.23 or 4.0 on Windows. Installing MySQL 3.23 or 4.0 on Linux/UNIX. Troubleshooting Your Installation.

Appendix B. Using MyODBC.

Installing MyODBC on Windows. Configuring MyODBC. Importing/Exporting Data with MysQL and Microsoft Access.

Appendix C. Reserved Words.

Appendix D. Practical MySQL/PHP Examples.

Creating Access Logs and Reports. Creating an Online Poll. Storing Uploaded Files in Your Database. Retrieving Images Files from Your Database.

Index.

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)