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
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.