SQL server exams - Learn MS Access first, then move on to SQL

Author

Learn MS Access first, then move on to SQL

2000-12-26, 10:30 pm

Here is a little cut and paste from one of our earlier newsletters. Basically, we recommend starting with learning MS Access, and then moving on to SQL server.

++++++++++++++++++++++++++++++
+++

We often receive emails asking for the best way to study for the SQL exams. Let’s face it -databases can be quite intimidating for beginners.

If you have absolutely no experience with databases, my advice to you is to start with Microsoft Access. The reason is because Access is part of the MS office 2000 suite and it does not cost nearly as much as the SQL server. Once you learn the basics of working with Access, learning SQL will be a lot easier.
For absolute beginners I recommend starting with Access 2000 basics study guide.
http://www.amazon.com/exec/obidos/A...45/examnotesnet

This study guide costs only $18.80 and is rated 5 stars on Amazon.com
This guide is organized just like a courseware material you may find in a college program. The greatest thing about it is that it comes with sample databases on CD.

You learn by doing practice exercises using databases from CD rom. In just a few lessons you will learn how to create tables, forms, create reports, and more database essentials.

This book does not get into the more advanced topics like macros and databases accessible from web sites, but you will learn enough material to move on to the more advanced databases like SQL server.

If you don’t already have Access database on your computer, you can buy it from Amazon.com. You don’t have to buy the whole Office 2000 suite. Access 2000 alone costs $289.99. Here is the link: http://www.amazon.com/exec/obidos/A...92/examnotesnet

Learning Access 2000 is the great way to break into the field of database administration.

------------------
Webmaster and founder of this site and of
<A HREF="http://www.cert21.com"" TARGET=_blank>Cert21.com</A>
MCSE+I, CNA, A+, N+, I-NET+

2001-01-02, 9:55 pm

I can't agree more!

I worked with Access alittle before having a SQL server dumped on my desk, and i find simple admin just fine. But with out a strong 'base' (pun, i know) of database knowleadge SQL exams are giving me a headache, they stand between me and +I and my goal of learning the dam thing for work and MCDBA that i would like to grace my wall.

Also really mess around with the Access Northwind, etc, stuff 'cos it's in here like a friend in SQL 7.

Given a chance I would forget about SQL and spend more time with Access, but life is never that way! ( well mine isn't)

Good Luck,
'cos i'll need it!

------------------
Best Regards
David
MCSE,MCP+I,CNA 5,i-Net+ Network+,A+,NT-CIP, CIW Assoc.
Dave24-7@examnotes.net

2001-01-06, 10:37 pm

What can I do to become a NT-CIP and also CIW Assoc

quote:
Originally posted by Dave24-7:
I can't agree more!

I worked with Access alittle before having a SQL server dumped on my desk, and i find simple admin just fine. But with out a strong 'base' (pun, i know) of database knowleadge SQL exams are giving me a headache, they stand between me and +I and my goal of learning the dam thing for work and MCDBA that i would like to grace my wall.

Also really mess around with the Access Northwind, etc, stuff 'cos it's in here like a friend in SQL 7.

Given a chance I would forget about SQL and spend more time with Access, but life is never that way! ( well mine isn't)

Good Luck,
'cos i'll need it!

2001-02-15, 8:40 pm

Hi folk,

<---snip--->
The reason is because Access is part of the MS office 2000 suite and it does not cost nearly as much as the SQL server.
<\---snip--->

That's true, but in some Trainingsbook you get an evalcopy , as well you can order it at the MS site. http://www.microsoft.com/sql/productinfo/evaluate.htm

Additional there is a disadvantage using Access if you want to go to the Impl. & Design Exam. Access uses different data types and SQL syntax and so on.

regards
Cat

------------------
nobody is perfect ...

Sponsored Links