找回密码
 注册
搜索
热搜: java php web
查看: 708|回复: 9

SQL for MySQL Developers: A Comprehensive Tutorial and Reference

[复制链接]
发表于 2009-9-6 11:01:07 | 显示全部楼层 |阅读模式
本帖最后由 石头 于 2009-9-6 11:06 编辑



作者: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.

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有账号?注册

×
发表于 2009-9-8 10:03:22 | 显示全部楼层
回复

使用道具 举报

发表于 2009-9-8 10:05:07 | 显示全部楼层
回复

使用道具 举报

发表于 2009-11-13 00:30:01 | 显示全部楼层
thank you
回复

使用道具 举报

发表于 2010-3-6 16:34:11 | 显示全部楼层
thank you, it's good.
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

Archiver|手机版|小黑屋|软晨网(RuanChen.com)

GMT+8, 2024-11-25 23:57

Powered by Discuz! X3.5

Copyright © 2001-2023 Tencent Cloud.

快速回复 返回顶部 返回列表