Skip to content

IT4065C: Data Technologies Administration

Open the course website for searchable, mobile-friendly lab instructions and student/instructor navigation.

Author: Isaac K. Nti. Cite this repository.

Learn to classify, model, protect and evaluate a synthetic retail data platform. All required repository materials for the local labs are included. Installation requires internet access, Ubuntu/WSL, sudo permission and the packages described in the setup guide. No institutional account or paid service is required.

Course checks

Start here

Choose Windows with WSL2 or native Ubuntu, then follow the single installation route there. Ubuntu 24.04 is recommended; 22.04 is also supported. Other Linux distributions and macOS can use an Ubuntu VM; their native installation routes are not verified. The validation record names tested environments.

Setup automatically performs Lab 1's technical checks. After installation, complete its writing activity, then Labs 2–7 in order. Labs 8–15 are optional. Use the required course path for the complete sequence, including the short discussions and capstone, or the self-study guide to choose a personal learning scope. You do not need to read every reference page first.

For help while learning, use the foundations bridge, glossary, or setup and recovery reference. The documentation index holds curricular and maintenance references; these are not additional student assignments.

What this environment demonstrates

Raw synthetic records flow through dbt staging, core and reporting models. Separate database logins demonstrate allow/deny behavior. Lab 6 distinguishes observed query outcomes from fabricated incident data. Core Lab 7 addresses AI governance. Optional labs address retention/deletion and snapshot staleness. The snapshot exercise is explicitly single-instance; it is not a multi-cluster deployment.

The supported setup is disposable and local. It is not a production deployment or a shared university database. Do not import real student/customer data. Submissions and generated logs stay private; do not open public issues with them.

Original code: MIT. Original curriculum: CC BY 4.0. These licenses exclude University and third-party materials unless expressly stated otherwise; see the ownership and licensing notice.

Institutional context and instructional authorship

IT4065C is offered by the University of Cincinnati School of Information Technology; consult its official course descriptions for public institutional information. This independently maintained teaching repository contains instructional materials developed by Isaac K. Nti; see AUTHORS.md for the full institutional, authorship and licensing notice.