SQL book - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL book

Author

Topic

Tototo1
Starting Member

22 Posts

Posted - 2012-02-16 : 11:51:04

I am new to SQL, and I am wondering if anyone would recommend a book I can buy to learn from or reference to when doing SQL code. There are probably about 100 books out there but I do not know where to start! Any help would be greatly appreciated.

Thanks!

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-16 : 12:00:24

How about Books Online?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

Do you have SQL server Client Tools Installed?

Do you have Access to a Server or are you using Express?

What Version are you using?

I like the unleashed Books...but you may want a more of an intro...but they have that in unleashed as well..the bible is good, and the T-SQL Books

It all depends on what you want to know about?

Development, Admin, BI, Reporting? It's pretty vast

http://www.sqlteam.com/store.aspx

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Tototo1
Starting Member

22 Posts

Posted - 2012-02-16 : 12:33:09

Currently working with SQL 8.00.2039

I will be querying databases and manipulating the data depending on what my collegues need. I can do simple queries and use temp tables but I want to dig in deeper. I am self taught right now so I would like to check out some new features and teach myself some more. Thanks for the info.

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-16 : 12:38:15

Well, un-teach yourself about using temp tables

And if you get stuck, post a question here

I like the Guru's Guide, it's based on an older version, but still is very relevant

You can also look at ItZik's books

http://www.amazon.com/Itzik-Ben-Gan/e/B001IGQENW/ref=s9_dbsim_dt_d0_i2?pf_rd_m=ATVPDKIKX0DER&pf_rd_s=entity-campaign-1&pf_rd_r=043YFNA37G92CP2T28AY&pf_rd_t=201&pf_rd_p=1282919782&pf_rd_i=0201700468

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

robvolk
Most Valuable Yak

15732 Posts

Posted - 2012-02-16 : 13:14:38

quote:
Well, un-teach yourself about using temp tables

Why? Temp tables are wonderful, what's wrong with them?

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-16 : 13:17:46

They are overused and misunderstood?

How many "Solutions" that use a bunch of temp tables (or cursors) when all that was required was to collapse the SQL into 1 nice set based solution?

I've Seen Tons, and Lots of them get posted here

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-16 : 13:58:26

Just because the feature can be abused is no reason not to use it. Just have to learn to use it properly.

Book: SQL 2008 T-SQL fundamentals. Yes, it's for SQL 2008 so there will be portions that are not relevant. It's still an excellent book.

--
Gail Shaw
SQL Server MVP

X002548
Not Just a Number

15586 Posts

Posted - 2012-02-16 : 14:08:00

just like cursors...99.99% of the time you don't need them...so when they get stuck, then "lear'em"

Until then, teach them the right way first

MOO

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-16 : 14:44:19

The right way is to use temp tables when they help (divide and conquer technique) and not to use them when they don't help. Never learn them and you lose the first portion of that entirely.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources