Diploma in Data-warehousing

MLC College – Graduate Diploma Programs

Course outline:

1. Introduction to Programming

  • Fundamental of Programming using C+
  • Algorithms, Problem Solving and Data Structures
  • Procedures and Recursion
  • Algorithms Analysis and Strategies
  • Basic Design and Development of programming Techniques and Data Structure
  • Types of Programming: Event driven and object oriented programming

2. E- Commerce Principles

  • The E-Commerce Phenomenon, WEBSITE Design principles
  • E-Commerce Solutions – Adjunct Software
  • Sever Hardware, Software, Security, Infrastructure
  • Quality Assurance, Website Maintenance and Management
  • E-marketing, Search Engines, CRM on WEB


  • Getting started with UNIX
  • General Purpose Utilities
  • The VI Editor
  • The File System and File Attributes
  • The Shell, the Process

4. Business Grammar and Writing skills

  • Business Grammar Essentials – 1
  • Business Grammar Essentials – 2
  • Business writing Skills
  • Conclusion

5. Business Communications

  • Communication Foundations
  • Business Correspondence
  • Reports and Proposals
  • Presentations

6. Database Management Systems

  • File Systems and Data Bases
  • Entity Relationship Modelling and Normalization of Database
  • Data base Design Life Cycle
  • Transaction Management and concurrency Control
  • Distributed Database Management systems and Object oriented Databases

7. Object oriented Design Methodology

  • Introduction to Object oriented Process
  • The Unified Process
  • Producing Requirement Models
  • Object oriented Design
  • Revising the concepts

8. System Analysis and Design

  • Introduction
  • Planning Phase
  • Design Phase
  • Implementation Phase

9. Introduction to Data Warehousing

  • The Evolution of Data Warehousing
  • Principles of Data Warehousing
  • Creating of Data Asset
  • Data sets for End User
  • Implementing of Data Warehouse

10.SQL. Fundamental for Data Warehousing

  • Introduction
  • A Quick Tour of SQL
  • SQL in Perspective
  • SQL Basics
  • Multi-table Queries (Joins)

11.ABAP/4 Planning language

  • Introduction to ERP and SAP
  • ABAP/4 Features
  • Data Dictionary
  • SAP Transaction Development
  • ABAP Projects

12.Introduction to Oracle Database

  • Oracle Database
  • The Database Administrator
  • Networking
  • Backup and Recovery
  • Large Data base features

13.Oracle Warehouse Builder

  • Revise Data Warehouse Concepts
  • Software and Hardware Architecture
  • Star Schema
  • Loading the warehouse, Implementing Aggregates
  • Partitioning for manageability and Operational Issues

14.Introduction of Business Intelligence

  • Understanding Business Intelligence
  • Defining BI Technologies
  • Business Intelligence Case Study
  • A business Intelligence Road Map

15.Business Information Warehouse

  • Understanding Business Information Warehouse(BIW)
  • BIW Data Modeling
  • BIW Data Extraction and Loading
  • BIW Reporting

16.Data Mining

  • Data Mining Methodology
  • Data Exploration
  • Statics and Regression
  • Decision Trees
  • Advanced Date Mining

17.Case Study

  • Data Modeling
  • Case Study –II
  • Case Study –III
  • Case Study –IV
  • Seminar

18.Project – Data Warehousing

  • Business Plan
  • Data Modelling
  • Project Plan
  • Prototype Data Model
  • Final Presentation

N. B :

The college is approved by Ministry of Training Education and Universities, Ontario, Canada andfollows the PCC guidelines to register domestic and international students.

The course content is subject to change based on updates from time to time. For more detailsconsult admissions coordinator at info@mlccollege.com or contact the college.


Translate »