E-books in Russian and English



<<< >>>

Welcome
(Ashburn, Virginia, United States)

 


Enter · Register · Search

 
 
   
 
 
 
« 2007 »
 123
45678910
11121314151617
18192021222324
252627282930 
 
One Week Top10:
 2  3   4

date: 5 2007 / author: izograv / views: 3061 / comments: 0

SQL for MySQL Developers: A Comprehensive Tutorial and Reference by Rick F. van der Lans



The Most Complete and Practical Guide to MySQL Version 5s 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 take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statementincluding advanced features that make iteasier to create even the most complex statements and programs.

Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQLs dialect works as it doesand how to get the most out of it. Youll gain powerful insight into everything from basic queries to stored procedures, transactions to data security.

Whether youre a programmer, Web developer, analyst, DBA, or database user, this book can take you from apprentice to true SQL expert. If youve used SQL in older versions of MySQL, youll become dramatically more effectiveand if youre migrating from other database platforms, youll 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 MySQLs catalog

All of the books sample programs are available for download from www.r20.nl.


 

Comments: 0

 
 
Year Top:
2011
2010
2009
2008
2007
2006
 
  

 


 

Design/Web/Support/Anti-Leech by izograv @ yandex.ru
Optimized for Firefox | Anti-Leech tested on IE, Firefox, Reget