ASDV 2540 SQL Database Programming

(2-2-0) 3 Credits UT

This course presents the fundamental concepts of database design and use with primary emphasis on the relational data model. ER diagrams, relational algebra, query languages, functional dependency theory, normalization techniques, query processing and optimization, concurrency control, recovery and security. Various database servers will be examined and used.
Pre-requisite(s): ASDV 1205, ASDV 1220 Concurrency: ASDV 1905, ASDV 2420 Co-requisite(s): None