Advanced Database

 [Advanced Database] Syllabus

[Fall 2018/2019]

Instructor Information

Instructor

Email

Office Location & Hours

[Dr. Mouhib Alnoukari]

[Mouhib.alnoukari@gmail.com]

[Location, Hours, Days]

 

General Information

Description

The main goal of this course is to introduce the main concepts of Business Intelligence & Data Warehousing. The student will learn enough knowledge and practices on how to design and create a data warehouse, use Extract, Transform and Load (ETL) tools, understand and implement data mining algorithms, and finally understand and use the data visualization tools.

 

Expectations and Goals

1-          Introduction to Business Intelligence & Data Warehousing

2-          Business Analytics

3-          Data Warehousing & ETL

4-          Data Mining Algorithms

5-          Data Visualization

 

Language(s) of Instruction:  Arabic/English                               Textbook(s) Language(s): English

 

Course Materials

 

Required Text

·       Inmon W. H.: Building the Data Warehouse, Wiley &Sons.

·       Silberschatz, Korth, & Sudarshan: Data Base System Concepts, 5th edition, McGraw-Hill.

·       Kimball R., Ross M.: The Data Warehouse Toolkit. The Complete Guide to Dimensional Modeling, Wiley &Sons.

 

Course Schedule

 

Week

Topic

Reading

Exercises

1

22/9- 26/9

Introduction to Business Intelligence & Data Warehousing

Inmon – Ch. 1

SQL Server Analysis Services (SSAS)

2

29/9- 03/10

Business Analytics

Inmon – Ch. 1

SQL Server Analysis Services (SSAS)

3

06/10- 10/10

Business Analytics

Inmon – Ch. 1

SQL Server Analysis Services (SSAS)

4

13/10- 17/10

Data Warehousing

Inmon – Ch. 2

SQL Server DW

5

20/10- 24/10

Data Warehousing

Inmon – Ch. 2

SQL Server DW

6

03/11- 07/11

Data Modeling

Inmon – Ch. 3

SQL Server OLAP

7

10/11- 14/11

Data Modeling

Inmon – Ch. 3

SQL Server OLAP

8

17/11- 21/11

ETL

Inmon – Ch. 4

SQL Server Integration Services

9

24/11- 28/11

Data, Text and Web Mining

 Silberschatz  - Ch. 20

SQL Server Integration Services

10

01/12- 05/12

Data Mining Algorithms

Silberschatz  - Ch. 20

SQL Server Data Mining

11

15/12- 19/12

Data Mining Algorithms

Silberschatz  - Ch. 20

SQL Server Data Mining

12

22/12- 26/12

Data Mining Algorithms

Silberschatz  - Ch. 20

SQL Server Data Mining

13

22/12- 26/12

Data Mining Algorithms

Silberschatz  - Ch. 20

SQL Server Data Mining

14

29/12- 02/01

Data Visualization

Inmon – Ch. 10

Microsoft Power BI

15

 

 

 

 

 

Testing Schedule

Test

Date

Subject

Reading

Type

language

% of final grade

Quizz 1

27/10-1/11

Introduction to Business Intelligence & Data Warehousing, Business Analytics, Data Warehousing

Inmon – Ch. 1, 2

MCQ/written

Arabic/English

10

Quizz 2

8/12-13/11

Data Modeling, ETL

Inmon – Ch. 3, 4

MCQ/written

Arabic/English

10

Final Exam

5/1-17/1

Data, Text and Web Mining, Data Mining Algorithms, Data Visualization

Silberschatz  - Ch. 20, Inmon – Ch. 20

MCQ/written

Arabic/English

50

 

 

 

 

 

 

 

 

Syrian Private University - Faculty of of Computer and Information Engineering @ 2024 by Syrian Monster - Web Service Provider | All Rights Reserved