"If you ever wanted to learn to use MySQL, write SQL queries, create database elements, then this is the book to pick up." (JavaRanch.com) "I was amazed at how much information was packed into this book." "As a developer with almost 10 years of MySQL experience, I still picked up a lot of new detail on things I thought I knew." "I found this to be a great introductory book to MySQL." "Has already proven to be helpful in solving several challenges I've encountered on my current MySQL project." That's a sampling of what developers said about the 1st Edition of Murach's MySQL. Now, this 2nd Edition has been updated and improved throughout. As a result, it's easier than ever to use for learning MySQL from scratch, for switching to MySQL from another flavor of SQL (like MS SQL Server or Oracle), or for quickly looking up the forgotten details that are so essential as you develop database applications. Section 1 introduces you to relational databases and SQL, shows you how to use the graphical MySQL Workbench to work with a MySQL database, and teaches you to code SQL queries to retrieve, add, update, and delete data in a MySQL database. Section 2 goes deeper into querying, showing you how to work with summary queries, subqueries, data types, and functions. Section 3 shows you how to design a MySQL database using an EER model, implement the design, and create views. Section 4 shows how to create stored procedures that provide functionality similar to procedural programming languages like PHP, Java, C++, C#, and VB. And Section 5 introduces you to database administration tasks like securing and backing up database data. Whether you start from the beginning or jump in anywhere, it's a great guide for MySQL users at any level.
Murach's MySQL, 2nd Edition
#ad
Author: Joel Murach
Binding: Paperback
ISBN: 9781890774820
Details:
Author: Joel Murach
Brand: Mike Murach Associates
Edition: 2nd
Binding: Paperback
Number Of Pages: 612
Release Date: 02-03-2015
Part Number: 43171-600701
Package Dimensions: 10.2 x 8.0 x 1.6 inches Languages: English