Recent Topics
Break in...kind of
by stuka
05/24/17 12:35 PM
Fuel economy of oil not so simple?
by TheKracken
05/24/17 12:35 PM
1999 Infiniti I30, UOA ATF, 131k
by DzoG20
05/24/17 12:33 PM
Costs aside, do you like private school for kids ?
by Mr Nice
05/24/17 11:30 AM
2012 Subaru Impreza CVT hatch 100k mile review
by deanm11
05/24/17 11:15 AM
2002 Ford Crown Victoria 200k, 5.2 on Maxlife 5W20
by Colt45ws
05/24/17 11:05 AM
This is why I don't let anybody else change my oil
by Mossyoakglock
05/24/17 10:56 AM
Tuner for Chevrolet Tahoe?
by pacem
05/24/17 10:31 AM
Saw MotorKote @ Wally for $27.00
by Speak2Mountain
05/24/17 10:00 AM
Perfect SAT
by Virtus_Probi
05/24/17 09:41 AM
When's the last time you seen one of these on the
by 5AcresAndAFool
05/24/17 09:36 AM
My Wal-Mart has stopped carrying Maxlife atf
by NavyVet88
05/24/17 09:23 AM
Lexus Toyota V6's - Fitment for 2GR-FSE vs. 2GR-FE
by BeerLube
05/24/17 09:16 AM
Denso 90915-YZZF1 Oil filter cut open 5k interval.
by 5AcresAndAFool
05/24/17 08:18 AM
Beware of your surroundings
by CourierDriver
05/24/17 08:03 AM
Online viscosity calculators
by paulri
05/24/17 07:59 AM
Recalls: Audi, Chevy, Honda, Jeep, VW, MB, Toyota
by wemay
05/24/17 07:37 AM
Can't Email or Mail Banks?
by Ducked
05/24/17 06:15 AM
STP basic blue
by Camprunner
05/24/17 06:07 AM
2017 Silverado 5.3 filter ?
by dabo72
05/24/17 06:03 AM
Newest Members
Regina, stuka, rodekyll, nocarb, sebin
61653 Registered Users
Who's Online
99 registered (BoiseRob, andyd, 1JZ_E46, Astro14, 28oz, bunnspecial, 11 invisible), 2547 Guests and 10 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
61653 Members
66 Forums
265555 Topics
4388263 Posts

Max Online: 3590 @ 01/24/17 08:07 PM
Donate to BITOG
Topic Options
#3453246 - 08/12/14 09:15 AM Good SQL book for beginners?
Hokiefyd Offline


Registered: 06/24/04
Posts: 14505
Loc: Top of Virginia
I have long dabbled with light computer programming (Turbo Pascal, VB, C++), but gave that up in college. However, I have found many uses for database development at work, and have what I would call a moderate level of experience with Access. I can deconstruct a written SQL statement and modify it for my needs, but I'd be hard-pressed to write one from scratch.

I've lately been encouraged to move some of my database tables to SQL server. And I'd like to learn it. They are going to install SQL Server Management Studio on my machine later this week. I'd like to find a book that goes over SQL database design and management and some SQL programming as well.

The "xxx for Dummies" book series is highly popular, but I don't know if it's always the best resource. For you SQL people out there, please point me to a few resources (hopefully in hard copy, that I can purchase and use over time) that would be appropriate for an SQL beginner.

Top
#3453265 - 08/12/14 09:38 AM Re: Good SQL book for beginners? [Re: Hokiefyd]
lugNutz Offline


Registered: 05/19/13
Posts: 418
Loc: Somewhere in IL
I have not really read any SQL books, but I can lend you a hand in this. Check out this site: it-ebooks

Pick a few different ones relating to SQL and buy the one that you like - or don't if you want to be a thief, lol. I have often used this to find new resources when needed, until I found one that I liked.

I prefer to find books that are published by O'reilly Media. For some reason that have some good stuff! O'Reilly
_________________________
'05 Ford Explorer XLT | 96k | WIX 51372 | FS 5w-30

Top
#3453305 - 08/12/14 10:19 AM Re: Good SQL book for beginners? [Re: Hokiefyd]
bepperb Offline


