I have been using Access 2000 for programming and want to transfer everything into SQL and learn coding. What class should I take?
I have been using Access 2000 for programming and want to transfer everything into SQL and learn VB coding. I am not sure how all these things are related. What class should I take?
Glad to help. Your right hiring someone to do the conversion would probably be a lot easier and maybe more cost effective. You could then take you time learning how to program for a SQL server. You might look into a few freelance websites where you can hire a SQL programmer to do that work. You might look at: http://www.elance.com, http://www.scriptlance.com, or even craigslist.com.
Thnaks so much for responding to my question...I have to give it some more thought. It might be easier for me to hire someone to do that conversion for me since I would like to have it done sooner than later.
You should probably start by brushing up on SQL server programming and learn how to properly configure SQL servers. SQL databases and servers are used by over 60%-70% of today's websites. This is a platform that is not going anywhere for sometime. For example this very website is powered by a mySQL database. I would look into the following courses for your to learn more about database programming.
This first course is a very good intro course that will teach you to manage users and security, automate basic database tasks, import and export data.
If you want to learn further, this next course will go a step further and teach you all skills needed to administrater and program sql server. This online course comes with Microsoft SQL certification so you can obtain a Microsoft Certified Database Administrator (MCDBA) Certification.
I would start with those first few online SQL classes to help educate yourself on switching from Access to SQL.
- related questions
Is BBA from ICFAI university approved by UGC?
What requirements are needed to train students for the GED test in California?
I live in Prince Geroge, British Columbia, where do I complete exams?