Murach's MySQL,2nd Edition

9781890774820
Murach’s MySQL,2nd Edition
by: Joel Murach
ISBN-10: 1890774820
ISBN-13: 9781890774820
Edition 版本:‏ 2nd
Released: 2015-03-02
Pages: 612
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.