SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Zealot
    Join Date
    Jan 2002
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Best way to learn MS SQL Server 2000

    Hi

    Ive been looking at jobs in my local area, and alot of them ask for SQL Server experience.

    Ive heard about the MCDE package. COuld i use this to learn how MS SQL works. Or would a thorough read of a telephone directory sized SQL server book be ok?

    Thanls for any help!
    Last edited by flutlichtjunky; Jun 21, 2003 at 06:06.

  2. #2
    SitePoint Wizard davidjmedlock's Avatar
    Join Date
    Dec 2002
    Location
    Nashville, TN USA
    Posts
    1,688
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    buy the developers edition of SQL Server and just start playing with it on your machine. that's exactly how I learned it... there's tons of wizards and GUI tools that make things so easy to do. you might also pick up a "SQL Server 7/2000" in 24 hours type of book just as a rough guide to learning it.

  3. #3
    SitePoint Zealot
    Join Date
    Jan 2002
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I only have windows 98, would it run on this?

    And i take it from what you said that microsoft dont do the nice thing and supply a free developers edition like the nice people over at macromedia do for their JRun server?

  4. #4
    Wanna-be Apple nut silver trophy M. Johansson's Avatar
    Join Date
    Sep 2000
    Location
    Halmstad, Sweden
    Posts
    7,400
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by flutlichtjunky
    I only have windows 98, would it run on this?
    Yes, but you'd miss out a lot of the proper administration. See this as an excuse to get ahold of Windows 2000 or XP Pro.

    And i take it from what you said that microsoft dont do the nice thing and supply a free developers edition like the nice people over at macromedia do for their JRun server?
    Microsoft both supplies a free (development only) version of SQL Server called MSDE, and a 90-day trial version.
    Mattias Johansson
    Short, Swedish, Web Developer

    Buttons and Dog Tags with your custom design:
    FatStatement.com

  5. #5
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    And if you download the SQL Server 2000 free trial you can install the client-side tools (like Enterprise Manager) that will allow you to use MSDE as if it was the real thing (for learning/development anyway)!
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!

  6. #6
    SitePoint Zealot
    Join Date
    Jan 2002
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ive searched high and low on the Microsoft uk and us sites, but ive yet to find anywhere saying i can download it.

    There is alot about how ti comes free with other programmes though.

    I think ill go with the 90 day trial soon, right after i get a good book to learn it from.

    Thanks for your advice everyone.

  7. #7
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    MSDE is not available for download, but it does come on the Office 2000/XP CDs...
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!

  8. #8
    SitePoint Zealot
    Join Date
    Jan 2002
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ah noooo. Only got 97

    But it does sound interesting. So your saying if i get MSDE and d/l the trial version of ms sql and only install the tools, do i have virtually a developer version of ms sql?

    i.e. would a book on ms sql and this setup teach me enough to be confident when applying for jobs where ms sql knowledge is desirable?

    btw thanks for helping.Sitepoitn is definitely the best place to get fast quality answers!

  9. #9
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    "Yes" to both your questions!
    MarcusJT
    - former ASP web developer / former SPF "ASP Guru"
    - *very* old blog with some useful ASP code

    - Please think, Google, and search these forums before posting!

  10. #10
    SitePoint Zealot
    Join Date
    Jan 2002
    Posts
    109
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    EXCELLANT!!!!! Thats just what i wanted to hear, thanks alot.

    BTW, does it matter that the trial is for win 2000, XP. The tools would still work wouldnt they?
    Last edited by flutlichtjunky; Jun 22, 2003 at 10:47.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •