Database Management

Database is the foundation of Data Science. It provides the unique design to store, retrieve, and manage data. Data become the essential gas to power the generative AI. How to model data, encode context, enforce business rules, and achieve efficiency are critical for database design. This course provides the introductory understanding of relational database design with the focus on three parts. The first part is centered around the database design lifecycle by introducing business rules, ER diagram, normalization, and UML chart. The second part talks about database query language SQL by explaining concepts and providing examples. The third part gives you the forward introduction of XML database which is the commonly used NoSQL database. The learning content will be delivered in the variety of exercises including lectures, tutorials, class activities, individual assignments, group assignments, and group projects. This course empathizes peer learning, hands-on practices, forward exploring, and risk taking.