473,320 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Please recommend SQL book with excercises

I have beginner knowledge of SQL (I use MS SQL Server). I recently finished
"SQL for dummies" book and now need something more advanced with a lot of
exercises writing queries.

Can anyone recommend such a book?
Jun 27 '08 #1
2 3649
On Apr 13, 10:45*am, "vmnvmcxbv" <ruyeir...@fhsdkhf.netwrote:
I have beginner knowledge of SQL (I use MS SQL Server). I recently finished
"SQL for dummies" book and now need something more advanced with a lot of
exercises writing queries.

Can anyone recommend such a book?
When I first started learning SQL, there were two books that I thought
were excellent:

John Patrick's SQL Fundamentals, a workbook with lots of hands-on
exercises. Material was good, but his editor for the first edition
should have been replaced; there were mistakes everywhere, including
an editor's note embedded in the actual text (I believe the second
edition corrected these problems).
http://www.amazon.com/SQL-Fundamenta...cm_cr-mr-title

Ben Forta's 10 Minute Guide to SQL is also an excellent guide for
beginners; he really focuses on the language and concepts without
getting too involved in database maintenance issues.
http://www.amazon.com/Sams-Teach-You...8104000&sr=1-1
HTH,
Stu
Jun 27 '08 #2
>Can anyone recommend such a book? <<

Rick van der Lans INTRODUCTION TO SQL has been around for 20+ years
and each chapter has lots of simple SQL exercises with answers.
Warning! He uses some dialect (MySQL mostly) in places, so you have
to be careful.

My SQL PUZZLES & ANSWERS describes itself in the title. You get a
problem, then a set of possible queries with a discussion of each
answer. It just got translated into Japanese and Chinese. I had two
really good editors who fixed minor errors and added some more
solutions of their own. If you read Japanese or Chinese, these are
better versions than the English edition. Warning! A lot of the
puzzles are weird, tricky things that make good puzzles, but are not
the sort of thing you would want to have in production code.

Since you are still a beginner, I would get a copy of SQL FOR SMARTIES
for advanced programming tips. But you might want to start with
THINKING IN SETS; the big problem that newbies have is switching from
file systems and procedural coding to sets and declarative
programming. Remember how hard is was to get your head around
recursion? It is that kind of mindset change.
Jun 27 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: __frank__ | last post by:
What do you think about the following book: "C How to Program", 4th edition, ISBN: 0131426443 I'm a novice. Thanks in advance.
11
by: Robert Schuldenfrei | last post by:
I am an older person trying to learn C# just for the fun of it. I am a veteran of older style languages (COBOL, FORTRAN, etc.) and I want to learn an Object Orientated language. Currently working...
3
by: Mark Broadbent | last post by:
could somebody please recommend a good book to prepare for exam Exam 70-320*: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework . One that...
11
by: Alan Silver | last post by:
Hello, I am a seasoned Classic ASP programmer who is interested in learning ASP.NET. I bought a book (Que's Special Edition Using ASP.NET) which is complete rubbish, and would like a...
3
by: Johann Schuler | last post by:
I am learning C#. Right now I am working my way thru "Microsoft C# .NET Step by Step by John Sharp and Jon Jagger." After this I want to get into more depth. Eventually I want to pass the C#...
5
by: Y2J | last post by:
I am working through this book on C++ programming, the author is speaking of using linked lists. He gave and example which I found confusing to say the least. So I rewrote the example in a way that...
3
by: buddha6279 | last post by:
Hello, I am new to C++ and thus far have been able to do all the program excercises in my book, but I can't get the following program scenario to build and execute. I am trying to calculate a...
4
by: subrahmanyaam | last post by:
Guys, Assume a dummy person wants to learn vb.net, can you suggest a book that would be ideal for any lay person to refer the book and start the programming, start development mini programs. I know...
12
by: Eps | last post by:
I am starting a new job that involves programming in c# and using ASP.net. I have some experience with c# but have little knowledge of ASP, I would like to get a book about each so I can get some...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.