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
Co Teachers: kashif nasr, Humaira Jabeen, Ashfaq Ahmed, Bilal Khan, Mukhtiar Zamin, Dr Imran Ali Khan, Dr. Muhammad Amir Khan, Somiya zaman, Maria Gul, Ali Iqbal, Demo Teacher
Category: Computer Science
Created on 08 Mar 15 and last modified on 05 Apr 22