| |
 |
| |
 |
|
5.0 of 5.0 |
|
|
MySQL Crash Course (Sams Teach Yourself in 10 Minutes) |
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.
|
|
|
Publisher:
Sams
Author:
Ben Forta
Release Date: 2005-12-22
ISBN/EAN: 0672327120 / 9780672327124
New Price: $9.47 /
Used Price: $8.50 /
Collectible Price: n.a.
Buy
it Now!
Average Rating: 5.0
Number of
Reviews: 18 |
| |
|
|
| clear concise and comprehensive | Rating: | If you are considering MySQL you may not know how, but you are not a dummy. This book is not for dummys in that it doesn't patronize nor take you into convoluted scenarios, this book is for the reasonably intelligent who want to do stuff. What a blessing.
I was familiar with databases having worked with MS Access, but I had never worked with SQL. This book hit the spot in showing me what I needed to know to get going. I am now using MySQL successfully with a Java/Struts front end. While I found a few small gaps in this book, it has helped tremendously in my learning journey in that it gets to the point with minimum emotional overhead and verbosity, unlike MySQL (4th Edition) (Developer's Library) which I have found to be pretty useless and weighty after reading Forta's book.
This book has clear, short, well labeled chapters to find what you need. Highly recommended. | | Total Votes: 1, Helpful Votes: 1, Date: 2008-09-26 | | | | I learned a lot from this book. | Rating: | I had always had problems with trying to figure out how to use Sub Selects. Now I feel silly for not "getting it" quicker. This book has been a big help in me learning about the capabilities of MySQL in general.
Money very well spent.
This is also a great book for those just wanting to learn SQL. The examples are great.
| | Total Votes: 0, Helpful Votes: 0, Date: 2008-09-02 | | | | Great for databases in general, falls apart on administrivia | Rating:  | | 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. | | Total Votes: 2, Helpful Votes: 2, Date: 2008-08-21 | | | | Good for Beginners | Rating: | As others have said, this is a great book for beginners, whether in MySQL or in databases in general. Because I have a lot of database experience, I went throught it very quickly.
When I started to apply some of the techniques I learned to existing applications, I found out VERY quickly that this is insufficient as a reference. Each topic has enough hands-on examples to give you a start, but not nearly enough depth to use for looking things up.
I thought that Appendix B on creating the sample tables might have been a little abbreviated for the novice user. It refers to Chapter 2 to create a new datasource, but I think it was a little confusing jumping back and forth between the appendix and the chapter. This might be better as an exercise right in the chapter.
Overall, I would recommend this book as a starting point. | | Total Votes: 1, Helpful Votes: 1, Date: 2008-03-13 | | | | A great book, easy to read, lots of information. | Rating: | If MySQL will suite your needs then this book is for you. I read the book cover-to-cover in my downtime at work over a few days and walked away with a solid understanding of MySQL.
Unfortunately MySQL isn't the most mature database solution, but if it's good enough for your project, then this is a great resource. | | Total Votes: 3, Helpful Votes: 3, Date: 2007-10-16 | | | | clear concise and comprehensive | Rating: | If you are considering MySQL you may not know how, but you are not a dummy. This book is not for dummys in that it doesn't patronize nor take you into convoluted scenarios, this book is for the reasonably intelligent who want to do stuff. What a blessing.
I was familiar with databases having worked with MS Access, but I had never worked with SQL. This book hit the spot in showing me what I needed to know to get going. I am now using MySQL successfully with a Java/Struts front end. While I found a few small gaps in this book, it has helped tremendously in my learning journey in that it gets to the point with minimum emotional overhead and verbosity, unlike MySQL (4th Edition) (Developer's Library) which I have found to be pretty useless and weighty after reading Forta's book.
This book has clear, short, well labeled chapters to find what you need. Highly recommended. | | Total Votes: 1, Helpful Votes: 1, Date: 2008-09-26 | | | | I learned a lot from this book. | Rating: | I had always had problems with trying to figure out how to use Sub Selects. Now I feel silly for not "getting it" quicker. This book has been a big help in me learning about the capabilities of MySQL in general.
Money very well spent.
This is also a great book for those just wanting to learn SQL. The examples are great.
| | Total Votes: 0, Helpful Votes: 0, Date: 2008-09-02 | | | | Great for databases in general, falls apart on administrivia | Rating: | | 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. | | Total Votes: 2, Helpful Votes: 2, Date: 2008-08-21 | | | | Good for Beginners | Rating: | As others have said, this is a great book for beginners, whether in MySQL or in databases in general. Because I have a lot of database experience, I went throught it very quickly.
When I started to apply some of the techniques I learned to existing applications, I found out VERY quickly that this is insufficient as a reference. Each topic has enough hands-on examples to give you a start, but not nearly enough depth to use for looking things up.
I thought that Appendix B on creating the sample tables might have been a little abbreviated for the novice user. It refers to Chapter 2 to create a new datasource, but I think it was a little confusing jumping back and forth between the appendix and the chapter. This might be better as an exercise right in the chapter.
Overall, I would recommend this book as a starting point. | | Total Votes: 1, Helpful Votes: 1, Date: 2008-03-13 | | | | A great book, easy to read, lots of information. | Rating: | If MySQL will suite your needs then this book is for you. I read the book cover-to-cover in my downtime at work over a few days and walked away with a solid understanding of MySQL.
Unfortunately MySQL isn't the most mature database solution, but if it's good enough for your project, then this is a great resource. | | Total Votes: 3, Helpful Votes: 3, Date: 2007-10-16 | | | | clear concise and comprehensive | Rating: | If you are considering MySQL you may not know how, but you are not a dummy. This book is not for dummys in that it doesn't patronize nor take you into convoluted scenarios, this book is for the reasonably intelligent who want to do stuff. What a blessing.
I was familiar with databases having worked with MS Access, but I had never worked with SQL. This book hit the spot in showing me what I needed to know to get going. I am now using MySQL successfully with a Java/Struts front end. While I found a few small gaps in this book, it has helped tremendously in my learning journey in that it gets to the point with minimum emotional overhead and verbosity, unlike MySQL (4th Edition) (Developer's Library) which I have found to be pretty useless and weighty after reading Forta's book.
This book has clear, short, well labeled chapters to find what you need. Highly recommended. | | Total Votes: 1, Helpful Votes: 1, Date: 2008-09-26 | | | | I learned a lot from this book. | Rating: | I had always had problems with trying to figure out how to use Sub Selects. Now I feel silly for not "getting it" quicker. This book has been a big help in me learning about the capabilities of MySQL in general.
Money very well spent.
This is also a great book for those just wanting to learn SQL. The examples are great.
| | Total Votes: 0, Helpful Votes: 0, Date: 2008-09-02 | | | | Great for databases in general, falls apart on administrivia | Rating: | | 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. | | Total Votes: 2, Helpful Votes: 2, Date: 2008-08-21 | | | | Good for Beginners | Rating: | As others have said, this is a great book for beginners, whether in MySQL or in databases in general. Because I have a lot of database experience, I went throught it very quickly.
When I started to apply some of the techniques I learned to existing applications, I found out VERY quickly that this is insufficient as a reference. Each topic has enough hands-on examples to give you a start, but not nearly enough depth to use for looking things up.
I thought that Appendix B on creating the sample tables might have been a little abbreviated for the novice user. It refers to Chapter 2 to create a new datasource, but I think it was a little confusing jumping back and forth between the appendix and the chapter. This might be better as an exercise right in the chapter.
Overall, I would recommend this book as a starting point. | | Total Votes: 1, Helpful Votes: 1, Date: 2008-03-13 | | | | A great book, easy to read, lots of information. | Rating: | If MySQL will suite your needs then this book is for you. I read the book cover-to-cover in my downtime at work over a few days and walked away with a solid understanding of MySQL.
Unfortunately MySQL isn't the most mature database solution, but if it's good enough for your project, then this is a great resource. | | Total Votes: 3, Helpful Votes: 3, Date: 2007-10-16 | | | | clear concise and comprehensive | Rating: | If you are considering MySQL you may not know how, but you are not a dummy. This book is not for dummys in that it doesn't patronize nor take you into convoluted scenarios, this book is for the reasonably intelligent who want to do stuff. What a blessing.
I was familiar with databases having worked with MS Access, but I had never worked with SQL. This book hit the spot in showing me what I needed to know to get going. I am now using MySQL successfully with a Java/Struts front end. While I found a few small gaps in this book, it has helped tremendously in my learning journey in that it gets to the point with minimum emotional overhead and verbosity, unlike MySQL (4th Edition) (Developer's Library) which I have found to be pretty useless and weighty after reading Forta's book.
This book has clear, short, well labeled chapters to find what you need. Highly recommended. | | Total Votes: 1, Helpful Votes: 1, Date: 2008-09-26 | | | | I learned a lot from this book. | Rating: | I had always had problems with trying to figure out how to use Sub Selects. Now I feel silly for not "getting it" quicker. This book has been a big help in me learning about the capabilities of MySQL in general.
Money very well spent.
This is also a great book for those just wanting to learn SQL. The examples are great.
| | Total Votes: 0, Helpful Votes: 0, Date: 2008-09-02 | | | | Great for databases in general, falls apart on administrivia | Rating: | | 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. | | Total Votes: 2, Helpful Votes: 2, Date: 2008-08-21 | | | | Good for Beginners | Rating: | As others have said, this is a great book for beginners, whether in MySQL or in databases in general. Because I have a lot of database experience, I went throught it very quickly.
When I started to apply some of the techniques I learned to existing applications, I found out VERY quickly that this is insufficient as a reference. Each topic has enough hands-on examples to give you a start, but not nearly enough depth to use for looking things up.
I thought that Appendix B on creating the sample tables might have been a little abbreviated for the novice user. It refers to Chapter 2 to create a new datasource, but I think it was a little confusing jumping back and forth between the appendix and the chapter. This might be better as an exercise right in the chapter.
Overall, I would recommend this book as a starting point. | | Total Votes: 1, Helpful Votes: 1, Date: 2008-03-13 | | | | A great book, easy to read, lots of information. | Rating: | If MySQL will suite your needs then this book is for you. I read the book cover-to-cover in my downtime at work over a few days and walked away with a solid understanding of MySQL.
Unfortunately MySQL isn't the most mature database solution, but if it's good enough for your project, then this is a great resource. | | Total Votes: 3, Helpful Votes: 3, Date: 2007-10-16 | | |
|
|
|
|
