UUY-DTS 4122 units400 LevelFirst Semester

Data Management II

B.Sc. Data Science, University of Uyo

UUY-DTS 412 (Data Management II) is a 2-unit, 400 Level course taught in the First Semester at the University of Uyo, Akwa Ibom State, Nigeria.

Enterprise-scale data management, continuing DTS 314: data architecture, pipelines and orchestration, master data and quality management, governance, and the modern data stack.

On Areté, UUY-DTS 412 comes with

  • 3 recommended textbooks
  • an AI tutor that has read this course’s outline and notes
Sign in to study UUY-DTS 412

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

Course outline

  1. 01Enterprise data architecture: operational vs analytical systems
  2. 02Data integration: ETL vs ELT, batch vs streaming ingestion
  3. 03Pipeline orchestration and scheduling; DAGs and tools such as Airflow
  4. 04Data lakes, data warehouses and the lakehouse pattern; file formats (Parquet, Avro, ORC)
  5. 05Master data management and reference data
  6. 06Data quality: dimensions, profiling, validation rules and monitoring
  7. 07Metadata management, data catalogues and data lineage
  8. 08Data governance: ownership, stewardship, policy and regulatory compliance
  9. 09Data lifecycle management: retention, archiving and secure disposal

Recommended textbooks

  • Fundamentals of Data Engineering — Joe Reis & Matt Housley

    The best current overview of the whole discipline

  • DAMA-DMBOK: Data Management Body of Knowledge — DAMA International

    2nd ed. — the governance framework this course follows

  • The Data Warehouse Toolkit — Ralph Kimball & Margy Ross

    3rd ed. — read alongside UUY-DTS 423

How to pass UUY-DTS 412

  • Build one real pipeline end to end (ingest → transform → store → schedule), even a small one. Data engineering is understood by doing
  • Know why Parquet beats CSV for analytics (columnar, compressed, typed) — a favourite short-answer question and a genuinely useful fact
  • Data quality dimensions (accuracy, completeness, consistency, timeliness, validity, uniqueness) are examinable as a list — memorise them
  • Governance sounds bureaucratic until you inherit an undocumented database. Frame your answers around that reality

UUY-DTS 412 — questions and answers

What is UUY-DTS 412 at the University of Uyo?
UUY-DTS 412 (Data Management II) is a 2-unit, 400 Level course taught in the First Semester at the University of Uyo, Akwa Ibom State, Nigeria. Enterprise-scale data management, continuing DTS 314: data architecture, pipelines and orchestration, master data and quality management, governance, and the modern data stack.
What topics are covered in UUY-DTS 412?
The UUY-DTS 412 outline covers 9 topics: Enterprise data architecture: operational vs analytical systems; Data integration: ETL vs ELT, batch vs streaming ingestion; Pipeline orchestration and scheduling; DAGs and tools such as Airflow; Data lakes, data warehouses and the lakehouse pattern; file formats (Parquet, Avro, ORC); Master data management and reference data; Data quality: dimensions, profiling, validation rules and monitoring; Metadata management, data catalogues and data lineage; Data governance: ownership, stewardship, policy and regulatory compliance; Data lifecycle management: retention, archiving and secure disposal.
What textbooks are recommended for UUY-DTS 412?
Recommended reading for UUY-DTS 412: Fundamentals of Data Engineering by Joe Reis & Matt Housley; DAMA-DMBOK: Data Management Body of Knowledge by DAMA International; The Data Warehouse Toolkit by Ralph Kimball & Margy Ross.
How do I pass UUY-DTS 412?
Build one real pipeline end to end (ingest → transform → store → schedule), even a small one. Data engineering is understood by doing Know why Parquet beats CSV for analytics (columnar, compressed, typed) — a favourite short-answer question and a genuinely useful fact Data quality dimensions (accuracy, completeness, consistency, timeliness, validity, uniqueness) are examinable as a list — memorise them Governance sounds bureaucratic until you inherit an undocumented database. Frame your answers around that reality
Where can I find UUY-DTS 412 lecture notes and past questions?
Areté (https://www.aretecyb.tech/courses/uuy-dts-412) carries 3 recommended textbooks for UUY-DTS 412, 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 400 Level courses

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

Sign in to Areté