当前位置: 首页 > 资源下载 > 数据库 > 查看资源

资源分类
Web开发
Java
.NET
编程语言
数据库
软件工程
图形动画
系统管理
网络通信安全
计算机理论
考试认证
人文百科
文档手册
硬件技术
办公软件

SQL for MySQL Developers: A Comprehensive Tutorial and Reference

SQL for MySQL Developers: A Comprehensive Tutorial and Reference

书名:SQL for MySQL Developers: A Comprehensive Tutorial and Reference

上传:石头

时间:2009-09-06

文件大小:2.62 MB

资源出处:查看资源出处 >>

收藏到网摘: n/a



作者: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 subqueriesUpdating dataCreating tables, views, and other database objectsSpecifying keys and other integrity constraintsImproving efficiency with indexesEnforcing security via passwords and privilegesEmbedding SQL statements within PHP programsBuilding stored procedures and triggersUsing transactions, locking, rollback, and isolation levelsUtilizing MySQL’s catalogAll 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.
Tags:DevelopersReferenceSQLTutorial


相关书籍

  • .NET Framework Standard Library Annotated Reference, Volume 1
  • How to Cheat at Securing SQL Server 2005
  • Learning PHP, MySQL, and JavaScript: A Step-by-Step Guide to Creating Dynamic We
  • Ruby on Rails Web Mashup Projects: A step-by-step tutorial to building web mashu
  • PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

评论 (0) All

登陆 | 还没注册?