Learning SQL Server (already know Access)

Hi,

Is it difficult to learn SQL Server?

I am self-taught Microsoft Access and have developed several small databases for commercial clients.
Patrick O'DeaAsked:
Who is Participating?
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
Not necessarily but SQL Server is Only a server, it does not have a built-in front end like Access does.  You need a program like SQL Server Management Studio or the ability to write your own code in a programming language to use it.  You could start by downloading and installing one of the SQL Server Express versions and the SQL Server Management Studio that goes with it.  Info here: http://www.microsoft.com/web/platform/database/free-database.aspx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
Easy is a relative term I'm sure.
I can recommend this site in any case. And you can watch the first 3-4 interactive lessons free.  And ~$30/month - cancel anytime for the entire catalog ... not bad.

http://www.vtc.com/databases.htm

mx
0
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
It's not really bad, although it will be a bit before you become a wiz at T-SQL.  But to get up to speed on the basics, no.  It's pretty straight forward.

If you've worked with SQL in Access, you just need to make some adjustments.

Jim.
0
 
Patrick O'DeaAuthor Commented:
Thanks for comments.
0
All Courses

From novice to tech pro — start learning today.