Название: MySQL Crash Course, 2nd Edition (Final)
Автор: Ben Forta
Издательство: Addison-Wesley Professional/Pearson Education
Год: 2024
Страниц: 304
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

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. This book will teach you all you need to know to be immediately productive with the latest version of 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.

The fact that you are reading this book indicates that you, somehow, need to interact with databases, and MySQL specifically. And so, before diving into MySQL and its implementation of the SQL language, it is important that you understand some basic concepts about databases and database technologies. Whether you are aware of it or not, you use databases all the time. Each time you select a name from your email address book, you are using a database. When you browse contacts on your phone, you are using a database. If you conduct a search on an Internet search site, you are using a database. When you log into your network at work, you are validating your name and password against a database. Even when you use your ATM card at a cash machine, you are using databases for PIN verification and balance checking.

MySQL is a DBMS; that is, it is database software. MySQL has been around for a long time, and it is now installed and in use at millions of installations worldwide. Why do so many organizations and developers use MySQL? Here are some of the reasons:

Cost: MySQL is open source, and it is usually free to use and even modify the software.
Performance: MySQL is fast—make that very fast.
Trustworthiness: MySQL is used by some of the most important and prestigious organizations and sites, all of which entrust it with their critical data.
Simplicity: MySQL is easy to install and get up and running.
In fact, historically the only real criticism of MySQL has been that it has not always supported the functionality and features offered by other DBMSs. But as new features have been added to each new version, that has changed, and it continues to do so.

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