IE 424: DATA PROCESSING OPERATIONS

COURSE OUTLINE

 

 

Course Outline (General Topics and Weeks)

 

Database Management Systems	Week 1
SQL Language for Data Processing and Operations	Week 2-3
Implementing Database Designs	Week 4
Database Applications	Week 5
Tools for Building Database Applications	Week 6
Using Delphi and Kylix for Cross-Platform	Week 7-12
Database Application Development
Advanced Database Processing Issues	Week 13-14

 

Detailed Course Outline

 

Database Management Systems

Network Database Management Systems

Hierarchical Database Management Systems  

Relational Database Management Systems

Object-oriented Database Management Systems

Popular Database Management Systems

 

SQL Language for Data Processing and Operations

Data Definition Language

Data Manipulation Language

Data Query Language

 

Implementing Database Designs

        Data Modeling and Database Designs

Steps for Constructing Tables

Rules for Table and Column Naming

Data Types

Constructing Tables

Column Constraints

Copying Tables

ALTERing Tables

DROPping Tables

Data Manipulation Language (Insert, update and delete)

Transaction Processing (Commit and rollback)

 

Database Applications

        Transaction Processing Systems

        Management Information Systems

        Decision Support Systems

        Expert Systems

 

Tools for Building Database Applications

        Visual Languages

        Cross-Platform Application Development

 

Using Delphi and Kylix for Cross-Platform Database Application Development

        Integrated Development Environment

        Introduction to Delphi

• Features
• Delphi and Other Visual Languages
• Integrated Development Environment
• Basic Files
• Structure of a Delphi Program

Basics of Language

• Variables and Data Types
• Integers
• Real Numbers
• Strings
• Complex Data Types
• Control Statements
• IF-THEN Controls
• CASE Controls
• Loops
• FOR Loops
• WHILE Loops
• REPEAT-UNTIL Loops
• Subroutines
• PROCEDUREs
• FUNCTIONs

Delphi and Kylix Components (VCL and CLX components)

• What is a component?
• Visual Components
• Components in Standard Pallette
• Components in Additional Pallette
• Data Access Components
• Data Controls Components
• System and Win32 Components
• Quick Report Components
• Internet and Fastnet Components
• Non-visual Components
• Standard, Additional, Data Access, Dialog Components
• Data Aware Components
• Installing 3^rd party Components
• ActiveX (OCX) Components
• Writing new Components

 

Database Applications

• Understanding BDE
• Constructing Database
• Connection Settings to Database (Alias settings etc.)
• Constructing Tables and Relations using Database Desktop
• Constructing Tables and Relations using SQL
• Using Database Components

§         Using Data Access Components (TDatabase, TTable, TDataSource, TQuery etc.)

§         Using Data Control Components (TDBEdit, TDBGrid, TDBComboBox etc.)

§         Use of Editkey, GotoKey, Setkey

§         Simple Database Form, Master/Child and Master/Child/Child forms

• Delphi on InterBase
• Delphi on Oracle
• Delphi on SQL Server

Reporting Components (Quick Reports and others)

Writing DLL and Components

 

Advanced Database Processing Issues

Data Warehouses

OLAP (Online Analytical Processing) Technologies

Multi Dimensional Modelling

Decision Cubes

Data Mining Technologies