Motivation and relational DBMS overview

  • Motivation: the importance of data, data management, and data management systems.
  • Overview: different types of data, data models, and data management systems (relational, XML, text, small/large), etc.
  • Relational DBMSs overview: the lifetime of a query, DBMS architecture overview

Using relational DBMSs

  • SQL: how to create a database, load data, insert/delete, and ask queries (including aggregation, subqueries, etc).

Modeling a real problem using a database

  • Conceptual design: ER diagrams, functional dependencies
  • Views and integrity constraints.

. Transactions

  • Transactions: what they are and how to use them
  • Different levels of isolation and possible anomalies

Advanced features

  • Indexes and how to use them
  • Security and access control

Other data models: XML, Text, and multimedia

Data on the web

  • Data integration
  • Information retrieval
  • Asking structured queries over the web

Data warehousing (OLAP) and data mining

  • Data cleaning and extract transform load pipelines
  • Data cubes

Big data processing and cloud computing

  • Parallel DBMSs and MapReduce
  • Databases as a service (SimpleDB, etc.)

Buffer