Murach's MySQL (4th Edition)
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.

1109622615
Murach's MySQL (4th Edition)
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.

59.5 In Stock
Murach's MySQL (4th Edition)

Murach's MySQL (4th Edition)

by Joel Murach
Murach's MySQL (4th Edition)

Murach's MySQL (4th Edition)

by Joel Murach

Overview

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.

Product Details

ISBN-13: 9781943873104
Publisher: Mike Murach and Associates, Inc.
Publication date: 10/01/2023
Edition description: 4th Revised ed.
Pages: 652
Product dimensions: 7.90(w) x 9.90(h) x 1.60(d)

About the Author

Joel Murach is the oldest son of publishing pioneer Mike Murach. Joel has been writing and editing books about computer programming for over 30 years now. During that time, he has written extensively on a wide range of Java, .NET, web, and database technologies. He has had best-selling books in all of those categories! In his books, you can see his clear approach to teaching any subject.

Table of Contents

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 backup and restore a database

Chapter 20 How to host a database with AWS


From the B&N Reads Blog
Page 1 of

Related Subjects

Computers
Computers - General & Miscellaneous
General & Miscellaneous Computing
Computers
Computers - General & Miscellaneous
General & Miscellaneous Computing

Customer Reviews