Week - 1 |
Introduction
Industrial Information System |
Week - 2 |
Database Management Systems |
Week - 3 |
Database Management Softwares
Data Types |
Week - 4 |
SQL- Structured Query Language |
Week - 5 |
SQL-Select Queries
Aggregate Functions
Subqueries |
Week - 6 |
SQL-Update, Delete Queries |
Week - 7 |
SQL-Programmability
Trigers
Stored Procedures
Functions |
Week - 8 |
Data security, data backup |
Week - 9 |
Data Modeling
Model Types
Relational Modeling Formats |
Week - 10 |
Structured Analysis and Functional Architecture Design
Functional Architecture
Informational Architecture |
Week - 11 |
Desktop Database Management Software (MS Access) |
Week - 12 |
Access-Forms, Queries, Reports, Macros |
Week - 13 |
Case Study |
Week - 14 |
Projects |