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.
- Peter Bailis Assistant Professor, Computer Science
- Characteristics of high performing databases
- Indexes, views and transactions
- Authorization, integrity constraints and triggers
- Online analytical processing (OLAP) and JSON
- NoSQL systems
3.0 - 4.0
Students enrolling under the non degree option are required to take the course for 4.0 units.