Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How long it takes to learn SQL server 2000

Status
Not open for further replies.

seaport

MIS
Jan 5, 2000
923
US
I am pretty good at Access and SQL language, but I have never touched any version of SQL server. Now my boss threw me a project on SQL server to be done by the end of this month.

The project is to set up an ASP application that is supposed to use SQL server as the web database. The application only contains less then 10 tables. I have all asp codes ready and they runs OK with an Access 2000 database. The SQL server has been installed on a computer.

So, the question is, how long it takes for me to migrate this application from Access 2000 to SQL server? Do you think I can get it done before the end of this month?

Thanks in advance.

Seaport
 
3 weeks 5 days. Will they supply you with any self training materials? Decent ones can be pretty expensive. I think the cbt they provided me was ~1200 and had 13 cds. There was good stuff in there but a bit too much about xml for my current needs but good basic stuff. People like TLBroadbent on this site are invaluable but it's hard to rely on a forum when you're under a deadline. Get really aquainted with Books On Line. Most of the time the answer to your question is hiding in there somewhere. 'The Guru's Guide to Transact SQL' is really good. I think the author's name is Celko. Have you got anyone other staff to help you? I started out with nothing, and I still have most of it.
 

Ken Henderson is the author of 'The Guru's Guide to Transact-SQL.' I agree that it is a good book on T-SQL.

There are a lot of good resources listed in the FAQ area of this forum. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Knowing SQL and with introduction to Oracle DBA instructor-led training I learned SQL Server from

Transact-SQL Programming by Kline, Gould, and Zanevsky from O'Reilly.

I can't give you a comparative evaluation except to say it covers a lot of territory, it is clear, and I never felt the need to find an alternative book.

Books Online is an excellent reference far superior to Access Help.

I think SQL Server with Enterprise Manager is a lot easier to learn and use than Access.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top