Murach's MySQL / Joel Murach

Author: Murach, Joel, 1968-
Additional Titles: MySQL
Published: Fresno, CA : Mike Murach & Associates, Inc., [2023]
Copyright Date: ©2023
Edition: 4th edition.
Physical Description: xviii, 626 pages : illustrations ; 26 cm.

Availability

Finding items...

Series

Training & reference

Contents

An introduction to relational databases -- How to use MySQL Workbench and other development tools -- How to retrieve data from a single table -- How to retrieve data from two or more tables -- How to insert, update, and delete data -- How to code summary queries -- How to code subqueries -- How to work with data types -- How to use functions -- How to design a database -- How to create databases, tables, and indexes -- How to create views -- Language skills for writing stored programs -- How to use transactions and locking -- How to create stored procedures and functions -- How to create triggers and events -- An introduction to database administration -- How to secure a database -- How to backup and restore a database -- How to host a database with AWS -- Appendix A: how to set up Windows for this book -- Appendix B: how to set up macOS for this book.

Summary

"The latest edition of Murach's classic MySQL book does a better job than ever of teaching the SQL statements that every database developer should know. Each chapter features clear examples, easy-to-understand explanations, best practices, and helpful tips. To start, this book presents the SQL statements for retrieving and updating the data in a database. These are the most important SQL statements because developers use them every day. Then, it shows how to design a database, how to implement that design, and how to work with views, transactions, stored procedures, functions, triggers, and events. Finally, it presents a starting set of skills for a database administrator (DBA) including how to manage security, how to backup and restore a database, and how to host a MySQL database with Amazon Web Services (AWS). The result? You'll be able to use SQL to work with a MySQL database in a way that's thoroughly professional. Every Murach book guarantees high quality. The realistic examples show how each feature works in context. The exercises at the end of each chapter let you gain valuable hands-on experience. And the distinctive "paired-pages" format is ideal for learning and reference." --

Subject(s)

ISBN

9781943873104 paperback
1943873100 paperback

Note

Includes index.

View MARC record | catkey: 46187142