Murach's MySQL

51%2bfhshisal. sl200


19 reviews

Written by Joel Murach

Published by Mike Murach & Associates

May, 2012

612 pages

READ       REVIEWS       DOWLOAD

Description

This practical, hands-on training and reference guide is perfect for developers who need to learn MySQL. Written by Joel Murach, the author of bestselling "Java Servlets and JSP" and "PHP and MySQL" books, this is exactly the database book that web developers should have on their desks. As you would expect, this book shows how to code all of the essential SQL statements for creating and working with a MySQL database. But beyond that, this book also shows how to design a database, including how to use the graphical MySQL Workbench to create an EER model. It shows how to take advantage of the MySQL enhancements that aren't covered in older books, such as foreign keys, transactions, stored procedures, stored functions, triggers, and events. It even presents a whole section on database administrator (DBA) skills, including how to secure and back up databases. And like all Murach books, it uses the distinctive "paired pages" format, which breaks the material into manageable skills to speed up both learning and reference. A great help for MySQL users at any level. Table of Contents Section 1 An introduction to MySQL
Chapter 1 An introduction to relational databases and SQL
Chapter 2 How to use MySQL Workbench and other development tools Section 2 The essential SQL skills
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 code summary queries
Chapter 6 How to code subqueries
Chapter 7 How to insert, update, and delete data
Chapter 8 How to work with data types
Chapter 9 How to use functions Section 3 atabase 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 tored 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 back up and restore a database

Publish

Title: Murach's MySQL
Author: Joel Murach
Language: English
Length: 612
Edition: 1
Publisher: Mike Murach & Associates
Publication Date: 2012-05-01
ISBN-10: 1890774685
ISBN-13: 9781890774684
NOTICE: BOOK CONTENT AND LINKS HAVE HARVESTED FROM THE INTERNET, YOU MAY GET BROKEN LINK OR COPYRIGHT INFRINGEMENT COMPLAINT. YOU CAN BUY THIS BOOK OR PLEASE MAIL TO MICHAELJBREUER at GMX dot COM TO REPORT ISSUE

Tags