CS 338: Computer Applications in Business: Databases
Students will work with a state-of-the-art commercial DMBS. A number of systems can be used. The School supports DB2, but you can also use Microsoft SQL Server or MySQL. Learning how to use these systems is your responsibility. You will find the following resources useful:
- DB2 Tutorial
- Online reference for DB2
- SQL Server Tutorial
- Another SQL Server Tutorial
- MySQL Tutorial
- Online course for learning SQL
- Another online course for learning SQL (Note: this site has DB2 specific information as well)
Getting your own DBMS
- If you have your own PC, you can download a copy of DB2 for educational use. It is available for Linux and Windows. This is a large download, however, so probably impractical over a dialup connection.
- You can also download MySQL. Installer is available for Windows and for Linux and Mac OS X (these require a bit more work).
We will be making use of clickers in lectures to engage students and provide instant feedback.
- Clickers can be purchased at the UW bookstore in South Campus Hall for around $42 (and buy-back for ~ $20).
- You may buy a new or used iClicker, but cannot share one with someone else in the class.
- Alternatively, software can be purchased that allows a netbook or smartphone to be used as a clicker for $10. See Web Clicker Information.
- To get marks for using your clicker, you must register your clicker here.
- Clicker FAQ