ISBN 9789350237694,Murach's MySQL Training & Reference

Murach's MySQL Training & Reference



Shroff Publishers & Distributors Pvt Ltd

Publication Year 2012

ISBN 9789350237694

ISBN-10 9350237695

Paper Back

Number of Pages 606 Pages
Language (English)

Computer programming

Today, MySQL is the world's most popular open-source database, especially for web applications. And if you're ready to gain a set of professional MySQL skills, this is the book for you...whether you're a beginner or whether you're an experienced MySQL developer who hasn't had time to master all of its features, especially the ones that have been added in the past few years. For example, you'll learn how to: Write SQL statements that retrieve, insert, update, and delete database data Code complex inner and outer joins, summary queries, and subqueries that do more of the database processing for you so that your applications can do less Handle the problems you typically encounter with various types of data Use MySQL functions for everyday tasks like rounding numbers or formatting dates Use foreign keys to maintain referential integrity Design a database and code the SQL statements that create its tables and indexes...skills that make you a more effective SQL developer, even if these tasks are done by a DBA where you're working Work with an EER model and its related diagrams Create views that simplify data access and improve data security Use stored procedures, custom functions, triggers, and events to improve developer productivity Use transactions to maintain data integrity Handle basic DBA tasks like database configuration, security, and backups Ready to master all of this? Then let Murach's MySQL turn you into a top MySQL developer.

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 Database 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 Stored 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 Appendixes Appendix A How to install the software for this book on Windows Appendix B How to install the software for this book on Mac OS X