Murach’s MySQL, 3rd Edition

Length: 628 pages
Edition: 3
Language: English
Publisher: Mike Murach & Associates
Publication Date: 2019-03-22
ISBN-10: 1943872368
ISBN-13: 9781943872367
Sales Rank: #539311 (See Top 100 Books)

This practical, hands-on tutorial/reference/guide to MySQL is perfect for beginners, but it also works for experienced developers who aren’t getting the most from MySQL. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of relatively new MySQL features such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a starting set of skills for a database administrator (DBA), including how to secure and back up databases. And like all Murach books, it uses the distinctive “paired pages” format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level.

Cover
Table of Contents
	Simplified Contents
	Expanded Contents
Introduction
Section 1: An introduction to MySQL
	Chapter 1: An introduction to relational databases
	Chapter 2: How to use MySQL Workbench and other development tools
	Chapter 3: How to retrieve data from a single table
	Chapter 4: How to retrieve data from two or more tables
	Chapter 5: How to insert, update, and delete data
Section 2: More SQL skills as you need them
	Chapter 6: How to code summary queries
	Chapter 7: How to code subqueries
	Chapter 8: How to work with data types
	Chapter 9: How to use functions
Section 3: Database design and implementation
	Chapter 10: How to design a database
	Chapter 11: How to create databases, tables, and indexes
	Chapter 12: How to create views
Section 4: Stored program development
	Chapter 13: Language skills for writing stored programs
	Chapter 14: How to use transactions and locking
	Chapter 15: How to create stored procedures and functions
	Chapter 16: How to create triggers and events
Section 5: Database administration
	Chapter 17: An introduction to database administration
	Chapter 18: How to secure a database
	Chapter 19: How to back up and restore a database
Appendixes
	Appendix A
	Appendix B
Index
About Murach