Database Systems

1 Unit · Graduate

This course introduces data management and database systems with a focus on applications in large-scale analytics projects utilizing relational, document, graph, and graph-relational databases. Students learn about the relational model, the normalization process, and query languages, including structured query language. They learn about data cleaning and integration, and database programming for extract, transform, and load operations. Students work with unstructured data, indexing and scoring documents for effective and relevant responses to user queries. They learn about graph data models and query processing. Students write programs for data preparation and extraction using various data sources and file formats. Recommended prior programming experience or MSDS 430-DL Python for Data Science. Required: none.