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