Re: What's the best SQL book for an intermediate level database programmer?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Joyjit Mukherjee (joyjit_mukherjee_at_hotmail.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 13:54:14 +0530

Hi,

My recomendations

For Programming: - Ttry Professional Sql Server 2000 Programming by Wrox
Press
(http://www.amazon.com/exec/obidos/tg/detail/-/1861004486/103-5668607-278144
7?v=glance)

For DBA / Architecture: - Inside Sql Server 2000
(http://www.amazon.com/exec/obidos/ASIN/0735609985/qid=1101284564/sr=2-1/ref
=pd_ka_b_2_1/103-5668607-2781447)

However, the internet is the best place to get most updated information so,
be tuned.

Regards
Joyjit

<jklimek@gmail.com> wrote in message
news:1101270341.406960.13340@z14g2000cwz.googlegroups.com...
> In May of this year I graduated from Penn State with a BS in IST
> (Information Sciences and Technology). Right after graduation I got a
> database programming job with a company that uses Delphi 6 and MS SQL
> Server 2000.
>
> I've been working with this company for six months now but I'm still
> not very good with SQL. I can do basic SQL queries and table joins (as
> well as use datetime functions and cursors), but I'd say I'm only at an
> intermediate level (at best).
>
> So... I'm looking to learn more about SQL. I'm guessing a good SQL
> reference book would help, but I'd really prefer a good book that
> actually teaches you and guides you along. The only problem is that I
> don't want a basic/beginner level SQL book since I already know all of
> the basics.
>
> Can anybody recommend anything for me?
>
> Thanks!
>

Relevant Pages

  • Re: dbdebunk Quote of Week comment
    ... But SQL does not have a pointer data type or the mechanisms to handle pointer operators, garbage collection and housekeeping, so 20+ years ago the original Sybase SQL Server exposed an integer that can map back to the contiguous storage model used under the covers. ... More and more programmers who have absolutely no database training are ... Most of them simply start programming SQL as if it were their native ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re:Job interviews
    ... 2 Years SQL and Or Oracle and familiarity with Crystal ... tool names has little to do with programming modules using SQL Server), ... discussion of technical knowledge in a core area in which you are looking to ... enough relevance on core issues which the interviewee must know to do the ...
    (microsoft.public.dotnet.languages.vc)
  • Re: How to make downloadable source code available to website visitors?
    ... >> star rating after you bolstered it with your own 5 star rating. ... >> incorrect in the Beginning SQL Programming book was incorrect. ... >> by John Kauffman, Brian Matsik, Kevin Spencer, Ian Herbert, Sakhr ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Searching OO Associations with RDBMS Persistence Models
    ... I agree those pesky DB language do tend to thrash a lot. ... Both SQL and C++ can be extended with custom data types. ... The RDB has no idea that this is the ... The programming language is also always a detail. ...
    (comp.object)
  • Re:Job interviews
    ... 2 Years SQL and Or Oracle and familiarity with Crystal ... tool names has little to do with programming modules using SQL Server), ... discussion of technical knowledge in a core area in which you are looking to ... enough relevance on core issues which the interviewee must know to do the ...
    (microsoft.public.dotnet.languages.csharp)