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(s): Admission to the Business Intelligence concentration of the ISIT program, or permission of the instructor.

Course Outcomes
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

Find out when this course is offered