Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Just Wondering

Author  Topic 

Leyland
Starting Member

4 Posts

Posted - 2005-01-25 : 18:28:53
I was just wondering how much time it took any of you to feel comfortable using SQL Server. I know it can take years to become really proficient, but with a basic knowledge of local database such as Access, how long until you knew your way around the program?

Thanks in advance for any direction

Regards,

http://www.addmap.com

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-01-25 : 19:08:14
I'd say it took me a good year before I felt halfway competent with SQL Server. It was the experience more than the knowledge that took that long.

Then I got Ken Henderson's

The Guru's Guide to Transact-SQL

and I felt like a complete idiot again. BUT, I was an astonished and determined idiot, now with an extraordinary reference book, that taught me a great deal of what I know today.

In addition to Ken, I suggest getting Inside SQL Server by Kalen Delaney (Microsoft Press). It's an excellent reference and a great book if you're just starting out with SQL Server.
Go to Top of Page

Auric
Yak Posting Veteran

70 Posts

Posted - 2005-01-25 : 20:58:30
I've been using Access for a little over a year, started using MS-SQL recently... I'm comfortable with the basics, but my SQL skills are pretty much just that, basic.

I'm thinking of picking up one of those texts myself rob, after school is done of course..damn college is expensive enough for textbooks.
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-01-25 : 21:14:39
Throw the textbooks away, you'll learn more from Ken's book in 2 hours than you did in your entire college career. Kalen's too.
Go to Top of Page

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2005-01-26 : 02:41:44
quote:
Originally posted by Auric

I've been using Access for a little over a year, started using MS-SQL recently... I'm comfortable with the basics, but my SQL skills are pretty much just that, basic.

I'm thinking of picking up one of those texts myself rob, after school is done of course..damn college is expensive enough for textbooks.


http://search.yahoo.com/search?fr=FP-pull-web-t&p=insqlsrv.chm+kalen
try the link and get Kalen's ebook for free;

ps:
never seen The Guru's Guide -- it must be a great thing to have;
as to the 2nd book, I still keep "preparing" myself for its thorough study;
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-01-26 : 10:01:56
Dont matter if you dont learn from the textbooks, it's still required.


Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-01-26 : 10:50:29
browse SQL team, too. and play around! create your own little database off to the side with a few tables, see what you can do with it. It helps if it is something you have interest in -- for example, I find it interesting to figure out ways to model and query baseball statistics or team standings and stuff like that. Keeps things interesting and fun, and it is easy to tell when things are working or not since you are familiar with the data.

I always prefer to learn new stuff and experiment in a small, controlled environment.

- Jeff
Go to Top of Page

Auric
Yak Posting Veteran

70 Posts

Posted - 2005-01-28 : 09:53:37
quote:
Originally posted by jhermiz

Dont matter if you dont learn from the textbooks, it's still required.



sure are, i hate textbooks, i've found very few that are actually usable.
I had to buy a piddly little access textbook last year that didn't teach me shat and it still cost me $80
Go to Top of Page
   

- Advertisement -