DATA 331 - Applied Database Concepts

5 CR

Previously ISIT 331.
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 BAS Data Management and Analysis Business Intelligence concentration, or BAS Business Management and Technology, 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