Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    Regular Coder
    Join Date
    May 2005
    Posts
    220
    Thanks
    1
    Thanked 2 Times in 2 Posts

    New to databases

    I love coding, and enjoy the outcome of what I can produce. But as everyone knows, you can only do so much in html, javascript etc... The real power is behind those monster databases. Unfortunatly I am unfamiliar to databases along with anything associated with them. I have asked many people about mysql and database basics. I would like to know the following:

    Where can I get a free database? (if such a thing exists)
    Where can I learn basic database skills?

    I would like to learn how to create a chat using a login (personalized) database. Where can I learn to do this?

    Thanks

  • #2
    Senior Coder JamieR's Avatar
    Join Date
    Oct 2004
    Location
    United Kingdom
    Posts
    3,161
    Thanks
    0
    Thanked 5 Times in 5 Posts
    mySQL is free, I think.

    You can learn mysql syntax over at http://dev.mysql.com/ If you want to learn how to make a login script etc, take a look at the php/mysql tutorials which are already on the internet.

    Jamie.

  • #3
    Smokes a Lot
    Join Date
    Jul 2003
    Location
    CA, USA
    Posts
    1,594
    Thanks
    5
    Thanked 20 Times in 20 Posts
    Or if you want to go with SQL Server and the ASP side of the house:

    SQL Server (developers addition, not for production but great for learning and free.):
    MSDE 2000

    For database administration:
    SQL Server Data Administrator

    Issues can arise the first time you install Data admin, just post back if you have problems, there are some dlls you may need to register, you also need to have the .NET framework installed.

    Learn VBScript
    VBScript Tutorial

    Learn SQL:
    SQL Tutorial

    Learn ASP:
    ASP Tutorial

    Learn ADO:
    ADO Tutorial

    Good Luck,
    Basscyst
    Last edited by Basscyst; 05-26-2005 at 12:56 AM.
    Helping to build a bigger box. - Adam Matthews

  • #4
    Regular Coder
    Join Date
    Aug 2004
    Location
    The US of A
    Posts
    767
    Thanks
    1
    Thanked 0 Times in 0 Posts
    PostGreSQL is good competitor to MySQL.

    www.postgres.org

  • #5
    Regular Coder
    Join Date
    May 2005
    Posts
    220
    Thanks
    1
    Thanked 2 Times in 2 Posts
    Wow dude,

    Thanks for all the references.

  • #6
    Regular Coder
    Join Date
    May 2005
    Location
    lincolnshire
    Posts
    155
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Im new to web databases too

    Im new to web databases too and have found the
    easiest way to get to grips;

    Access database
    ASP
    IIS (free 98/xp pro/2000 pro)

    then I have progressed to;

    access (converted to sql database)
    ASP using more SQL commands.
    MYSQL

    ASP is the scripting language hosted on an IIS Server, the database I have used is an access database which connects to IIS using ADO (connection object), you can use DSN (data source name) or a DSN-less connection called OLE-DB. SQL is the language for manipulating the database, ie add records,
    Last edited by little_toaster; 05-30-2005 at 04:03 PM. Reason: basic principles


  •  

    Posting Permissions

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