cm3010: Databases and Advanced Data Techniques

Main Info

• Title: Databases and Advanced Data Techniques

• Leader(s): TBC

• Semester Taken: April 2022

Abstract

This module aims to show you how to work with data in your computer programs. You will learn how to use SQL and NoSQL databases to store tabular data and documents. You will learn about the ethics of gathering and processing data and why it is important to consider issues around data security. You will learn about open data resources, and how you can access them from your computer programs. You will learn about audio and video data, and the challenges of working with this kind of data.

Syllabus

Available on the REPL

Main Textbooks

Reading List available

Topics

• CM3010 Topic 01: Working with Data

• CM3010 Topic 02: Relational Databases

• CM3010 Topic 03: Reliable Databases: Data Integrity and Security

• CM3010 Topic 04: Using Databases: Libraries and Templating

• CM3010 Topic 05: Advanced RDBMS Topics

• CM3010 Topic 06: Distributed Databases and Alternative Models

• CM3010 Topic 07: Semantic Databases

• CM3010 Topic 08: Linked Data

• CM3010 Topic 09: Multimedia and Retrieval

• CM3010 Topic 10: Applications

Resources

Use the Index Luke for efficient indexing.

Postgres Indexing Guide

Related Notes

As a companion to this course, CMU’s databases course covers the actual implementation and design of database systems.