Mide-400 =link= -

I can refine the tone and depth once I know your specific focus!

| Week | Theme | Core Concepts | Lab / Assignment | |------|-------|----------------|-------------------| | 1 | | ER modelling, relational algebra, SQL basics | Mini‑SQL quiz (in‑class) | | 2 | Advanced Normalisation & Physical Design | BCNF, decomposition, indexing, partitioning | Design a normalized schema for a sample e‑commerce dataset | | 3 | Query Optimisation | Cost‑based optimisation, EXPLAIN, statistics | Write and optimise 5 queries; compare plans | | 4 | Transaction Management & Concurrency | ACID, isolation levels, locking, MVCC | Simulate deadlocks in PostgreSQL; resolve them | | 5 | NoSQL Overview | Key‑value, Document, Column‑family, Graph DBs | Implement a simple CRUD app on MongoDB | | 6 | Data Integration Foundations | Schema matching, data cleaning, ETL basics | Clean a noisy CSV using Python/pandas; generate a report | | 7 | Batch Processing with Spark | RDDs, DataFrames, SparkSQL, Catalyst optimiser | Build a Spark job that aggregates click‑stream data | | 8 | Streaming & Real‑Time Ingestion | Kafka fundamentals, Structured Streaming, windowing | Set up a Kafka producer/consumer pair; stream to Spark | | 9 | Data Modelling for Analytics | Star & Snowflake schemas, slowly changing dimensions | Model a sales warehouse; load sample data | |10 | Data Lake & Lakehouse Concepts | Delta Lake, Apache Iceberg, storage formats (Parquet, ORC) | Convert raw JSON logs into a Delta Lake table | |11 | Orchestration & Workflow | Airflow DAGs, task dependencies, retries | Create an Airflow DAG that runs the ETL pipeline from weeks 6‑9 | |12 | Containerisation & CI/CD for Data Pipelines | Docker, Docker‑Compose, GitHub Actions, Helm basics | Containerise the Spark job + Airflow; push to a test registry | |13 | Performance Tuning & Monitoring | Metrics, Prometheus‑Grafana, query‑plan hints | Profile a slow query; apply indexes & partitioning to improve | |14 | Emerging Topics & Future Trends | Cloud‑native warehouses (Snowflake, BigQuery), Data Mesh, ML‑ops | Guest lecture / student‑led lightning talks | |15 | Project Presentations & Final Exam Review | – | Students demo their end‑to‑end pipelines; Q&A | MIDE-400

Modern Irish drama (MIDE) functions as a site of negotiation between the "imagined community" of Irish nationalism and the lived reality of the individual. I can refine the tone and depth once

The MIDE-400 has become a cultural phenomenon, with its influence extending beyond the realm of Japanese adult cinema. The film's popularity has sparked conversations about [insert topics, e.g., relationships, intimacy, censorship]. Its impact on the industry has been significant, with many regarding it as a [insert adjective, e.g., groundbreaking, influential]. MVCC | Simulate deadlocks in PostgreSQL

Explore how Beckett strips away specific Irish geography to comment on the universal human condition. 3. Conclusion

Stay tuned for future updates on the MIDE-400, and join the conversation by sharing your thoughts and questions in the comments below.