Good free tutorials SQL Server?
-
Hi!
I've programmed in ASP 3.0/MS-Access and PHP/MySQL, and now I'm entering the world of SQL Server (I want to build a website using .Net and Sql Server).
Normally I just look for free tutorials on the net when I want to learn something new, but I can't seem to find a good (and free) tutorial for SQL Server 2000. Can anyone provide me with a good link for a newbee?
Cheerio
-
Dpends on what level you are at. There's sqlzoo.net for basic sql syntax. There's also w3schools.com. Best of all there's the Books On Line.
******************
Dinakar Nethi
Life is short. Enjoy it.
****************** -
Hi Dinakar
Tnx for your reply. I checked out the links that you provided. However, I'm looking for a tutorial about the application SQL Server itself, not about SQL.
Just by trying I managed to create a database and a table, but I guess there must be some tutorial that explains all that. MS-Access for example is more intuitive, and although SQL Server doens't seem as difficult as Oracle for example, I'd like some guide that shows you step by step how to create a db and the tables, how to put the relations, etc.
Cheerio
-
Also, in your Microsoft SQL Server program group you'll find an item "Enterprise Manager". This is a GUI admin tool that easily will get you started. Do a search here for "Enterprise Manager" and check only the article box. Returns many useful hints.
Probably one of the best is:
http://www.sqlservercentral.com/columnists/dcorey/toptenfeaturesofenterprisemanager.asp
Once you've created the database, you better forget about EM and go with Query Analyzer. Brain Kelley did some very good articles on the use of this tool. Search for "Getting the Most Out of SQL Server 2000's Query Analyzer".
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
While not free, Paul Sheriff's company (PDSA) has published a SQL Server e-book that costs $25 to download and print. Code is included in that cost.
I've personally found Paul's e-books to be phenomenal learning guides that don't cost me an arm and a leg compared to a lot of the books in the bookstores.
Hope this helps.
-
Hi!
Tnx for the replies. All of the links you've provided me were very helpful. I especially liked the http://www.pdsa.com. It's only 19,95$, wich is very little money.
Greetings
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply