Zeinalipour > Courses > EPL342 > Labs

Laboratory Schedule

Week Content Material Solutions
W01 Introduction to MS Access PDF  
W02 SQL Server Orientation - Account Setup - Home Installation Tips PDF  
W03 ERDPlus and ER Examples (entities) PDF  
W04 ER Examples on ERD+ PDF PDF
W05 Project Assignment and Discussion + PHP and SQL Server PDF, lab7-Supplemental.zip  
W06 Relational Algebra PDF PDF
W07 SQL-DDL I PDF TXT
W09 SQL-DML I (Basic Block SELECT-FROM-WHERE, and Set operators) PDF, Northwind.txt PDF
W10 SQL-DML II (Joins, Aggregates, Nulls, Order, Like) PDF  
W11 SQL-DML III (Views, Triggers) and DB Programming I (Sproc and Procedural)    
W12 DB Programming II (Selected topics: Indexes, Transactions, Graphs, Json , Administration, Role Management, etc.)    
W13 Project Phase B - Exam.