MIS 410: Advanced Database Systems Master Syllabus
Course Instructor:
Office Number:
Office Hours:
Email:
Course Meeting Times:
Textbook
This class uses open educational resources (OERs). This is no book to purchase.
Course Description
Covers advanced database development and administration topics including triggers, stored procedures, indexes, performance tuning, and security. Students will use a state-of-the-art industrial strength database management system as a tool to familiarize themselves with database concepts. Students will conduct exercises on business reporting using databases and front-end applications. A third attempt will require academic advisor approval.Offered by Information Sys and Ops Mngmnt. Limited to two attempts.
Course Objectives
Upon completion of this course, students will be able to
- Design of complex databases
- Implementation complex database design using MS SQL Server
- Design Physical DB architecture to fine-tune performance of database
- Advanced Structured Query Language (SQL).
MIS (Management Information Systems) Learning Goals
- Apply knowledge of information technology, operations, and business functions to assess, design and improve business processes.
- Effectively manage projects, including information technology projects.
- Understand the overall systems development life cycle and be able to recommend IT solutions.
BS Business Learning Goals
- The social, global, ethical, and legal contexts of business and will be able to reflect on the role of the individual in business.
- The ability to apply knowledge of professional skills necessary for success in business including effective business writing.
- Technical and analytic skills appropriate for success in business.
- The ability to apply knowledge of core business disciplines including accounting, finance, information systems, management, marketing, and operations management.
- How research in the business disciplines contributes to knowledge and how such research is conducted.
Grading Policy
| Assignment | Value |
|---|---|
| Homework (4) | 20 points |
| Quizzes (2) | 20 points |
| Exam (2) | 40 points |
| Project (1) | 20 points |
| Total | 100 points |
| Semester Grade Scale | |||
|---|---|---|---|
| A+ | 97 to 100 points | B- | 80 to 82.99 points |
| A | 93 to 96.99 points | C+ | 77 to 79.99 points |
| A- | 90 to 92.99 points | C | 70 to 76.99 points |
| B+ | 87 to 89.99 points | D | 60 to 69.99 points |
| B | 83 to 86.99 points | F | Below 60 points |
Reading Assignments
Students are required to study the course materials posted via MIS 415 Canvas course website.
To print: Right-click and choose “Print,” then follow your browser’s print settings.
To download: Right-click and choose “Print,” then select “Save as PDF.”