×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

MySQL Tutorial
     

MySQL Tutorial

5.0 1
by Luke Welling, Laura Thomson
 

See All Formats & Editions

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

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.

Editorial Reviews

bn.com
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.

Product Details

ISBN-13:
9780672333002
Publisher:
Pearson Education
Publication date:
11/24/2003
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
288
File size:
1 MB

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.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews

MySQL Tutorial 5 out of 5 based on 0 ratings. 1 reviews.
babababa More than 1 year ago
Please Buy.