Murach’s MySQL, 4/e

Murach’s MySQL, 4/e

Default Title
Sale price  Rs. 4,689.00 Regular price  Rs. 5,861.00
Skip to product information
Murach’s MySQL, 4/e

Murach’s MySQL, 4/e

By: Joel Murach |  Publisher: Mike Murach & Associates |  Year: 2023

ISBN: 9781943873104

MRP: Rs. 5,861.00

You Pay: Rs. 4,689.00

You save: Rs. 1,172.00 ( 20% )

MRP: Rs. 5,861.00

You Pay: Rs. 4,689.00

You save: Rs. 1,172.00 ( 20% )

Usually ships in 20-30 days

Reward points: 46 points

🌍 Ships Worldwide

Available for delivery worldwide.

🌍 Available Worldwide

The E-Book is delivered digitally worldwide within 24 hours.

Description

The fourth edition of our best-selling MySQL book works better than ever for teaching SQL and database design. We’ve carefully checked and updated every example to provide you the best possible learning experience. Whether you’re a complete beginner or a SQL expert, you’ll appreciate the easy-to-understand explanations, clear examples, and step-by-step instructions for efficiently using SQL to work with relational databases.

What you’ll learn in this book

Section 1: An introduction to MySQL

In this section, you’ll build a solid foundation by learning the concepts and terms for working with any relational database. In addition, you’ll learn how to use MySQL Workbench to code and run the basic SQL statements for retrieving, adding, updating, and deleting data in a MySQL database. When you’ve completed this section, you’ll be able to continue with any of the other sections in the book.

Section 2: More SQL skills as you need them

This section presents advanced SQL skills for retrieving data from a database including features like summary queries, subqueries, data types, and functions. And the chapters in this section are modular, so you can read them in whatever sequence you prefer.

Section 3: Database design and implementation

This section shows how to design a database and how to implement that design either by coding SQL statements or by using MySQL Workbench. When you’re done, you’ll be able to design and implement your own databases. In addition, this section shows how to create and use views to simplify data access and improve data security.

Section 4: Stored program development

This section takes you from being a good MySQL programmer to a great one by teaching you how to create stored programs. Here, you’ll learn how to use create stored procedures that use MySQL’s procedural language to manage transactions and locking. In addition, you’ll learn how to create user-defined functions, triggers, and events.

Section 5: Database administration

In this section, you’ll learn a starting set of skills for becoming a database administrator (DBA). First, you’ll learn how to secure, back up, and restore a database that’s running on a local server. Then, you’ll learn how to perform most of the same skills on a MySQL database that’s running remotely on Amazon’s cloud computing platform, AWS.

This book is for anyone who wants to learn how to work with a MySQL database, regardless of prior programming experience. This includes…

  • Anyone who wants to learn how to use SQL to work with relational databases
  • Developers who need to write SQL to retrieve and update data in a database
  • Data analysts and scientists who need to retrieve and analyze the data in a database
  • Experienced developers who want to write SQL statements that work and perform better
  • Web developers who need a way to organize large amounts of data and quickly serve it to users
  • Developers who are interested in becoming a database administrator (DBA)

Why you'll learn faster and better with this book

Like all our books, this book is designed to make it as easy as possible for you to learn new skills faster and retain them better. Here are a few of those features:

  • All of the information is presented in paired pages, with the essential syntax, guidelines, and examples on the right page and clear explanations on the left page. This helps you learn faster by reading less.
  • The paired-pages format is ideal for reference when you need to refresh your memory about how to do something.
  • The hundreds of examples present usable code for tasks that you’re likely to need for your own queries.
  • The exercises at the end of each chapter provide a way for you to gain valuable hands-on experience without any extra busywork.

What software you need

Although you can use this book with most versions of MySQL, we recommend that you use:

  • MySQL Community Server 8.0 or higher
  • MySQL Workbench 8.0 or higher

This software can be downloaded for free from MySQL’s website, and appendixes A (Windows) and B (macOS) provide complete instructions for installing it.

What's new in this edition

  • This book has been updated to MySQL 8.0.33, removing deprecated data types and functions and adding new statement options and clauses.
  • Cloud computing, now a fundamental part of the online database landscape, has been given its own chapter, including step-by-step instructions for hosting a MySQL database using Amazon Web Services (AWS).
  • Improved text and code examples make the book more comprehensive and easier to understand and use than ever.
Book Details
Author Joel Murach
Publisher Mike Murach & Associates
ISBN-13 9781943873104
Year 2023
Pages 652
Binding Paperback
Edition Fourth
Country of Origin USA

You may also like