ISIT 331 Applied Database Concepts • 5 Cr.
This course provides an in-depth introduction to relational database concepts, the Structured Query Language (SQL), and relational database programming. Topics include generating the structure of a relational database and relational database design principles. This course provides extensive practical experience with creating, modifying, and querying relational databases. Prerequisite: Admission to the Business Intelligence concentration of the ISIT program, or permission of the instructor.
After completing this class, students should be able to:
Use client tools to work with a database server Design basic databases according to proper design principles Create databases using Structured Query Language (SQL) commands Create basic and complex SQL queries to retrieve data from a database Create appropriate SQL queries in response to realistic requirements for data and information Create SQL statements to safely and successfully add data to a database or modify existing data in a multi-user environment Write SQL code for the database including database stored procedures Evaluate SQL queries for effective performance