Oracle, PostgreSQL and MySQL.We will need a database server and a sample database for class use. This class will use the open-source

database SQLite.For students on a Windows platform:Please create a new folder “AdvSQL Class” and download the following file to this folder:http://www.earl-family.net/McKesson/AdvSQL/SQLite.zipUnzip the SQLite file, and double click on the SQLite.bat file to open a command window, then

following the instructions below to test your installation.For students on a Mac platform:Mac's come with SQLite pre-installed, it is located in /usr/bin directory and called sqlite3. Mac user

will need to download our sample database from:http://www.earl-family.net/McKesson/AdvSQL/Northwind.sl3Create a new folder “AdvSQL Class”, and put the sample database in this folder. To get to sqlite3, you

can open up a terminal windows (Applications -> Utilities -> Terminal) and then typing the following:cd /usr/bin/sqilte3 Northwind.sl3Please see the instructions on testing your installation below.For students on a Linux platform:To use SQLite on a Linux platform, you will need to download both SQLite and the sample database

from:http://www.earl-family.net/McKesson/AdvSQL/sqlite3-3.7.3.bin.gzhttp://www.earl-family.net/McKesson/AdvSQL/Northwind.sl3See:http://www.howtoguidehome.com/main/index.php?option=com_content&view=article&id=44%3Ahow-to-install-sqlite3-under-linux&catid=13%3Adatabase&Itemid=3&lang=enFor detailed instructions, then follow the instructions below to test your installation.SQLite Installation test:To test the install enter the following in the command window:SELECT * FROM Region;You should see 4 lines of results.Enter.exitto quit.SQLite GUI Manager Add-on for FireFox:If you are using FireFox as a Browser, there is on open-source Add-On to examine SQLite databases, it

can be installed from:https://addons.mozilla.org/en-US/firefox/addon/5817/