MySQL Tutorial

( 1 )

Overview

A concise introduction to the fundamentals of working with MySQL.

MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications.

MySQL Tutorial is a clear, concise introduction to the ...

See more details below
Paperback
$31.74
BN.com price
(Save 20%)$39.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (23) from $1.99   
  • New (7) from $7.91   
  • Used (16) from $1.99   
MySQL Tutorial

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study

Want a NOOK? Explore Now

NOOK Book (eBook)
$15.49
BN.com price
(Save 44%)$27.99 List Price

Overview

A concise introduction to the fundamentals of working with MySQL.

MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications.

MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web.

Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
It’s free. (Or, depending on your application and environment, merely very cheap.) It’s fast. It’s becoming more and more powerful. You can run it on your favorite platform -- Linux, UNIX, or Windows. And it’s reliable: It just does the job. It’s MySQL. And (unless you sell for Oracle or Microsoft), you’ve got to admit, that’s one heck of a value proposition.

No wonder MySQL now powers more than 4 million web sites, data warehouses, and applications -- for organizations ranging from Yahoo! Finance to NASA. No wonder more than 27,000 more folks download MySQL every day.

If you ever work with databases -- as a DBA, developer, or user, or even as a manager or a client who needs a database-driven solution -- you ought to know about MySQL. Now there’s an introductory MySQL tutorial that comes straight from the source: MySQL Press.

Better still, it comes from two of the world’s most respected MySQL authors, Luke Welling and Laura Thomson. They’re the authors of PHP and MySQL Web Development, Second Edition, a book we -- and many other folks -- raved about when it was published.) From their experience as professional web and database developers, Welling and Thomson know MySQL inside out. From their experience teaching databases as university instructors, they also know how to explain MySQL -- clearly, simply, and in bite-size nuggets.

Each chapter of MySQL Tutorial focuses on one topic, walks you through each relevant task, and can be read in just one sitting...even by those of us with TV-induced short attention spans. By the time you’ve finished this concise book, you’ll be comfortable with all the day-to-day MySQL you’ll need: installation, configuration, usage, administration, and performance optimization.

After you’ve walked through installing MySQL and taking a quick tour of its capabilities, Welling and Thomson offer a crash course in database design and normalization: the principles involved in minimizing redundancy, maximizing efficiency, and ensuring that you don’t lose any data. You’ll plan the structure for a simple employee database; in the following chapter, you’ll implement that database with MySQL.

Next, it’s on to creating and deleting tables and indexes, and altering existing table structures, using SQL’s Data Definition Language (DDL) and Data Manipulation Language (DML). Welling and Thomson show how to insert and change data; and how to upload bulk data from text files, using LOAD DATA INFILE.

Once you’ve gotten data in, the authors turn to getting it out. They start with the simplest SELECT queries: displaying entire columns, using WHERE to choose specific rows. Gradually, you’ll build your skills, learning how to write queries that span multiple tables, and how to use several types of joins and subqueries. There’s also a full chapter on MySQL’s built-in query-related functions.

Those are the basics, but this book takes you a lot further. You’ll learn when to use each kind of MySQL table; how to use MySQL’s transaction support; and how to configure, maintain, backup, restore, and replicate your MySQL databases.

Last but not least, there’s a full section on optimization: everything from server configurations and database engines to queries. Your database will run fast. You’ll learn MySQL even faster. 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: 9780672325847
  • Publisher: MySQL Press
  • Publication date: 12/1/2003
  • Pages: 267
  • Sales rank: 951,786
  • Product dimensions: 8.76 (w) x 6.96 (h) x 0.65 (d)

Meet the Author

Luke Welling is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. He chooses to use Open Source software whenever practical and evangelizes the advantages of this approach as widely as possible. He has spoken to audiences in Australia, North America, and Europe about MySQL, PHP, and other Open Source topics. He has taught a wide variety of technical topics to university students and professionals, but he specializes in Internet-related topics.

Laura Thomson is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. She has taught a wide variety of courses with a Web and Internet focus and is currently completing a Ph.D. in Web Mining. She speaks at conferences around the globe and has delivered training at organizations as diverse as Ericsson and Lonely Planet. Previously, Laura has worked for Telstra and the Boston Consulting Group. She holds a first-class honors degree in Computer Systems Engineering and a degree (with distinction) in Computer Science. In her spare time, she rides her horses, feeds her menagerie of animals, and occasionally speaks to Luke about something nontechnical.

Read More Show Less

Table of Contents

Introduction.

I. MySQL Basics.

1. Installing MySQL.

2. Quick Tour.

II. Designing and Creating Databases with MySQL.

3. Database Design Crash Course.

4. Creating Databases, Tables and Indexes.

III. Using MySQL.

5. Inserting, Deleting, and Updating Data.

6. Querying MySQL.

7. Advanced Queries.

8. Using MySQL Built-in Functions with SELECT.

IV. MySQL Table Types and Transactions.

9. Understanding MySQL's Table Types.

10. Using Transactions with InnoDB Tables.

V. Administering MySQL.

11. Managing User Privileges.

12. Configuring MySQL.

13. Administering Your Database.

14. Backup and Disaster Recovery.

15. Securing Your MySQL Installation.

16. Replicating Your Database.

VI. Optimizing MySQL.

17. Optimizing Your MySQL Server Configuration.

18. Optimizing Your Database.

19. Optimizing Your Queries.

Index.

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

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
Sort by: Showing 1 Customer Reviews
  • Posted August 29, 2011

    more from this reviewer

    Great! Must read for beginners & pro

    Please Buy.

    0 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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