KEMBAR78
Information Management 2 Course Syllabus | PDF | Big Data | Data Warehouse
Scribd
Upload
118 views3 pages

Information Management 2 Course Syllabus

The course 'Information Management 2' builds on foundational concepts from 'Information Management 1', focusing on advanced database techniques, business intelligence, and data analytics. Students will learn to optimize databases, design data warehouses, and utilize big data technologies, culminating in a capstone project. Assessment includes quizzes, laboratory exercises, and a capstone project, with a mix of theoretical and practical applications throughout the course schedule.

Uploaded by

Marvin Clutario
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
118 views3 pages

Information Management 2 Course Syllabus

The course 'Information Management 2' builds on foundational concepts from 'Information Management 1', focusing on advanced database techniques, business intelligence, and data analytics. Students will learn to optimize databases, design data warehouses, and utilize big data technologies, culminating in a capstone project. Assessment includes quizzes, laboratory exercises, and a capstone project, with a mix of theoretical and practical applications throughout the course schedule.

Uploaded by

Marvin Clutario
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Course Syllabus

Program: Bachelor of Science in Computer Science


Course Title: Information Management 2
Course Code: IM201
Credit Units: 3
Pre-requisite: Information Management 1
Course Description: This course builds upon the foundations laid in Information Management
1, focusing on advanced database concepts, business intelligence, and data analytics. Students
will learn about database optimization, data warehousing, and big data technologies. The course
emphasizes the practical application of these concepts in real-world scenarios.

Course Outcomes:

By the end of this course, students will be able to:

1. Optimize database performance and ensure data integrity.


2. Design and implement data warehouses for analytical purposes.
3. Understand the role of big data technologies in modern information management.
4. Apply data visualization tools to derive insights from data.

Course Content and Schedule:

Week 1: Advanced Database Concepts

 Indexing and optimization techniques


 Transactions and concurrency control

Week 2: Database Performance Tuning

 Query optimization
 Analyzing execution plans

Week 3: Data Warehousing Basics

 Concepts and architecture


 Benefits of data warehousing

Week 4: Extract, Transform, Load (ETL) Process

 ETL tools and techniques


 Data integration strategies
Week 5: Business Intelligence (BI)

 BI tools and technologies


 Decision support systems

Week 6: Data Analytics Introduction

 Overview of data analytics


 Descriptive, predictive, and prescriptive analytics

Week 7: Tools for Data Analysis

 Spreadsheet software (Excel)


 Programming tools (Python, R)

Week 8: Big Data Fundamentals

 Characteristics of big data


 Differences between traditional and big data systems

Week 9: Hadoop Ecosystem

 Hadoop components
 Introduction to HDFS and MapReduce

Week 10: Apache Spark Basics

 Spark architecture
 Data processing with Spark

Week 11: Data Visualization Principles

 Importance of visualization
 Design principles for effective visuals

Week 12: Data Visualization Tools

 Using Tableau and Power BI


 Creating interactive dashboards

Week 13: Emerging Trends in Information Management

 Cloud-based databases
 Artificial intelligence in data management

Week 14: Capstone Project Development


 Planning and implementing a BI solution
 Progress reporting and feedback

Week 15: Capstone Project Presentation

 Final presentation of BI solutions


 Peer and instructor evaluation

Assessment Methods:

 Quizzes and Exams: 30%


 Laboratory Exercises: 30%
 Capstone Project: 40%

References:

 Connolly, T., & Begg, C. (2015). Database Systems: A Practical Approach to Design,
Implementation, and Management. Pearson.
 Kimball, R., & Ross, M. (2013). The Data Warehouse Toolkit: The Definitive Guide to
Dimensional Modeling. Wiley.
 Provost, F., & Fawcett, T. (2013). Data Science for Business. O'Reilly Media.

You might also like