Forta B. MySQL Crash Course 2ed 2023 torrent

Textbook in PDF format

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.
Introduction
Understanding SQL
Introducing MySQL
Working with MySQL
Retrieving Data
Sorting Retrieved Data
Filtering Data
Advanced Data Filtering
Using Wildcard Filtering
Searching Using Regular Expressions
Creating Calculated Fields
Using Data Manipulation Functions
Summarizing Data
Grouping Data
Working with Subqueries
Joining Tables
Creating Advanced Joins
Combining Queries
Full-Text Searching
Inserting Data
Updating and Deleting Data
Creating and Manipulating Tables
Using Views
Working with Stored Procedures
Using Cursors
Using Triggers
Managing Transaction Processing
Globalization and Localization
Managing Security
Database Maintenance
Improving Performance
Appendix A. Getting Started with MySQL
Appendix B. The Example Tables
Appendix C. MySQL Statement Syntax
Appendix D. MySQL Datatypes