SQL Book
 

I'm looking for a good book on SQL, anyone have any recommendations. I'm looking for something in depth, I don't want a lot of hand holding, just show me the commands and a piece of code they are used in and I'm happy.

Good refs are all DB-Specific. The O'Rielly MySQL reference is always at my side. If you know your shit I recommend the Pocket Book series O'Rielly does, pocket sized references of all the commands, syntax, operators etc.

That's kind of what I was thinking. I'm just starting to use SQL in one of my classes so I'm basically a beginner, but I catch on to programming languages pretty quickly, and get annoyed rather quickly with handholding in beginning programming books I've read.

Re: SQL Book
 

What context will you be using it in? Oracle, Sybase, MS Access, something else? I suggest getting a book that describes it in the context of the system within which you will be deploying it. I'd just go to the local bookstore and poke through the shelves till you found a couple that seem worthy then review and choose one.

The public library might have some stuff too. And its free.

Good advice from beestie but Public Library refs are usually hopelessly out of date. Nothing could be worse.

If O'Rielly produces a ref for your DB platform I reccomend it. They are references, not 'for dummies' books and often written or co-written by the authors of the programs in question. They tend to be accessiable without skimping on technical details. Fantastic references.

I still have my "Database Systems" book from college. Since it is DBMS independent, I can tell when I'm using DBMS specific syntax. This is often good to know.

I have "Database Design for Mere Mortals" which I like.

Hi, I'm a DBA
 

I work with databases a lot.

Any book by Joe Celko can help you out, as he is the man when it comes to SQL books. www.celko.com.

He also knows how to break down SQL for all the different platforms, not just for Oracle, SQL Server, Access, or mySQL.

Failing that, I recommend the O'Reilly books on SQL.

Mitch

Hey thanks, I'll look into that tomorrow. Found out I have a test in the class next thursday. I think I have a handle on it, but today my professor throws out two commands that are not in our book, and doesn't bother explaining exactly what they do. Can't remember them off the top of my head right now though??

One free, handy reference can be found online.... for basic stuff, www.sqlcourse.com, and for more in-depth stuff, there's www.sqlcourse2.com. There's also an SQL interpreter on the page, so you can try out the commands yourself pretty easily. It mostly covers cross-platform SQL, not so much DB-specific commands.

Why buy a $50 technical manual which rapidly becomes obsolete, when you have access to gobs of webpages full of constantly updated information? I know, I prefer pulp myself, despite the fact that it's an irrational preference when it comes to computer technical manuals, and I have to fight it constantly.

I'm a firm believer in the need for paper, especially when doing coding of any sort. I can't stand switching back and forth between applications to find information when I'm in the middle of writing something. Why I couldn't tell you.

Hmm maybe this is the excuse I've been looking for to invest in dual displays. Of course that requires having SQL on my home computer so that doesn't work.

For a while I had 3 17" 1280x1024 Samsung LCDs, god that was heaven. Keep your general apps on one (IM, email etc), documentation, information etc on another and you're main focus on the middle one, was fantastic. Of course I now virtually live in plane seats so I'm on a single 12" again.

Whenever I actually stay somewhere I'm going to invest in another setup like that. Maybe a main 20" and 2 17".

Yes, multiple displays kick many varieties of ass. I use dual monitors at work and at home, and I feel crippled if I have to use a computer that only has one display. This sort of thing is what I frequently end up using the second monitor for... displaying documentation. Even if you just pick up a cheap 15" or 17" somewhere as the secondary display, it's an improvement.

I too prefer a paper book, but I don't know why.... web-based is so much better... free, up-to-date, searchable, copy-and-pastable... of course eye strain is a factor when a lot of reading is involved.

These days can Win2k manage multiple video cards in the same box without trouble? I mean, can you leave that documentation on your secondary monitor while you go off and play something direct X on the primary monitor?

I've found that it depends on the game. At first I'd always have to disable the secondary display to play full-screen games, which was annoying. Starcraft was one such game, and I I didn't disable monitor 2, the mouse cursor would still wander into that space, and if I inadvertently clicked on the desktop, it would minimize the game. GTA3 had a similar problem.

But on most newer games, I can leave it on without any trouble.