IS 566

Download as PDF

Advanced Database Management

Information Systems Marriott School of Business

Course Description

This course explores advanced concepts in database management systems, focusing on complex database architectures, data modeling, and performance optimization. Topics include transaction management, distributed databases, data warehousing, and advanced SQL programming. Through practical applications and case studies, students will gain hands-on experience in designing, managing, and optimizing large-scale databases, with an emphasis on scalability, reliability, and security.

When Taught

Winter

Credit Hours

Min

Fixed/Max

Lecture Hours

Fixed

Lab Hours

Fixed

Learning Outcomes

Title

Design and Implement Complex Database Solutions

Learning Outcome

Apply advanced data modeling techniques to design robust databases for complex applications, ensuring data integrity and scalability.

Title

Optimize Database Performance

Learning Outcome

Analyze and optimize database performance using indexing, query optimization, and transaction management strategies.

Title

Manage Distributed and NoSQL Databases

Learning Outcome

Demonstrate proficiency in managing distributed and NoSQL databases, addressing data consistency and replication challenges.

Title

Ensure Data Security and Integrity

Learning Outcome

Implement security protocols and access control measures to safeguard data, applying best practices in database security and compliance.