R20/Consultancy B.V. - The website of Rick F. van der Lans

R20/Consultancy B.V.

The website of Rick F. van der Lans

Home page
Rick F. van der Lans
SQL for MySQL
Intro SQL 4th

Rick F. van der Lans is an independent consultant, teacher, and author, specializing in datawarehousing, software development, Service Oriented Architectures, and database technology. 

Rick van der Lans is an internationally acclaimed lecturer. For the last ten years, he has been presenting professionally, and has lectured in most of the European countries, South America, the USA, and in Australia. He has presented many keynote speeches at international events. 

He is also the author of many articles and various books. 

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 of SQL and take advantage of its full potential. Using case study examples and hands-on exercises, van der Lans illuminates every key concept, technique, and statement (including advanced features) that make it easier 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 MySQL’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 to stored 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 versions of MySQL, you’ll become dramatically more effective–and if you’re migrating from other database platforms, you’ll gain practical mastery fast.

 

Coverage includes

 

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

In October 2006 the fourth edition of the Introduction to SQL was published. This was a major milestone: since the release of the first edition it has been on the market for 20 years. A special website has been created for this book. From this website, the SQL code of all the examples can be downloaded, you can find guidelines for installing the software and the example database, and other issues related to the book are included.

 

 

Do you want to get in touch with R20/Consultancy and/or Rick F. van der Lans?

Telephone (+31) 70-3978466
Fax (+31) 70-4040976
Postal address Karperdaal 60, 2553 PJ Den Haag, The Netherlands
Email info@r20.nl 
 

 

If you have any questions or remarks concerning this website, please send us an email: info@r20.nl.
Copyright © 2009 R20/Consultancy B.V.