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.   WEB links   theme link description SQL Standards Is SQL a Real Standard Anymore? Article by Michael M. Gorman All IT Discussion Community for Developers and Technology Enthusiasts SQL SQL Programming Directory @ eIT.in Web Resources for SQL Programming Language SQL SQLzoo.net Interactive SQL tutorial SQL DBMS Online comunity for Database issues and solutions: articles, blogs, podcasts and rss feeds. SQL-Server Journey to SQL Authority Pinal Dave. Notes of a SQL Server MVP and Database Administrator PHP,MySQL php-mysql-tutorial.com Simple tutorial about building your own database driven website using PHP & MySQL Web Dir Seekmojo Seekmojo internet web directory of websites, submit website, search engine optimization   Downloads   .mdb file with tables and SQL queries examples used in this site colombo.zip - 75 kb Simple utility for translating tables of variety of formats to XML file: Open data file -> Select table -> Click "Convert To XML" button -> Save AS XML MyXml.zip - 551 kb Sample points of interest in Milan city center: Name, type, latitude, longitude in Tab Delimeted text file. milan_pnt_src.txt - 3 kb URL Submit If you add reference to my site on any web page devoted to SQL or software programming, please send relevant url to e-mail amper102[at]hotmail.com and i'd be glad to place link to your site here.

sqlexamples.info