I'm looking to make a career change. I'm currently a high school science teacher, but am hoping to (eventually) move into a position where I'm working with SQL and database design, development, maintenance, etc. I'm enrolling in a bunch of classes for the spring term (which will be the first programming classes I've taken in about 8 years) and am hoping to find an internship for this summer so I can get my feet wet a bit. I have no idea where to look, though, to start finding internship opportunities.
In the spring term I'm taking the following courses:
-- Complete Web Authorizing: HTML
-- Intro to Programming (which should be a breeze since I've already had C++)
-- Database Design and Development
-- Intro to SQL
-- Fundamentals of UNIX
My end goal is to become proficient with SQL, but I have no idea where to begin in terms of getting experience in this area. Any ideas are welcome!
Well I learned SQL myself from making websites. Websites with content management systems (CMS) like forums, shopping carts, blogs all have their own databases. You'll usually use php and mysql for those though.
But I think you can take a look at them, there are a lot of open source forums, shopping carts, and blogs too. And you can try populating them with data and do sql queries and stuff using phpmyadmin if you want. I hope that helps you get started. =)
As for the internship though, I don't really have any clue.
SQL is the "language" you talk to databases so it is worthwhile picking up the skills.
On the other hand, there is an equivalent called XQuery which is the "language" you talk to data in XML format where data can be streaming or a document etc as long as it is in valid XML format. I don't see XQuery taking the world by storm yet possibly XML is gradually being challenged by other data format like say JSON for e.g