Database stuff
Facts, Links, Opinions,
Heroes & Theories

Access, Cold Fusion,
SQL, Web Databases

Search
©1997 by Charles M. Carroll. All rights reserved. Send comments, gripes, additions to cc@thebestweb.com
DBs + Web 7/16SQL syntax 7/18MS SQL Server 8/10CC Opinions
Access Links 7/18Mr. Access7/16Access Add Ons 7/16Heroes 7/18
Oracle links 8/14The Future?DAO, RDO, ADO, ODBC 6/22

SQL Server On-Line Tutorials

http://w3.one.net/~jhoffman/sqltut.htm has a great on-line tutorial.

http://phoenix.ucr.edu/mis/bsad170/Lectures/Lect9/sld012.htm also.

Steven Wynkoop has built the awe-inspiring Wynkoop Pages are a tremendous resource and include THE SQL Server FAQ and other great information on NT, BackOffice and Web Development. Check out http://www.swynk.com/ and read his FAQs, tips and tricks and then go to the bookstore and buy some of Steve Wynkoop’s excellent books.http://www.amazon.com/exec/obidos/Author=Wynkoop, Stephen has all his books at Amazon Bookstore. An online version of the Que Special Edition of Using SQL server is athttp://www.mcp.com/que/developer_expert/seusql/toc.htm. The entire book is online there.

SQL Server Books Recommened By Various Web Readers

“Instant SQL Programming” by Joe Celko. Barnes and Noble’s carries it for about 30 bucks. its a good reference on general SQL, as well as some TSql stuff.

It may be a little dated, and not specific to MS-SQL, but Derek Odegard derek@schwa.com loves The Practical SQL Handbook by Bowman, Emerson & Darnovsky as the best technical book they have ever read on any topic. So I’d recommend getting this book as a general language reference, as well as a second book to fill out the missing Microsoft-specific stuff.

Doug Miller (dmiller@DEAKIN.EDU.AU) says “If you are a little more advanced than a rank beginner, I recommend: SQL for Smarties by Joe Celko. Iit’s got some really useful code examples for a wide range of ‘awkward’ situations.

Michael Coring michael@oara.org likes Fabian Pascal’s “understanding relational databases” published by john wiley & sons. btw, chris date likes the book too.

Mike Culver (mculver@EXTENCIA.COM) recommends “Hitchhikers Guide to Visual Basic & SQL” by William Vaughn (MS Press).

Walter Cook (wcook@NUTLEYSYSTEMS.COM) says:
If you are learning SQL, I would recommend a generic SQL book called A Visual Introduction to SQL by J. Harvey Trimble and David Chappell, John Wiley & Sons, 1989. It is great for a class because it combines theory and diagrams with the code.

Read my review of this book in Visual Basic Recommended reading.