National CAE Designated Institution
  • Classroom
Course Description

This course explores various topics in database management systems (DBMS), using a typical commercial DMBS (e.g., MySQL, SQL Server, Oracle). Administration, security, stored procedures, triggers, transactions, functions, data mining, data warehousing, and remote access to databases are some of the topics covered. The student is expected to demonstrate an understanding of these database concepts through creating, deploying, and utilizing various relational database designs. The goal of this course is to provide students with an advanced understanding of database design, implementation, and management concepts and techniques.

Learning Objectives

  1. Perform advanced relational data modeling, using entity-relationship diagrams.
  2. Design a data warehouse.
  3. Apply performance tuning techniques.
  4. Administer and perform backup and recovery procedures.
  5. Justify and define user’s roles, permissions, and access-levels as a database administrator.
  6. Create database security settings.
  7. Demonstrate an understanding of data warehousing, data mining, and data analytic techniques.
  8. Compare and contrast NoSQL and SQL (RDBMS) solutions.

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Knowledge Management
  • Systems Analysis