Really looking to get my feet wet and learn SQL, in order to understand it I need to use it in a manor that makes sense to me. I have compiled a media library and am running a web server on my local lan. I created the site with Microsoft Publisher, I'm a bit html familiar (it's been a few years) what I'm wanting is to have a search function on the site and use SQL as my database.
So I can search for a video or audio file or any file on the site and have that request look through sql and return results. I'm installing SQL Server 2008 Express off the Microsoft site as we speak.
This is all running on Vista 32-bit with WinLamp already installed so I got php and am using apache as the webserver. I am just not sure what to search for in order to find the answers or help I'm looking for. If someone could provide a good link or any advice it would be greatly appreciated.