IV. ADVANCED SPECIAL COURSE ON DATABASE MANAGEMENT
Home Faculty: Faculty of Engineering
Language of instruction: English
Lessons: 2hrs Presentation + 2hrs Computer Lab Practices /week
Testing:
1 in-class test + 1 homework assignment /week
1 written final exam + 1 team project /semester
Content
1. Title of topic: Basics of Relational Database Management and OLAP
Course description:
0. Intro
1. Basic terms of RDBMS
2. ER Diagram
3. Normalization
4. Database Design
5. Database Generation in MSAccess
6. Import-export in MSAccess
7. SQL1 in MSAccess
8. SQL2 in MSAccess
9. Forms in MSAccess
10. Reports, Pivot tables, OLAP terms
11. Indexing
Class hours/week: 4
2. Title of topic: Business Process Engineering and System Design of Data Mining systems in
Corporate environment
Course description:
0. Intro
1. Usage of MSVisio
2. Database Design: Sales subsystem
3. Database Design: MRP subsystem
4. Database Design: HR subsystem
5. Database Design: CRM subsystem
6. Database generation in MS SQL
7. SQL
8. Stored Procedures
9. Forms in .Net environment
10. Reports
11. Data Mining Utilities of MS SQL
Class hours/week: 4
Duration of the program in weeks: 14 weeks
Tuition fee for the program: 5000 USD
Application deadlines: 31 May (fall semester), 15 November (spring semester)