IS 150 Relational Database Design & SQL with MS Access

3 credits

Explores relational database architecture and provides "hands-on" instruction in SQL using both Microsoft Access and Microsoft SQL Server. Students will learn how to evaluate the business requirement and design an effective relational database solution. Students will also learn how to define and manipulate SQL objects as well as perform other common workplace SQL tasks such as creating databases, tables and reports; inserting, updating, and selecting rows; and designing queries, views, and data entry forms. Key business tasks such as importing and exporting of data, mail merge, and custom reports are mastered as well.

Prerequisite(s): IS 135 or permission of the Interim Department Chair, Business Information Systems and Computer Information Systems.