DTS 3143 units300 LevelFirst Semester

Data Management I

B.Sc. Data Science, University of Uyo

Database systems for the data professional, going well beyond UUY-DTS 112: advanced SQL, indexing and query performance, transactions and concurrency, and the design of data models that survive real workloads.

On Areté, DTS 314 comes with

  • 2 recommended textbooks
  • an AI tutor that has read this course’s outline and notes
Sign in to study DTS 314

Free for University of Uyo students — sign in with your email, no password.

Course outline

  1. 01Review of the relational model and relational algebra
  2. 02Advanced SQL: window functions, common table expressions, recursive queries, set operations
  3. 03Views, stored procedures, triggers and user-defined functions
  4. 04Physical design: storage structures, indexing (B-tree, hash), and when an index hurts
  5. 05Query processing and optimisation; reading an execution plan
  6. 06Transactions: ACID properties, concurrency control, locking, isolation levels and deadlock
  7. 07Recovery, backup strategies and write-ahead logging
  8. 08Database security: privileges, roles, injection prevention and encryption at rest
  9. 09Distributed databases and NoSQL families: key-value, document, column-family and graph stores

Recommended textbooks

  • Database System Concepts — Silberschatz, Korth & Sudarshan

    7th ed. — the definitive university text

  • SQL Performance Explained — Markus Winand

    Short and exceptional on indexing; use-the-index-luke.com is the free companion

How to pass DTS 314

  • Window functions are the highest-leverage SQL skill you can learn at this level — running totals, rankings and period-over-period comparisons all become one query
  • Run EXPLAIN on your slow queries and read the plan. Knowing why a query is slow is a rarer skill than writing SQL at all
  • Learn the isolation levels with the anomaly each one permits (dirty read, non-repeatable read, phantom) — that table is a standing exam question
  • Practise on a database with at least a million rows; performance concepts are invisible on toy data

Other 300 Level courses

Lecture notes, practice questions and the AI tutor for DTS 314 are available once you sign in.

Sign in to Areté