This course provides an introduction to the broad field of information management systems, covering a range of topics relating to structured data, from data modeling to logical foundations and popular languages, to system implementations. The course covers the relational data model, SQL, database design using the Entity-Relationship model and relational design theory, transactions and updates, efficient storage of data, indexes, query execution & optimization; and “big data” and NoSQL systems.
Share Your Course Experience
If you have already taken this course, we request you to share your experience, tips, suggestions, and resources regarding this course on MCIT Central. Examples include textbooks, websites, YouTube channels, software tools that were valuable for your study, and/or your general experience with the course. Your contribution will help create a repository for students’ collective knowledge which will help prospective students understand more about the course and make use of the student recommended resources to succeed in this course.
550 is best taken alone, but can be taken with a course with a lighter course load. 591 and 592 is a prerequisite and 596 is a corequisite. Average hours per week: 15-20