Today, MySQL is the world’s most popular open-source database, especially for web applications.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
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:
Ready to master all of this?
Then let Murach’s MySQL turn you into a top MySQL developer
Unless otherwise noted above, most orders ship within 1 to 2 days. We will promptly notify you if there is a stock problem with any items on your order and provide you with an estimated delivery date. If you have a firm need by date, please provide such information in the comment section at checkout.
Page Count (est.): 587
Pub Date: 5/1/2012