Lectures

=CSE341 - Database Systems=
 * Fall' 2009, IBA, Karachi**

to logical model || || Sample Data: || ||
 * Lecture -1 || Introduction & History of Database Systems || [[file:DatabaseSystems01-Fundamentals.ppt]] ||
 * Lecture -2 || DBMS Environment, Data Abstraction || [[file:DatabaseSystems02-DBMSEnvironment-DataAbstraction.ppt]] ||
 * Lecture - 3 || Data Modeling || [[file:DatabaseSystems03-DataModeling.ppt]] ||
 * Lecture -4 || Data Modeling - Relationships || [[file:DatabaseSystems04-DataModeling_Relationships.ppt]] ||
 * Lecture -5 || Data Modeling - Exercise || [[file:DatabaseSystems05-DataModeling_Relationships.ppt]] ||
 * Lecture - 6 || Data Modeling - Participation, Strenght,Integrity Constraints || [[file:DatabaseSystems06-DataModeling_Relationships.ppt]] ||
 * Lecture - 7 || Mapping from conceptual
 * Lecture - 8 || Quiz 2, Scenario Discussion, ERD Notations || [[file:DatabaseSystems08-ERDNotations.ppt]] ||
 * Lecture - 9 & 10 || Relational Algebra || [[file:DatabaseSystems09-10-RelationalAlgebra.ppt]] ||
 * Lecture - 11 || Relational Algebra - Inner & Outer Joins || [[file:DatabaseSystems11-RelationalAlgebra- Inner and Outer Joins.ppt]]
 * Lecture - 12 || Relational Algebra - Division, Common Mistakes || [[file:DatabaseSystems12.ppt]] ||
 * Lecture 13 - 16 || Normalization || [[file:DatabaseSystems13-Normalization.ppt]]
 * Lecture 17 || SQL - Joins ||  ||
 * Lecture 18 || SQL - Aggregate Group By ||  ||
 * Lecture 19 || SQL - HAVING, Sub-queries & Correlated Queries || [[file:SampleQueries17-19.txt]] ||
 * Lecture 20 || SQL - Group By/Subqueries, UNION / INTERSECT / EXCEPT, DateDiff, Getdate ||  ||
 * Lecture 21 || DateTime functions, Insert, Update ||  ||
 * Lecture 22 || Delete, Store Procedure, Triggers || [[file:SampleQueries20-21.txt]] ||
 * Lecture 23 || Database Views, Indexing || [[file:Database Indexing.doc]] ||
 * Lecture 24 || Database Indexing ||  ||
 * Lecture 25 || Transaction Handling ||  ||
 * Lecture 26 || Transaction Handling ||  ||
 * Lecture 27 || Transaction Handling ||  ||
 * Lecture 28 || Concurrency Control ||  ||
 * Lecture 29 || Concurrency Control || [[file:TransactionManagement.ppt]][[file:Transactions and Concurrency.doc]] ||
 * Lecture 30 || Data Partitioning || [[file:Partitioning.ppt]] ||
 * Lecture 31 || OLTP vs OLAP ||  ||