Student Learning Outcomes

Database Modeling II is an advanced database modeling course designed to introduce the student to the management side of relational databases. This course builds on the skills learned in course prerequisites with a review of database maintenance and creation. Database reporting, administration and programming skill development will be the primary focus of this course. Advanced skill development in design, installation, configuration, maintenance, and analysis of performance will be highlighted throughout the course.
Student Learning Outcomes
  • Create, configure, and maintain SQL Server databases, tables, views, constraints, indexes, queries
  • Construct UDF's, stored procedures, and triggers
  • Import data into database systems
  • Export data from database systems
  • Design security policies for operating and database users
  • Perform and maintain database systems
  • Implement database performance monitoring and tuning
  • Create and configure user permissions on database systems
  • Design and implement data backup and recovery plans on database systems
  • Create end user reports
  • Implement a basic Create, Read, Update, Delete interface
  • Explore alternative database models and software systems

Prerequisites

Please see eServices for section availability and current pre-req/test score requirements for this course.