New to SQL Server...need suggestions

Question

Post reply

New to SQL Server...need suggestions

James-315088

SSC Enthusiast

Points: 166
More actions
March 29, 2006 at 1:27 pm

#189933

Hi all. I am "self educating" myself on SQL Server 2000. I have 7 years DBA experience with MS Access. So far, it is pretty much similar. Is there any advice you can give me, any online tutorials, hints, or anything to get me going in this?
One thing I would like to understand better is how to set up security such as logins, etc.
I don't know how important it is to learn Transact SQL since I can use the GUI part of SQL Server to manipulate, create, delete data and tables. I am familar enough with it that if I need to modify the statement, I can.
Any comments are welcome!
Looks like a pretty useful forum!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Joseph Mulhall SSCarpal Tunnel Points: 4672 More actions · Answer 1

Watch these:

https://www.microsoftelearning.com/sqlserver2005/

Read this:

http://go.microsoft.com/fwlink/?linkid=44375

And play with this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en

(Make sure you meet requirements and also install

http://www.microsoft.com/downloads/details.aspx?familyid=9697AAAA-AD4B-416E-87A4-A8B154F92787&displaylang=en

and

http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en

)

Enjoy! ))

scb SSCommitted Points: 1859 More actions · Answer 2

I agree with Joseph - check out the e-learning, and if you can, just start on SQL 2005 instead of 2000, since 2000 is already a 5-6 yr old release. Plus 2005 is better. I think the farther you get into it, the less similarity you'll see between Access & SQL Server. They're both relational systems that hold tables & you can query data with, yes. But SQL (especially 2005) is a fully featured enterprise wide database system. You'll find LOTS of things in SQL that you cannot do in Access.

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 3

Learning TSQL is imperative. You can't do everything through a GUI, nor would you want to.

James-315088 SSC Enthusiast Points: 166 More actions · Answer 4

Thanks guys for the reference.

SRB: Ya, I hear ya...same with Access...had to learn VBA. I actually am pretty familar with SQL so just a quick reference to books or this forum will be all I need (hopefully)!