University of the People 3 credits MSIT
Students are provided with theoretical knowledge and practical skills in advanced topics in database systems, data marts, and data warehouses. The specific topics covered include indexing methods, query processing and optimization strategies for relational database systems, Object Relational Mapping and Object Database design, distributed database systems, data mining on large databases. Learning Objectives and Outcomes: By the end of this course students will be able to: Examine application domains, concepts, and structures of industry-standard database management systems, including web and cloud systems. Evaluate emerging technologies (such as Big Data, NoSQL, On-Line Analytical Processing (OLAP), and Data Warehouses) and their potential as business solutions. Compare and contrast Data Marts and Data Warehouses, and the advantages or disadvantages of each using research-based evidence. Course Schedule and Topics This course will cover the following topics in eight learning sessions, with one Unit per week. Week 1: Unit 1 - Data Warehouse Requirements Week 2: Unit 2 - Design Requirements for Data Warehouse Week 3: Unit 3 - Data Warehouse ETL process Week 4: Unit 4 - Data Mining Techniques Week 5: Unit 5 - Managing Data on the Web Week 6: Unit 6 - Managing Data in the Cloud Week 7: Unit 7 - Data Analysis Tools Week 8: Unit 8 - Business Intelligence/Data Warehouses Learning Guide The following is an outline of how this course will be conducted, with suggested best practices for students. Unit 1: Data Warehouse Requirements Read the Learning Guide and Reading Assignments Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum) Complete and submit the Written Assignment Complete the Reflective Portfolio Assignment Unit 2: Design Requirements for Data Warehouse Peer assess Unit 1 Written Assignment Read the Learning Guide and Reading Assignments Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum) Complete and submit the Written Assignment Complete the Reflective Portfolio Assignment Unit 3: Data Warehouse ETL process Peer assess Unit 2 Written Assignment Read the Learning Guide and Reading Assignments Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum) Complete and submit the Written Assignment Complete the Reflective Portfolio Assignment Unit 4: Data Mining Techniques Peer assess Unit 3 Written Assignment Read the Learning Guide and Reading Assignments Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum) Complete and submit the Written Assignment Complete the Reflective Portfolio Assignment Unit 5: Managing Data on the Web Peer assess Unit 4 Written Assignment Read the Learning Guide and Reading Assignments Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum) Complete and submit the Written Assignment Complete the Reflective Portfolio Assignment Unit 6: Managing Data in the Cloud Peer assess Unit 5 Written Assignment Read the Learning Guide and Reading Assignments Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum) Complete and submit the Written Assignment Complete the Reflective Portfolio Assignment Unit 7: Data Analysis Tools Peer assess Unit 6 Written Assignment Read the Learning Guide and Reading Assignments Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum) Complete and submit the Written Assignment Complete the Reflective Portfolio Assignment Unit 8: Business Intelligence/Data Warehouses Peer assess Unit 7 Written Assignment Read the Learning Guide and Reading Assignments Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum) Complete the Reflective Portfolio Assignment Complete and submit the anonymous Course Evaluation
Our subject experts help with essays, research papers, case studies, discussion posts, and capstone projects for these programs β written from scratch to your course requirements.
Program and course information is reproduced from each university's published academic catalog for informational purposes and may change. Always confirm current requirements with your university. We are an independent academic support service and are not affiliated with or endorsed by the universities listed.
Expert guides on essay writing, citation styles, study skills, and academic success.
View All Articles
Learn how to write a good research question for a paper. Narrow your topic, identify a research problem, and create a focused question with practical examples.
Learn how to choose a research topic you can actually research. Discover how to narrow broad ideas, find reliable sources, and develop a focused research question.
Learn how to cite sources in a research paper using APA, MLA, and Chicago styles, with in-text citation examples and reference-list tips.