Registered: 01/10/08
Posts: 4966
Loc: Milwaukee, WI
It might be easier to buy a book written for the database system you'll be using. As someone who uses Oracle, MS and Sybase on a daily basis the differences in syntax between them are minor, but sometimes difficult for someone just getting started.

If you had to choose I'd go with MS sql since it's free for what you sound like you'll use it for. MySQL is as well, though we can't seem to get that past any auditing as it's open source.
_________________________
2004 Highlander 2.4
2011 Toyota Sienna 3.5
Recently Gone:
2006 Accord 2.4l K24A8
1993 Kawi EX 500

Top
#3453322 - 08/12/14 10:36 AM Re: Good SQL book for beginners? [Re: Hokiefyd]
redhat Online   content


Registered: 12/07/12
Posts: 1548
Loc: Buffalo Metro Area
I bought a used SQL 2000 book on eBay. It has been a good learning tool for me. SQL is very powerful and IMO if you are proficient in it, a lot of doors are unlocked.
_________________________
09 Accord Sedan 5MT - Mix T6 0W-40/QSGB 5W-20, MOS2, XG7317, 122k
14 Civic EX Coupe - NAPA Syn. 0W-20, L14610, 42k

Top
#3453325 - 08/12/14 10:41 AM Re: Good SQL book for beginners? [Re: bepperb]
pandus13 Online   content


Registered: 08/12/11
Posts: 1766
Loc: Chicago,IL,USA
Originally Posted By: bepperb
It might be easier to buy a book written for the database system you'll be using. As someone who uses Oracle, MS and Sybase on a daily basis the differences in syntax between them are minor, but sometimes difficult for someone just getting started.

If you had to choose I'd go with MS sql since it's free for what you sound like you'll use it for. MySQL is as well, though we can't seem to get that past any auditing as it's open source.


OP, he is referring to the MS Sql BOL (Books Online) Help.
OP, please learn the difference between select * from <large amount of data with lots of columns table> and select column 1,2,3 from <same large table> where yadda-yadda.
could be difference between staring at the screen seconds instead of 2 days...
_________________________
13 Mazda5
08 Toyota Yaris Sedan
04 Elantra (sold)
95 accent (sold)
95 mystique (sold)
97 concorde (gone)

Top
#3453355 - 08/12/14 11:05 AM Re: Good SQL book for beginners? [Re: Hokiefyd]
rjundi Offline


Registered: 03/16/04
Posts: 7256
Loc: USA
I never succeed much with books.

Google works for me mostly but I do have a basis from college(took C and Pascal on unix using vi as editor!):


http://www.w3schools.com/sql/

There are sites with live servers to play with too. Good luck. You can also use some decent tools to generate SQL and then learn from it too. They are not perfect but give you hint at least what to look up.
_________________________
---

Top
#3453408 - 08/12/14 11:57 AM Re: Good SQL book for beginners? [Re: rjundi]
Hokiefyd Offline


Registered: 06/24/04
Posts: 14505
Loc: Top of Virginia
Originally Posted By: rjundi
Google works for me mostly but I do have a basis from college(took C and Pascal on unix using vi as editor!)


Mr. Google has taught me many things over the years, but what I feel that I miss from it are the foundational aspects. I Google for (and hit) all of the little 5- and 10-meter targets that I'm working on at that time. So I get bits and pieces of a greater concept, and I end up with code that achieves the mission, but without a mastery of the fundamentals behind it.

bepperb, sorry; yes, we use Microsoft SQL server here.

Top
#3453641 - 08/12/14 03:10 PM Re: Good SQL book for beginners? [Re: Hokiefyd]
oldoak2000 Offline


Registered: 07/23/14
Posts: 28
Loc: tx
1. sign up here for free: http://www.sqlservercentral.com (be sure to checkout the FORUMS section)

2. buy any old book on sql server 7 (or sql8, or sql2000, or sql2005/08/12). the basics are the same

3. download sqlserverexpress with full tool set (free @ Microsoft.com) onto your home computer, and start playing with it.

4. Easily import some of your Access data into it, and start playing around with it; Once you figure the basics out w sql, you will Laugh at Access and wonder why you ever messed with such lousy junk.

Top