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?