Dates: 05/26 - 07/11
M	T	W	Th	F	Sa	Su
	5:30 pm 8:30 pm SCC 314 5:30 pm 8:30 pm Online		5:30 pm 8:30 pm SCC 314 5:30 pm 8:30 pm Online

Subject: Software Eng (Grad) (SEIS)

CRN: 30212

CoFlex:In Person&Online Sync | Lecture

St Paul: Schoenecker Center 314

Online

Requirements Met:
     Software Data Mgmt Conc
     Software Technical Elective

  Syed Naqvi

This course focuses on database management system concepts, database design, and implementation. Conceptual data modeling using Entity Relationships (ER) is used to capture the requirements of a database design. Relational model concepts are introduced and mapping from ER to relational model is discussed. Logical database design, normalization, and indexing strategies are also discussed to aid system performance. Structured Query Language (SQL) is used to work with a database using the Oracle platform. The course also covers query optimization and execution strategies, concurrency control, locking, deadlocks, security, and backup/recovery concepts. Non-relational databases are also briefly introduced. Students will use Oracle and/or SQL Server to design and create a database using SQL as their project.

3 Credits