Home > Store > Databases > SQL Server
MySQL Crash Course
- By Ben Forta
- Published Dec 12, 2005 by Sams.
- Copyright 2006
- Dimensions: 5-1/2" x 8-1/4"
- Pages: 336
- Edition: 1st
- Book
- ISBN-10: 0-672-32712-0
- ISBN-13: 978-0-672-32712-4
Register your product to gain access to bonus material or receive a coupon.
Product Author Bios
Ben Forta is Macromedia Corporation's product evangelist for the ColdFusion product line. Ben has over 15 years of experience in the computer industry, and spent 6 years as part of the development team responsible for creating OnTime, one of the most successful calendar and group-scheduling products, with over one million users worldwide. Ben is the author of the popular ColdFusion Web Application Construction Kit, and its sequel Advanced ColdFusion 4 Application Development. His book Sams Teach Yourself SQL in 10 Minutes is one of the world's bestselling SQL books with over 100,000 copies sold.
MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:
- Retrieve and sort data
- Filter data using comparisons, regular expressions, full text search, and much more
- Join relational data
- Create and alter tables
- Insert, update, and delete data
- Leverage the power of stored procedures and triggers
- Use views and Cursors
- Manage transactional processing
- Create user accounts and manage security via access control
Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.
|
50 of 50 people found the following review helpful
Great Book For Beginners, By
This review is from: MySQL Crash Course (Paperback)
I've previously stated that I am glad to see good books on advanced MySQL usage appearing such as Pro MySQL, High Performance MySQL and the like. Well, now there is a book that makes be glad to see good books for beginners: <a href="http://www.amazon.com/exec/obidos/redirect?link_code=as3&path=ASIN/0672327120&tag=vbmysqlcom-20&camp=211189&creative=373489">MySQL Crash Course by Ben Forta</a>.While experienced MySQL users should steer clear of this book, MySQL Crash Course is an excellent book for the beginner. It starts right from the basics, talking about what a database is, what SQL is, what MySQL is, then hits the ground running talking about constructing queries, sorting, using functions, etc. The book has a good, easy to read format for each section that discusses the purpose of the section, shows a sample query, its output, and an analysis. The book wisely hides the advanced details not relevant to the beginner (such as no discussion of isolation... Read more
18 of 18 people found the following review helpful
Simply the Best, By
This review is from: MySQL Crash Course (Paperback)
Anyone who wants to understand MySQL MUST buy this book. Even if you're not the hard core programmer, but - like me - just "heavy uses" PHP/MySQL apps like the great "Drupal" CMS (http://www.drupal.org)! I have had quite some books on SQL, but this is the best introduction ever. Most books tend to be quite heavy on the reader, especially if you have to get to know MySQL while at the same time being busy with your every day job. This one however I started reading on a half hour plane ride, and finished off at night in front of the TV and in just that one single day I had found the key to MySQL! Go buy it!
17 of 17 people found the following review helpful
Great for databases in general, falls apart on administrivia,
Amazon Verified Purchase(What's this?)
This review is from: MySQL Crash Course (Paperback)
If you are fairly familiar with the concept of a database, this book could very well be all you need to get going. My issue with it is that it skimps on some of the very basic stuff. For example, it never goes over the syntax of the create call for creating a database, doesn't explain calling mysql at the command prompt as a particular user, gives you 11 chapters on manipulating data before showing you how to create a table, waits for chapter 28 to mention administering users, and puts datatypes in the appendix. These are the first things I wanted to learn. By the time I was done googling these concepts, I got pretty good at mySql and knew where to find better resources. At that point, the book became a very light reference.
|
Online Sample Chapters
Table of Contents
MySQL¨Crash Course
Table of Contents
Introduction 1
Who Is This Book For? ................................................................................. 2
Companion Website ...................................................................................... 2
Conventions Used in This Book ................................................................. 3
1 Understanding SQL 5
Database Basics ............................................................................................. 5
What Is SQL? ............................................................................................... 11
Try It Yourself ............................................................................................... 11
2 Introducing MySQL 13
What Is MySQL? ......................................................................................... 13
MySQL Tools ............................................................................................... 16
3 Working with MySQL 21
Making the Connection .............................................................................. 21
Selecting a Database .................................................................................. 22
Learning About Databases and Tables .................................................. 23
4 Retrieving Data 27
The SELECT Statement .............................................................................. 27
Retrieving Individual Columns ................................................................ 27
Retrieving Multiple Columns ................................................................... 29
Retrieving All Columns ............................................................................. 31
Retrieving Distinct Rows .......................................................................... 31
Limiting Results ........................................................................................... 33
Using Fully Qualified Table Names ...................................................... 35
5 Sorting Retrieved Data 37
Sorting Data .................................................................................................. 37
Sorting by Multiple Columns .................................................................... 39
Specifying Sort Direction .......................................................................... 40
6 Filtering Data 45
Using the WHERE Clause ......................................................................... 45
The WHERE Clause Operators ................................................................. 46
7 Advanced Data Filtering 53
Combining WHERE Clauses ..................................................................... 53
Using the IN Operator ................................................................................ 57
Using the NOT Operator ........................................................................... 59
8 Using Wildcard Filtering 61
Using the LIKE Operator ........................................................................... 61
Tips for Using Wildcards ........................................................................... 65
9 Searching Using RegularExpressions 67
Understanding Regular Expressions ....................................................... 67
Using MySQL Regular Expressions ....................................................... 68
10 Creating Calculated Fields 81
Understanding Calculated Fields ............................................................ 81
Concatenating Fields .................................................................................. 82
Performing Mathematical Calculations ................................................. 86
11 Using Data ManipulationFunctions 89
Understanding Functions ........................................................................... 89
Using Functions ........................................................................................... 90
12 Summarizing Data 99
Using Aggregate Functions ...................................................................... 99
Aggregates on Distinct Values .............................................................. 106
Combining Aggregate Functions ........................................................... 108
13 Grouping Data 111
Understanding Data Grouping ............................................................... 111
Creating Groups ......................................................................................... 112
Filtering Groups ......................................................................................... 113
Grouping and Sorting ................................................................................ 116
SELECT Clause Ordering ......................................................................... 119
14 Working with Subqueries 121
Understanding Subqueries ....................................................................... 121
Filtering by Subquery ................................................................................ 121
Using Subqueries As Calculated Fields ............................................. 126
15 Joining Tables 131
Understanding Joins .................................................................................. 131
Creating a Join ............................................................................................ 134
16 Creating Advanced Joins 143
Using Table Aliases ................................................................................. 143
Using Different Join Types ..................................................................... 144
Using Joins with Aggregate Functions ................................................ 149
Using Joins and Join Conditions ............................................................ 151
17 Combining Queries 153
Understanding Combined Queries ........................................................ 153
Creating Combined Queries ................................................................... 154
18 Full-Text Searching 161
Understanding Full-Text Searching ...................................................... 161
Using Full-Text Searching ...................................................................... 163
19 Inserting Data 177
Understanding Data Insertion ................................................................. 177
Inserting Complete Rows ........................................................................ 177
Inserting Multiple Rows ........................................................................... 181
Inserting Retrieved Data .......................................................................... 183
20 Updating and Deleting Data 187
Updating Data ............................................................................................ 187
Deleting Data ............................................................................................. 189
Guidelines for Updating and Deleting Data ...................................... 190
21 Creating and ManipulatingTables 193
Creating Tables .......................................................................................... 193
Updating Tables ......................................................................................... 203
Deleting Tables .......................................................................................... 205
Renaming Tables ....................................................................................... 205
22 Using Views 207
Understanding Views ............................................................................... 207
Using Views ............................................................................................... 210
23 Working with Stored Procedures 217
Understanding Stored Procedures .......................................................... 217
Why Use Stored Procedures ................................................................... 218
Using Stored Procedures .......................................................................... 219
24 Using Cursors 231
Understanding Cursors .............................................................................. 231
Working with Cursors ............................................................................... 232
25 Using Triggers 241
Understanding Triggers ............................................................................ 241
Creating Triggers ........................................................................................ 242
Dropping Triggers ...................................................................................... 243
Using Triggers ............................................................................................. 244
26 Managing TransactionProcessing 249
Understanding Transaction Processing ................................................ 249
Controlling Transactions .......................................................................... 252
27 Globalization and Localization 257
Understanding Character Sets and Collation
Sequences .............................................................................................. 257Working with Character Set and Collation
Sequences .............................................................................................. 258
28 Managing Security 263
Understanding Access Control .............................................................. 263
Managing Users ......................................................................................... 264
29 Database Maintenance 273
Backing Up Data ....................................................................................... 273
Performing Database Maintenance ...................................................... 274
Diagnosing Startup Problems ................................................................. 275
Review Log Files ...................................................................................... 275
30 Improving Performance 277
Improving Performance ............................................................................ 277
A Getting Started with MySQL 281
What YouÕll Need ..................................................................................... 281
Obtaining the Software ............................................................................ 282
Installing the Software ............................................................................. 282
Preparing for Your Chapters ................................................................... 283
B The Example Tables 285
Understanding the Sample Tables ........................................................ 285
Creating the Sample Tables ................................................................... 290
C MySQL Statement Syntax 293
ALTER TABLE ............................................................................................. 293
COMMIT ........................................................................................................ 294
CREATE INDEX .......................................................................................... 294
CREATE PROCEDURE .............................................................................. 294
CREATE TABLE .......................................................................................... 294
CREATE USER ............................................................................................ 295
CREATE VIEW ............................................................................................ 295
DELETE ......................................................................................................... 295
DROP ............................................................................................................. 295
INSERT .......................................................................................................... 296
INSERT SELECT .......................................................................................... 296
ROLLBACK .................................................................................................. 296
SAVEPOINT ................................................................................................. 296
SELECT ......................................................................................................... 297
START TRANSACTION ............................................................................ 297
UPDATE ....................................................................................................... 297
D MySQL Datatypes 299
String Datatypes ......................................................................................... 300
Numeric Datatypes ................................................................................... 301
Date and Time Datatypes ....................................................................... 303
Binary Datatypes ....................................................................................... 304
E MySQL Reserved Words 305
Index 309
This book includes free shipping!
- Request an Instructor or Media review copy.
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
