Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Online Resources to practice SQL

  • 13-03-2012 06:12PM
    #1
    Lombardo86
    Registered Users, Registered Users 2 Posts: 485 ✭✭


    Hi,

    Am hoping somebody may be able to point me in the right direction. I am looking for somewhere to practice my SQL. I am going to be getting back into it soon and would like to brush up before then.

    I am looking for any online resources that i would be able to run some triggers/procedures/not too complex queries jst as a refresher without the whole installing a DB and web servers etc.

    Is there anything online that would facilitate this or what is the easiest way to go about it?

    Any help appreciated - Thanks


Comments

  • #2
    amen
    Registered Users, Registered Users 2 Posts: 2,781 ✭✭✭amen


    Download the free versions of MySQL or MS SQL Express


  • #3
    seamus
    Registered Users, Registered Users 2 Posts: 68,173 ✭✭✭✭seamus


    You can get huge sample databases from Microsoft which you can load into an MSSQL Express server:
    http://msftdbprodsamples.codeplex.com/


  • #4
    duffman85
    Registered Users, Registered Users 2 Posts: 339 ✭✭duffman85


    XAMPP (apache, mysql,php) from here(www.apachefriends.org/en/xampp.html) is installs and configured in a few clicks. Can run queries from command line or phpmyadmin interfaces

    SqlServer Express and the Management Studio are straightforward enough to get going on and as Seamus says there's lots of sample dbs to play with.


  • #5
    drag0n79
    Registered Users, Registered Users 2 Posts: 197 ✭✭drag0n79


    Lombardo86 wrote: »
    Hi,

    Am hoping somebody may be able to point me in the right direction. I am looking for somewhere to practice my SQL. I am going to be getting back into it soon and would like to brush up before then.

    I am looking for any online resources that i would be able to run some triggers/procedures/not too complex queries jst as a refresher without the whole installing a DB and web servers etc.

    Is there anything online that would facilitate this or what is the easiest way to go about it?

    Any help appreciated - Thanks

    I don't think you'll be able to look at triggers, procedures etc. without doing the installs as others have mentioned above.

    But if you want to practise some queries online, look here

    http://db.grussell.org/sql/

    (use the cat command to view the tables in the database)


  • #6
    Lombardo86
    Registered Users, Registered Users 2 Posts: 485 ✭✭Lombardo86


    Hi Everybody.. thanks for the links/resources there. Been a while since i was into the detail here so excuse the basic question!

    Will have a look around here and ill post back some useful feedback over the next while should anyone else be in my position in future


  • Advertisement
Advertisement
Advertisement