Data Management and Data Systems

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. You will learn about data models, schema vs. data, data definition language, and data manipulation language. You will explore the different jobs involved in building a database including database designers, application developers, and administrators. You will gain a familiarity with the design and development of applications including design in UML and relational design principles.

Topics Include

• Characteristics of high performing databases
• Indexes, views and transactions
• Authorization, integrity constraints and triggers
• Online analytical processing (OLAP) and JSON
• NoSQL systems