DTS 3143 units300 LevelFirst Semester

Data Management I

B.Sc. Data Science, University of Uyo

DTS 314 (Data Management I) is a 3-unit, 300 Level course taught in the First Semester at the University of Uyo, Akwa Ibom State, Nigeria.

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

DTS 314 — questions and answers

What is DTS 314 at the University of Uyo?
DTS 314 (Data Management I) is a 3-unit, 300 Level course taught in the First Semester at the University of Uyo, Akwa Ibom State, Nigeria. 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.
What topics are covered in DTS 314?
The DTS 314 outline covers 9 topics: Review of the relational model and relational algebra; Advanced SQL: window functions, common table expressions, recursive queries, set operations; Views, stored procedures, triggers and user-defined functions; Physical design: storage structures, indexing (B-tree, hash), and when an index hurts; Query processing and optimisation; reading an execution plan; Transactions: ACID properties, concurrency control, locking, isolation levels and deadlock; Recovery, backup strategies and write-ahead logging; Database security: privileges, roles, injection prevention and encryption at rest; Distributed databases and NoSQL families: key-value, document, column-family and graph stores.
What textbooks are recommended for DTS 314?
Recommended reading for DTS 314: Database System Concepts by Silberschatz, Korth & Sudarshan; SQL Performance Explained by Markus Winand.
How do I 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
Where can I find DTS 314 lecture notes and past questions?
Areté (https://www.aretecyb.tech/courses/dts-314) carries 2 recommended textbooks for DTS 314, plus an AI tutor that has read the outline. It is free for University of Uyo students — sign in with your email, no password.

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é