SQL for MySQL Developers: A Comprehensive Tutorial and Reference

石头

作者：Rick F. van der Lans
出版日期：April 30, 2007
出版社：Addison Wesley
页数：1032
ISBN：ISBN-10: 0131497359 ISBN-13: 978-0131497351
文件格式：PDF


Product Description
The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect

MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers,Rick F. van der Lans helps you master this version ofSQL and takeadvantage of its full potential. Using case study examplesand hands-onexercises, van der Lans illuminates every key concept,technique, andstatement–including advanced features that make iteasier to create eventhe most complex statements and programs.

Drawing on decades of experience as an SQLstandards team member and enterprise consultant, he reveals exactly whyMySQL’s dialect works as it does–and how to get the most out of it.You’ll gain powerful insight into everything from basic queries tostored procedures, transactions to data security.

Whether you’re a programmer, Web developer,analyst, DBA, or database user, this book can take you from“apprentice” to true SQL expert. If you’ve used SQL in older versionsof MySQL, you’ll become dramatically more effective–and if you’remigrating from other database platforms, you’ll gain practical mastery fast.

Coverage includes

• Writing queries, including joins, functions, and subqueries
• Updating data
• Creating tables, views, and other database objects
• Specifying keys and other integrity constraints
• Improving efficiency with indexes
• Enforcing security via passwords and privileges
• Embedding SQL statements within PHP programs
• Building stored procedures and triggers
• Using transactions, locking, rollback, and isolation levels
• Utilizing MySQL’s catalog

All of the book’s sample programs are available for download from www.r20.nl.

About the Author
Rick F. van der Lans is author of the classic Introduction to SQL,the definitive SQL guide that database developers have relied on formore than 20 years. He is a consultant, author, and lecturerspecializing in database technology, development tools, datawarehousing, and XML. As managing director of the Netherlands-basedR20/Consultancy, he has advised many large companies on defining theirIT architectures. He chairs the European Meta Data Conference, andwrites columns for several magazines.

bfc_123

bfc_123

pengzhang130

thank you

david2009

thank you, it's good.