Student Learning Outcomes
Databases are an integral part of modern computer applications. This course introduces students to basic relational database concepts, relational database terminology, and data modeling concepts. Students will create a conceptual data model using entity-relationship diagrams, understand the importance of referential integrity, and learn how to enforce data integrity constraints when creating a database. SQL Data Manipulation Language and Data Definitions Language will be used to create database objects and to insert, read, update, and display data in a relational database management system. An introduction to NOSQL databases will also be covered.Student Learning Outcomes
- Install and configure a relational database in a Virtual PC environment.
- Employ database normalization techniques.
- Create and maintain relational databases, tables and other objects using Structured Query Language (SQL).
- Write SQL statements to create indexes, views, referential, entity, domain and user-defined constraints on database tables.
- Write SQL statements and scripts to insert, delete, update and retrieve data in tables.
- Write SQL statements to extract and manipulate data from database objects using joins.
- Determine differences between different relational databases and not-relational databases
Please see eServices for section availability and current pre-req/test score requirements for this course.