Modern database systems provide powerful tools for analyzing and organizing large amounts of information for research and business. However, for the information to be used effectively it needs to be structured correctly and accessible. This course provides an introduction to the use of relational databases and the organization of the data stored in them. Microsoft Access is the primary database used in this class, but other database packages, ranging from Oracle to Filemaker, are discussed. Students should expect 1 to 3 hours of work per week outside of class.
Students passing the course receive a certificate.
Modern database systems use a variety of methods to manage the database and the data contained within it. SQL is the primary language used to communicate with databases ranging from Oracle, Sybase, Informix, and DB2 through MS Access. SQL allows the user to execute simple queries as well as controlling all facets of the database. This course focuses on the use of SQL for querying complex databases with an introduction to the administrative features of the language.