Results 1 to 4 of 4

Thread: Access, SQL or MySQL

  1. #1

    Thread Starter
    Frenzied Member longwolf's Avatar
    Join Date
    Oct 2002
    Posts
    1,343

    Access, SQL or MySQL

    I'm a self taught VB6 programmer (with a whole lota help from sites like this
    I'm pretty good with VB6 now.
    I've just recently started teaching myself DB's
    I have OfficeXP so I've started with Access.
    I'm mainly interested in increasing my income potential from programming.

    BUT
    A friend of mine just gifted me with full, licensable versions of Visual Studio .net Enterprise and .net Enterprise Servers
    (he has a son-in-law that works for MS

    SO...
    Should I stick with Access for a while or jump into SQL and hope I don't drown?
    P.S. I've also downloaded MySQL but haven't installed it either.

  2. #2
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Access, SQL or MySQL

    Since you're lucky enough to have that software, might as well drop vb6 and go for vb.net + sql 2000. Definitely will help you with the income potential.

    It'd especially be helpful if you learn SQL server well. It's a very powerful database server and is very useful in enterprise application scenarios.

  3. #3
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Access, SQL or MySQL

    Get a copy of the DEVELOPERS edition of MS SQL SERVER - I hear it's around $50 US...

    It's a fully functional copy of MS SQL SERVER - for your use to develop with.

    MS also supplies a free version of MS SQL server for your customers to use - called MSDE - as long as the number of concurrent users doesn't exceed around 8 or so...

    MS SQL SERVER is definately a marketable addition to your resume. MS bought SQL from SYBASE - it's been around for dozens and dozens of years. They have improved it incredibly in the past 5 or so years - it's a great product.

    Learn T-SQL - the programming language - it's very well worth it!

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  4. #4

    Thread Starter
    Frenzied Member longwolf's Avatar
    Join Date
    Oct 2002
    Posts
    1,343

    Re: Access, SQL or MySQL

    Quote Originally Posted by szlamany
    Get a copy of the DEVELOPERS edition of MS SQL SERVER - I hear it's around $50 US...
    My friend believes that MS SQL SERVER is on one of the CDs he gave me.
    May take some hunting, there are 14 CDs in all.

    Right now I pickup the odd job from RentaCoder.com and am developing a couple of apps I plan to sell myself.

    As far as the resume goes, being self taught I don't have any 'credentials' that I can display.
    What are my chances of landing a 'Real Job' with a company that uses something as expensive as MS SQL?

    I'd love to take classes but I'm out of work, (damned free trade laws) and can't afford them now.

    I'm guessing that the apps I'm hoping to market won't need anything more than Access.

    I've never been hired as a programmer; it's a career change for me.
    But I love programming.

Posting Permissions

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



Click Here to Expand Forum to Full Width