Murach’s MySQL

Description

«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 Ive encountered on my current MySQL project.»Thats a sampling of what developers said about the 1st Edition of Murachs MySQL.Now, this 2nd Edition has been updated and improved throughout. As a result, its 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.