For one reason or another, I need to try and develop a SQL database. It is to teach SQL to a small group of Yr10's who want to create an SQL database, but the school servers are not allowed to run SQL because of "security issues with SQL" Its for their GCSE coursework, and a long term project (9months). The rest of the class want to play with Access, but they want to be able to develop their database to be accessible via the internet.
I have an old machine (P2 300mhz 256mb ram) sitting here, and a copy of NT Server. To test and develop the SQL i believe that I need a server capable of running SQL, which NT Server claims to do.
Theory seems to suggest that as NT Server supports SQL, I should be able to install this on the old box, plug it into my BT Voyager ADSL router, and then get my desktop (XP home) and the new "server" to talk to each other, and create the test environment for me to prat around and experiment at home. Knowing the IP address, the kids would be able to access the server via my broadband router to develop their database, but *not* my desktop machine. I believe they could also develop the front end webpages to to retrieve the SQL data and store those on the server.
If it can be done, it means I've got to learn SQL more quickly than the kids can..... I foresee some long nights.
Can it be done?
Am I thinking along the right lines?