Data Management

COURSE OBJECTIVES

This course provides a practical introduction to database technology. By the end of this course, students will understand the fundamental concepts about database management systems, become familiar with commercial tools for the design and development of database applications, and be exposed to recent trends in database-like storage systems.

COURSE DESCRIPTION

Databases are essential to applications in a wide variety of domains, including finance, health care, commerce, and telecommunications. In fact, most applications that people use on a day-to-day bases are backed by databases. Topics covered include modeling enterprise data with ER diagrams, the relational model, SQL, XML, logical design with normalization, physical design, query execution, transaction processing, recovery, concurrency, online analytical processing, and NoSQL systems.

LEARNING METHODS

Lectures with many examples, and hands-on assignments for practicing concepts.

EXAMINATION INFORMATION
3 components:

• Midterm, written
• Assignments
• Final exam, written

REFERENCES
No material required, but some recommended reads are

• Database Management Systems, Ramakrishnan & Gehrke, 3rd ed.Fundamentals of Database Systems, Elmasri & Navathe, 6th ed.