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.
| Author |
Topic |
|
ccwade81
Starting Member
2 Posts |
 Posted - 2010-12-03 : 12:10:18
|
| So, obviously I am new to SQL. I am able to do several simple queries and I've stared at more complex queries for hours and have picked up a lot in the way of syntax. I am looking for some sort of course, book, class or any combination. I learn best when I'm exposed to a theory and a few examples of said theory. Any suggestions on the path to SQL righteousness are greatly appreciated.Thanks! |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-03 : 12:19:34
|
| Joe Celko's books are good but don't know if he has anything very basic.It's very much like set theory so if you've done any of that you'll feel comfortable.It's not very difficult to learn - just think in sets and remember that every statement produces a resultset which can be used in another statement. Don't try to think of fields or values - it's always rows and columns even if it's one of each.Also think of operating on sets to produce a set.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2010-12-03 : 13:21:23
|
| SQL For Dummies is usually pretty good, and is a good refresher for basic stuff. Head First SQL is also pretty good for beginners but I'd recommend browsing it before you buy it.I would also be remiss if I didn't mention Ken Henderson's Guru's Guide books, the one on Transact-SQL is the best. It's a bit advanced but he explains things very well and has excellent examples. |
|
|
|
ccwade81
Starting Member
2 Posts |
Posted - 2010-12-03 : 16:06:30
|
| Thank you guys for responding so quickly. I will definitely check out some of those books. |
|
|
|
kashyap_sql
Posting Yak Master
174 Posts |
Posted - 2010-12-04 : 00:50:47
|
| can u provide any link for the book hope it will very help fullWith RegardsKashyap M |
|
|
|
|
|
|
Need Structured Learning Environment