Structured Query Language
Installing A Wamp Server

What Is WAMP?

WAMP is the acronym used to refer to web servers set up and configured with the following options.

Windows - Apache - MySQL- PHP

Windows is the operating system on which the server is installed (LAMP would be on a Linux machine). Apache is the name of the web server, MySQL is an online relational database program and PHP is a server-side scripting language used to create dynamic web pages.

In order to complete the remaining exercises in this section, you would need to have access to a WAMP or LAMP server. It is preferable to experiment with these things in an offline environment on your own PC. Each of the 4 elements of a WAMP server are developed separately and can be installed separately. Alternatively, you may find it easier to download a WAMP installer from http://www.wampserver.com.

In addition to the above, you will need a program that will pass your queries to the database. Some WAMP installers include PHPMyAdmin, a web-based database management tool for MySQL. Otherwise, download and install this from another location. Although you will be able to use a console to pass queries to MySQL, you will find that PHPMyAdmin slightly more helpful when learning SQL.