+ Post New Thread
Results 1 to 10 of 10
Educational Software Thread, Teaching SQL - How do you do it? in Technical; Hi All - long time reader first time poster, hope someone here can lend a hand I work as a ...
  1. #1

    Join Date
    Feb 2009
    Location
    Portsmouth
    Posts
    2
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Teaching SQL - How do you do it?

    Hi All - long time reader first time poster, hope someone here can lend a hand

    I work as a tech support in a college using RM CC3, and an IT lecturer has asked me to look into a way that students can be taught SQL, in the locked down environment that we give them.

    The first problem I have is that said lecturer has written some code in Visual Basic Express, linking to a database on her network drive. SQL will not support UNC or remote accessing the database, meaning we will have to access it locally (C:\ drive) - this is no good to us unfortunately.

    We have thought about installing Virtual PC and then putting an image into their user area, but we are conscious that giving students an essentially free reign over a PC may have repurcussions with what they do on the network!

    What do you other schools/colleges/HE's do for teaching SQL? what environment and software do you use?

    Cheers
    Mark

  2. #2
    apoth0r's Avatar
    Join Date
    Apr 2007
    Location
    Northants
    Posts
    1,221
    Thank Post
    151
    Thanked 180 Times in 132 Posts
    Rep Power
    52
    You could setup a virtual image to allow certain functions which then reverts back to a 'start' state each time they log off. I haven't really done anything with SQL so i don't know the ins and outs but that is what various course providers have done in workshop environments.

  3. #3
    dalsoth's Avatar
    Join Date
    Sep 2008
    Location
    Cambridgeshire
    Posts
    547
    Thank Post
    190
    Thanked 108 Times in 80 Posts
    Rep Power
    47
    I think virtual PC is the way to go. I believe that RM have advertised it for this use in the past. I remember reading something about students learning programming and other such things on RM using virtual PC.

    Never tried it myself though.

  4. Thanks to dalsoth from:

    mbeet (10th June 2009)

  5. #4
    rh91uk's Avatar
    Join Date
    Sep 2008
    Location
    UK
    Posts
    877
    Thank Post
    137
    Thanked 132 Times in 114 Posts
    Rep Power
    36
    Don't know if this would work or not - but could you set it to save in their local profile on the workstation - and then save/export to their network drive on logoff (an xcopy or something?).

    Not tried it so don't know how effective it is.

    Virtual machines, as you say, is an option, but remember you have to have licences for all extra xp installs you set up.

  6. #5
    pauljonze's Avatar
    Join Date
    May 2008
    Location
    Staffs
    Posts
    86
    Thank Post
    17
    Thanked 22 Times in 15 Posts
    Rep Power
    22
    SQL won't use UNC?? There's no need? What about an ODBC link to a SQL Server or Oracle database that's been secured. You could even use MS Access with linked tables and write the SQL in the query designer using SQL View - Access SQL queries will give them a good starting point if it's just an intro. There's loads of ways to do it as far as I can see.

  7. #6

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,653
    Thank Post
    1,257
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    Quote Originally Posted by mbeet View Post
    an IT lecturer has asked me to look into a way that students can be taught SQL, in the locked down environment that we give them.
    You could give them an SSH client and let them connect to a shared machine.

    --
    David Hicks

  8. #7

    Join Date
    Feb 2009
    Location
    Portsmouth
    Posts
    2
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for all the responses thus far

    We are looking into the RM virtual PC package mentioned (HE Shop: MS Virtual PC 2004 for CC3/ST3 Solution Pack) - we weren't aware of it existing! its exactly what we were after.

    Cheers!

  9. #8
    Jamo's Avatar
    Join Date
    Jan 2009
    Posts
    1,354
    Thank Post
    66
    Thanked 175 Times in 147 Posts
    Rep Power
    60
    Cant you use access? MS access supports queries written in SQL and you can experiment on the local database then, no need for any other parts installed.

  10. #9

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,225
    Thank Post
    874
    Thanked 2,717 Times in 2,302 Posts
    Blog Entries
    11
    Rep Power
    780
    I would just have a central SQL server with database creation access given to student accounts. You can easily access a SQL DB over TCP/IP with this setup and it also allows you top create and edit databases in either VB express or SQL managment Studio express. This setup would be far more secure and much more simmilar to a real world situation than single file linked databases which are not really used that often in my experience.

  11. #10

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    SQL makes even my brain hurt! As a compromise (not sure if it's an option), but taking a look at MS Access. You can do quite a bit with it.

    Edit: Sorry I just realised Jamo has already mentioned this!

SHARE:
+ Post New Thread

Similar Threads

  1. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 05:10 PM
  2. Support Staff or Non-Teaching?
    By webman in forum General Chat
    Replies: 58
    Last Post: 20th April 2007, 12:06 PM
  3. Sysadmins teaching too
    By palmer_eldritch in forum Educational IT Jobs
    Replies: 18
    Last Post: 20th January 2007, 09:11 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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