First half covers basic terminologies of database, role of databases in organizations,compare traditional file bases systems, need of modern database management systems and DBMS architecture and evolution. Second half covers Relational Algebra, Relational Databases, life-cycle of database systems including system definition, requirement collection and database designing at conceptual, logical and physical level with refined steps.At the end we cover advanced concepts related to write complex SQL queries, analysis and indexing, security, transaction management and query optimization.
By Thomas Connelly, Carolyn Begg
Main Teacher: Subject Expert Admin
Cooperating Teachers:
Category: Computer Science
Created on 08 Mar 15 and last modified on 05 Apr 22