I'm learning SQL in a class, but I'd like to be able to get the syntax down through practice. Unfortunately, I have no idea how to get started when it comes to the server part. I have experience with Java, C++, and HTML. I'm good at programming, but the whole networking thing is throwing me.
So, what do I need to do to run/test SQL commands? Ideally, it would be on my machine, using some virtual server. Is that even possible? Please let me know, thanks for your input.
Any DB backend that you use will setup a service on your machine. And that acts like a server. So you wont have to setup anything apart from installling your DB backend.
Fortunately, if you are setting up the DB Server on your local machine, you wont have any networking issues (especially security and permission which can be bad many time)
once you have the server setup, go to you ODBC sources and test if you can connect to the server you installed.
Once thats done too, build up a connection string with the help of your DB driver. For more help on
connection Strings check this site
cheers,
Happy coding
9
