Course Descriptions

CS G130: Introduction to database systems

Introduces relational database management systems as a class of software systems. Prepares students to be sophisticated users of database management systems. The course covers design theory, query language and performance/tuning issues. Topics include relational Algebra, SQL, stored procedures, user-defined functions, cursors, embedded SQL programs, client-server interfaces, entity-relationship diagrams, normalization, B-trees, concurrency, transactions, database security, constraints, object-relational DBMSs, specialized engines such as spatial, text, XML conversion and time series. The course will include exercises using a commercial relational or object-relational database management system.

Prerequisites: MS: DB Ph.D.: DB

Credit hours: 4

Course offerings:
• Fall 2006