Information Systems Program
Module 1
Overview of Relational Database
Support
Lesson 1: Course objectives
Lesson Objectives
• Gain context for this course in the specialization
• Understand targeted learners for this course
• Understand broad course objectives and prerequisite
background
Information Systems Program
Data Warehousing for Business Intelligence
Course 1 Database management
essentials
Course 2 Data
Data warehouse
warehouse concepts,
concepts,
design,
design, and
and data
data integration
integration
Course 3 Relational
Relational database
database support
support for
for
data
data warehouses
warehouses
Course 4 Business
Business intelligence
intelligence concepts,
concepts,
tools,
tools, and
and applications
applications
Course 5 Design
Design and
and build
build aa data
data
warehouse
warehouse forfor business
business 3
intelligence
intelligence implementation
implementation
Information Systems Program
Targeted Learners
University students IT professionals
Project managers Business analysts
Information Systems Program
Broad Course Objectives
Extend data Understand Practice technical
warehouse foundation conceptual skills
• Career advancement background • Write queries using SQL
• Business intelligence or • Query formulation extensions
data warehouse • Summary data • Query rewriting
professional management
• Physical data warehouse
design
Gain insight Reflect on guidelines
• Big data impact • Query formulation
• Data governance practices • Materialized view design
• Data governance
Information Systems Program
Relational
model
Data
modeling
Course 1
Joins and
grouping
Relational
Course 3 DBMS
prerequisite usage
s Data
warehouse
concepts
Schema
Course 2 patterns
Data
integration
concepts
6
Information Systems Program
Summary
• Second data warehouse course in the specialization
• Balance concepts, technical skills, and management
practices
• Career opportunities for data warehouse and business
intelligence positions
Information Systems Program