EPL342: Databases
by Demetris Zeinalipour
Department of Computer Science
University of Cyprus

Quick Links

WebMail
CS Courses

EPL342: Laboratory


Week

Description
  Material
1 Introduction to SQL Server 2008 R2 (Architecture, Connection, Data Types, etc).
2  Conceptual Modeling in SQL Server I (Creating Entities)
3  Conceptual Modeling in SQL Server II (Creating Relationships) and Project Phase 1
4  Conceptual Modeling in the Database Design Studio (both ER and EER)

5

 SQL-DDL Basics in SQLServer
6  SQL-DDL (Constraints) in SQLServer
7  Use Case Scenario - Northwind Database
-  October 28th -  National  OXI Celebration Day ---

8


 SQL-DML I in SQLServer (SELECT-FROM-WHERE)
9 SQL-DML II in SQLServer (ORDER BY, LIKE, CONTAINS, EXISTS, NULL)                 

10
SQL-DMLIII (Views, Triggers, Functions)
11 SQL-DMLIV in SQLServer + Explanation of Phase 3  JAVA-SQL Programming  in SQLServer

12

 SQL Advanced (Stored Procedures, Triggers, Indexes, etc) in SQLServer
13 * Project Exam ---


 

Copyright � Department of Computer Science, University of Cyprus