Brushing up/Learning SQL and Databases
Got some awesome/exciting/thrilling/scary news at work a couple days ago.
An administrator pulled me aside, closed the office door, and handed me a draft document.
The document outlined a new position in the agency, Data Management Specialist. The admin walked me through the requirments, making sure that I had all the qualifications and then came right out and told me that my name had come up specifically for this new job. He set up a meeting with a guy that helped flesh out the requirements of the position to talk to me about specifics.
Currently I'm a MicroComputer/Network Specialist. I fix unplugged network cables, printers, install new computers and fix old ones. Every now and then special projects fall in my lap. This position would be special projects all day!
Sorry if this seems a little broken. A bottle of wine is running through my caffeine system.
So... this position is going to become available in the next few days and I've been STRONGLY encouraged to apply. I have about 1.5% fear, worry, and anxiety in me, and the rest is excited and ready to go!
So, here comes the rub: A large part of this new position will be to take a huge hodgepodge of existing, ad-hoc databases/online forms/web applications in a variety of formats... and modernizing/streamlining/consolidating them into the Databases used by the schools we service.
Too much of my Database experience is classroom only and I have next to no familiarity with frontend/backend applications/web portals in an actual working environment. My admins know this, and if I get this position I will have quite a few learning resources available to fill in any gaps in my knowledge toolkit, but here comes my question.
Are there any books or websites the GWJ collective would recommend for reference, general reading, or just good to have on hand for working with databases and online applications?
Systems mentioned: SQL, ASP, Perl, Filemaker (this is what I'd be switching over the the SQL database), Access, etc.
I have several general database/design textbooks that I believe should be mostly current. My favorite: Systems Analysis and Design (fouth edition) Shelly Cashman Series.
Any suggestions are appreciated.