Mide-400 Today

| Lab | Goal | Deliverable | |-----|------|-------------| | Lab 2 | Normalised schema design | ER diagram + SQL DDL | | Lab 4 | Concurrency control | Screenshot of deadlock detection & fix | | Lab 6 | Data cleaning script | Python notebook on GitHub | | Lab 7 | Spark aggregation job | spark-submit script + output CSV | | Lab 8 | Kafka → Spark streaming | Docker‑Compose file + streaming log | | Lab 10 | Lakehouse conversion | Parquet/Delta table + query benchmark | | Lab 11 | Airflow DAG | DAG file + Airflow UI screenshot | | Lab 12 | CI/CD pipeline | GitHub Actions YAML + Docker image link |

| Assessment | Weight | Format | |------------|--------|--------| | (Weeks 2, 4, 8) | 10 % | 15‑minute online MCQs (SQL, theory) | | Mid‑term Exam | 25 % | 90‑minute closed‑book (design & short‑answer) | | Lab Grades (cumulative) | 20 % | Lab reports + code repository | | Capstone Project | 35 % | As described above | | Participation (forum, office‑hours) | 10 % | Attendance, contribution to discussion board | MIDE-400

In various entertainment archives, MIDE-400 serves as a unique product code or "ID" used to catalog specific titles for digital distribution and inventory management. | Lab | Goal | Deliverable | |-----|------|-------------|