Newbie wants to learn

Question

Newbie wants to learn

donyell011

Newbie

Points: 7
More actions
January 11, 2009 at 1:40 am

#217417

how and where should i start in learning access and sql? im a newbie and im very interested.:)

Viewing 9 posts - 1 through 8 (of 8 total)

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

Dugi SSCoach Points: 17998 More actions · Answer 1

donyell011 (1/11/2009)
how and where should i start in learning access and sql? im a newbie and im very interested.:)

I don't know what is your experience with MS Access...but if you want to learn SQL you should leave Access at all!

You can try here for basic learning SQL:

http://www.w3schools.com

Then go here to see some video:

http://www.sqlservercentral.com/Training[/url]/

When you learn the basics how to use some commands come back here and you will find too many articles about SQL - and countinue to learn!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Dugi (1/11/2009)
I don't know what is your experience with MS Access...but if you want to learn SQL you should leave Access at all!

What's wrong with MS Access?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Dugi SSCoach Points: 17998 More actions · Answer 3

GilaMonster (1/11/2009)
Dugi (1/11/2009)
I don't know what is your experience with MS Access...but if you want to learn SQL you should leave Access at all!
What's wrong with MS Access?

Nothing at all...for the moment with MS Access 2007 you can do too many things and it is more flexibile to work!

SQL is professional Database technology and when you start to learn, my opinion is to leave at all Access, on the other hand you can start to learn MS Access then later go for SQL!

:hehe:

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Steve Jones - SSC Editor SSC Guru Points: 736607 More actions · Answer 4

As a technology, nothing it wrong with Access. It fits in places, but it also is deployed to many people that get themselves into trouble with databases. In many ways I like Excel better than Access for the masses.

Honestly to learn about databases, start reading articles. If you don't understand one of them, skip it and move on. Go find an article on something you don't understand and read that. Work your way through things.

I'd also recommend some of the basic books on SQL Server, maybe the "for Dummies" or "learn in 24 hours" to get some basics and quick overviews of what's happening. We also have videos here and more on JumpstartTV (a partner) that can help you learn.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 5

Dugi:

FYI, you can use SQL in Access. It is not an "either..or" situation.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 6

Other than learning a particular DB I would say learn SQL, a good book is SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL http://www.amazon.com/SQL-Queries-Mere-Mortals-Hands/dp/0201433362

Covers all the syntactical differences between engines and provides a sample DB in SQL Server and access, good to get you actually working on a DB.

Andrew

Dugi SSCoach Points: 17998 More actions · Answer 7

RBarryYoung (1/11/2009)
Dugi:
FYI, you can use SQL in Access. It is not an "either..or" situation.

Hehe for a long time I have this information my friend, everyday I'm using Access (2003 - 2007) - and it is powerfull Office Application to make some good application! It's everything OK! But finally if you want to learn SQL I really will leave Access and go just for SQL, later sure that you will have any experience to export or import from Access and so!

I like Access but much more SQL!:w00t:

This is my opinion!

😉

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Ronald H SSCarpal Tunnel Points: 4053 More actions · Answer 8

I don't know if you know anything about theory and understanding databases commons. I did, and I first learned (well, first dBASE III/IV) Access, then SQL Server. Using all the wizards and after that trying to find out what they did really helped me learning about SQL and what databases do.

Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2