Название: MySQL Crash Course, 2nd Edition (Early Release)
Автор: Ben Forta
Издательство: Addison-Wesley Professional
Год: 2023
Страниц: 387
Язык: английский
Формат: pdf, epub
Размер: 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. 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.

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.

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

This book is for you if:

You are new to SQL.
You are just getting started with MySQL and want to hit the ground running.
You want to quickly learn how to get the most out of MySQL.
You want to learn how to use MySQL in your own application development.
You want to be productive quickly and easily using MySQL without having to call someone for help.