Recommended books
"
SQL Puzzles and Answers
" (Second Edition) written by Joe Celko is an important resource for advanced techique of SQL programming. The book is published by Morgan Kaufmann in it's "Series in Data Management Systems". The book contains 75 puzzles and includes discussion about choosing the most efficient way for solving particular problem. SQL code used in examples fits SQL-92 standard and some solutions uses SQL-99 OLAP features.
see Joe Celko articles on dbazine.com
"
Database Tuning: Principles, Experiments, and Troubleshooting Techniques
" written by Dennis Shasha and Philippe Bonnet. The book shows how specific DBMS physical archetecture can influence decisions about writing SQL code. It also feature stories about implementation of various Data-Mining and OLTP solutions in financial and retail industries.
"
VBA Developer's Handbook
" written by Ken Getz and Mike Gilbert came with a huge library of usefull VBA functions for string manipulation, math and dates calculations. It can take years of programming to write things like that. To mention few examples, I like their
dhTranslate()
from the strings chapter.
SELECT FirstName,
dhTranslate
(FirstName,"abcdefgh","-@_123*=.56") AS Trans_Name
FROM Employees
WHERE EmpNo < 3
The result will be like this:
FirstName
FirstName
john
jo=n
gret
*r2t
As well as function that calculates number of work days between two dates
dhCountWorkdays()
from the times chapter.
"
Mastering Delphi 2005
" is a revised and updated edition of the industry's favorite Delphi programming book written by
Marco Cantu
. This is a kind of unique book that offers huge number of useful code examples and the most complete coverage of Delphi programming techniques. On his site you can allso find free downloads of "Essential Delphi", "Essential Pascal" and "Essential SQL" e-books in pdf format.
sqlexamples.info
