Looking to learn sql, please help - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Looking to learn sql, please help

bargainbloke Avatar
6y, 1m agoPosted 6 years, 1 month ago
Hi guys, I wonder if any of you would be so kind enough to help. I'm looking to learn SQL server and I would like to get some books to help me out but i'm not sure which ones would be best. I'm a total novice at SQL so i'm looking for some beginner books. Is it best to learn Microsoft server or would Oracle or other be best to learn for future jobs prospects???

I have found these two on amazon:

http://www.amazon.co.uk/MCTS-Training-Kit-Implementation-Pro-Certification/dp/073562271X/ref=sr_1_13?ie=UTF8&qid=1287949670&sr=8-13

and

http://www.amazon.co.uk/Beginning-Server-2005-Administration-Guides/dp/0470047046/ref=sr_1_1?s=books&ie=UTF8&qid=1287951140&sr=1-1

If anyone has any better books for me to read please let me know. Also if Microsoft is best to go with, is it best to start with server 2005 or go straight to 2008

Any help would be greatly appreciated. thank you.
bargainbloke Avatar
6y, 1m agoPosted 6 years, 1 month ago
Options

All Comments

(8) Jump to unreadPost a comment
Comments/page:
#1
I'm not expert in SQL but always trust user reviews
also check http://www.betterworldbooks.com for people's review
#2
take up a sql server exam, normally colleges provide this and you sit a microsoft exam. you can do it part time or full time, get a qualification out of it aswell as a bit of experience. have a look at this, will help you http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab1
usefull as its a roadmap to get betteshow you what qualifications you can get, i done different sql emicrosoft exams hardware/software, in software doing degree atm and good thing with microsoft is that they have an interface to let you know exams to take to get to the end result :D
#3
> Is it best to learn Microsoft server or would Oracle or other be best to learn for future jobs prospects???

What job do you want?

While Microsoft make a great job of promoting SQL Server I think there are more Oracle databses in the world than SQL Server. Oracle has more large databases as well.

IBM also have their DB2 relational databases, and some of the largest databases in the world are in DB2.

So what you learn really depends on what job you want to get.

Within the world of relational databases there are a number of different jobs (database designer, technical support, SQL language expert, data warehouse designer etc) so you need to think about what job you want.

I worked for many years with relational databases so do have some experience.
#4
You would be best to concentrate on learning about relational databases to start with, and then consider learning about specific databases.
I'm an Oracle DBA, but spent years doing other jobs (programmer, analyst, software designer, business analyst, systems manager etc). The experience helped me immensely when I did eventually move on to DBA work. Not saying that this is the way that you should go, but if you get a better idea of how things work then it will help you to decide what discipline you like & what you really want to do. Don't expect to start as a DBA, as companies want experience for these roles. But there are plenty of other jobs that you can start on.
As for books, any book is a good book if it teaches you, but I would stick with the 'real' books (McGraw Hill are a good site, as are O'Reilly & Osborne).
Oracle allow you to download their software free of charge if you're using it to learn; they also have comprehensive guides (http://www.oracle.com/index.html).
Browse through the various online forums for SQL Server & Oracle, as this will help you get an idea of the sort of problems that people are having to solve.
Whatever you decide to do, good luck!
#5
I have some programming books, including some sql for sale on this thread
http://www.hotukdeals.com/for-sale-trade/fs-computer-programming-and-languag/782867
#6
That's great, thanks for all he replies everyone, some great info there. I've just been made redundant from my job in desktop support, so i though this would be a good time to look at a change of path.

guilbert53 - Database design and/or tech support is what I would like to do.

cis_groupie - I will look at relational databases to get a good grounding first and see where it takes me, thank you.

thanks everyone for the advice
#7
I found this quite helpful to start but it's not a book

SQL Demo

Edited By: natversion1 on Oct 25, 2010 19:43: Added something
#8
another great site, thanks natversion1

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!