Databases are widely prevalent and underlie technology used every day. They reside behind a huge number of websites and are a crucial component of telecommunications systems, banking systems, video games, and many other software systems and electronic devices that maintain some amount of persistent information.
This course provides an introduction to database design and the use of database management systems for applications. Learn about data models, schema vs. data, data definition language, and data manipulation language. Explore the different jobs involved in building a database including database designers, application developers, and administrators. Gain a familiarity with the design and development of applications including design in UML and relational design principles.
- Christopher Re Assistant Professor, Computer Science
- Characteristics of high performing databases
- The relational model, relational algebra, and SQL
- XML data including DTDs and XML schema for validation
- The query and transformation languages XPath, XQuery, and XSLT
- Online analytical processing
- NoSQL systems
3.0 - 4.0
Students enrolling under the non degree option are required to take the course for 4.0 units.