๐Ÿ‡ฎ๐Ÿ‡ณ Data Science & Machine Learning ยท subject

Data Science & Machine Learning Data Engineering, Deployment and Projects Syllabus

The Data Engineering, Deployment and Projects syllabus for Data Science & Machine Learning in full: 4 chapters, 12 topics and 22 sub-topics, every one listed below, plus 51 Data Engineering, Deployment and Projects flashcards with answers.

4Chapters
12Topics
22Sub-topics
51Flashcards

Data Engineering, Deployment and Projects syllabus: all 4 chapters

Expand any chapter to see its topics and sub-topics.

  1. Databases and SQL for Data Science

    3 topics
    • Relational Concepts
      • Tables, keys and relationships
    • SQL Querying
      • SELECT, WHERE and ORDER BY
      • JOINs and GROUP BY
      • Subqueries and aggregate functions
    • Connecting Python to Databases
      • SQLAlchemy and connectors
  2. Big Data and Data Pipelines

    3 topics
    • Big Data Concepts
      • Volume, velocity and variety
      • Hadoop and Spark overview
    • ETL Workflows
      • Extract, transform and load
    • Web Scraping and APIs
      • BeautifulSoup and requests
      • Consuming REST APIs
  3. Model Deployment and MLOps

    3 topics
    • Model Serialization
      • Pickle and joblib
    • Building ML APIs
      • Flask and FastAPI
      • Streamlit apps
    • MLOps Fundamentals
      • Version control with Git
      • Model monitoring and retraining
      • Containerization with Docker
  4. Capstone Projects and Best Practices

    3 topics
    • End-to-End Project Lifecycle
      • Problem framing and data collection
      • Modeling and evaluation
      • Reporting results
    • Reproducibility and Documentation
      • Notebooks and environments
    • Ethics and Responsible AI
      • Bias and fairness
      • Data privacy

Data Science & Machine Learning Data Engineering, Deployment and Projects flashcards โ€” 51 questions with answers

  1. In a relational database, what is a primary key?

    A column (or set of columns) that uniquely identifies each row in a table. It cannot be NULL and must be unique.

  2. What is a foreign key in relational databases?

    A column in one table that references the primary key of another table, enforcing referential integrity between the two tables.

  3. What do the ACID properties of a transaction stand for?

    Atomicity, Consistency, Isolation, and Durability.

  4. What is database normalization?

    The process of organizing tables to reduce data redundancy and improve integrity by decomposing them into related tables (e.g., 1NF, 2NF, 3NF).

  5. What distinguishes a one-to-many from a many-to-many relationship?

    In one-to-many, one row in table A relates to many rows in table B. In many-to-many, rows in both tables relate to multiple rows in the other, requiring a junction (bridge) table.

  6. What is the difference between the SQL WHERE and HAVING clauses?

    WHERE filters individual rows before aggregation; HAVING filters groups after aggregation (used with GROUP BY).

  7. What does an INNER JOIN return versus a LEFT JOIN?

    INNER JOIN returns only rows with matching keys in both tables. LEFT JOIN returns all rows from the left table plus matched rows from the right (NULLs where no match).

  8. What is the logical order of execution of SQL clauses?

    FROM โ†’ WHERE โ†’ GROUP BY โ†’ HAVING โ†’ SELECT โ†’ ORDER BY โ†’ LIMIT.

  9. Name four common SQL aggregate functions.

    COUNT, SUM, AVG, MIN/MAX.

  10. What is the difference between WHERE and the GROUP BY clause's purpose?

    WHERE filters rows; GROUP BY collapses rows into groups so aggregate functions can be applied per group.

  11. What is a SQL subquery?

    A query nested inside another query, used in clauses like WHERE, FROM, or SELECT to compute intermediate results.

  12. What is the difference between DELETE and TRUNCATE in SQL?

    DELETE removes rows (optionally filtered with WHERE) and is logged/rollbackable; TRUNCATE quickly removes all rows, is minimally logged, and resets the table.

  13. In Python, what is a database connection cursor used for?

    A cursor is an object used to execute SQL statements and fetch query results row by row from a database connection.

  14. Why should you use parameterized queries when connecting Python to a database?

    To prevent SQL injection attacks and let the driver handle proper escaping/typing of input values.

  15. What is SQLAlchemy in the Python ecosystem?

    A Python SQL toolkit and Object-Relational Mapper (ORM) that lets you interact with databases using Python objects and a unified API across DB engines.

  16. Which pandas function reads SQL query results into a DataFrame?

    pandas.read_sql (or read_sql_query / read_sql_table), given a query and a connection/engine.

  17. What are the classic '3 Vs' of Big Data?

    Volume (scale of data), Velocity (speed of generation/processing), and Variety (different data types/formats).

  18. What is Apache Hadoop's core role in big data?

    A framework for distributed storage (HDFS) and distributed processing (MapReduce) of large datasets across clusters of commodity hardware.

  19. What is the main advantage of Apache Spark over Hadoop MapReduce?

    Spark performs in-memory computation, making it much faster for iterative and interactive workloads than disk-based MapReduce.

  20. What is the difference between a data lake and a data warehouse?

    A data lake stores raw data in many formats (schema-on-read); a data warehouse stores structured, processed data optimized for querying (schema-on-write).

Show the other 31 Data Engineering, Deployment and Projects flashcards
  1. What does the MapReduce programming model consist of?

    A Map phase that processes and emits key-value pairs in parallel, and a Reduce phase that aggregates values by key.

  2. What does ETL stand for, and what is its order?

    Extract, Transform, Load: extract data from sources, transform/clean it, then load it into a target system.

  3. How does ELT differ from ETL?

    In ELT, data is Extracted and Loaded into the target (often a data warehouse/lake) first, then Transformed in place using the target's compute.

  4. What is idempotency in the context of ETL/data pipelines?

    The property that running a pipeline step multiple times produces the same result, preventing duplicate or inconsistent data on re-runs.

  5. What is a DAG in workflow orchestration tools like Apache Airflow?

    A Directed Acyclic Graph defining tasks and their dependencies, with no cycles, that determines execution order.

  6. What is the purpose of the Transform step in ETL?

    To clean, validate, deduplicate, reformat, aggregate, and enrich raw data so it conforms to the target schema and quality requirements.

  7. What is web scraping?

    The automated extraction of data from websites by programmatically requesting pages and parsing their HTML content.

  8. Which Python libraries are commonly used together for web scraping?

    requests (to fetch pages) and BeautifulSoup (to parse HTML); Scrapy and Selenium are used for larger/dynamic scraping.

  9. What does a REST API HTTP GET request do versus a POST request?

    GET retrieves data from a resource without modifying it; POST submits data to create or process a resource on the server.

  10. What does HTTP status code 200 versus 404 indicate?

    200 means OK/success; 404 means the requested resource was Not Found.

  11. What is the role of a robots.txt file in web scraping ethics?

    It specifies which parts of a site crawlers are allowed or disallowed from accessing; respecting it is part of ethical/legal scraping.

  12. What data format do most modern web APIs return?

    JSON (JavaScript Object Notation), a lightweight, human-readable key-value/text format.

  13. What is model serialization in machine learning?

    The process of saving a trained model's parameters/structure to disk (a file) so it can be stored, shared, and reloaded for inference later.

  14. What Python module is commonly used to serialize ML models, and what is a key caution?

    pickle (or joblib for large numpy arrays). Caution: never unpickle data from untrusted sources, as it can execute arbitrary code.

  15. Why is joblib often preferred over pickle for scikit-learn models?

    joblib is more efficient at serializing objects that carry large NumPy arrays, producing faster, smaller dumps.

  16. What is a common cross-language/portable format for serializing ML models?

    ONNX (Open Neural Network Exchange), which lets models be exported and run across different frameworks and runtimes.

  17. What is the typical role of a web framework like Flask or FastAPI in serving an ML model?

    It exposes the model's predict function via an HTTP endpoint so clients can send input data and receive predictions over the network.

  18. What is a key advantage of FastAPI for building ML APIs?

    It is high-performance (async) and provides automatic data validation (via Pydantic) and auto-generated interactive API docs (Swagger/OpenAPI).

  19. What is the typical request/response flow for an ML prediction API endpoint?

    Client sends input features (usually JSON) โ†’ API validates/preprocesses โ†’ model.predict() runs โ†’ API returns the prediction as JSON.

  20. Why is containerization (e.g., Docker) commonly used when deploying ML APIs?

    It packages the model, code, and dependencies into a portable, reproducible image that runs consistently across environments.

  21. What does MLOps stand for and aim to do?

    Machine Learning Operations: applying DevOps-style practices (CI/CD, automation, monitoring) to reliably deploy and maintain ML models in production.

  22. What is model drift (data/concept drift) in production ML?

    Degradation of model performance over time because the live data distribution or input-output relationship changes from the training data.

  23. What is a model registry in MLOps?

    A central versioned store for trained models, tracking versions, metadata, stage (staging/production), and lineage.

  24. What is the purpose of a feature store in MLOps?

    To centrally store, manage, and serve consistent feature data for both model training and online inference, avoiding training-serving skew.

  25. What does CI/CD enable in an MLOps pipeline?

    Continuous Integration/Continuous Delivery automates testing, building, and deploying code and models, enabling fast, reliable, repeatable releases.

  26. What are the main stages of an end-to-end ML project lifecycle?

    Problem definition โ†’ data collection โ†’ data cleaning/EDA โ†’ feature engineering โ†’ model training โ†’ evaluation โ†’ deployment โ†’ monitoring/maintenance.

  27. Why is monitoring a critical final stage of the ML project lifecycle?

    Because deployed models degrade over time (drift, data changes); monitoring detects performance drops and triggers retraining.

  28. What is reproducibility in a data science project?

    The ability to obtain the same results by re-running the same code on the same data, typically achieved via version control, fixed random seeds, and pinned dependencies.

  29. Name three practices that improve reproducibility in ML projects.

    Version controlling code/data (Git, DVC), setting random seeds, and pinning dependency versions (e.g., requirements.txt or environment.yml).

  30. What are key principles of ethical and responsible AI?

    Fairness, accountability, transparency/explainability, privacy, and avoiding/mitigating bias in data and model outcomes.

  31. What is algorithmic bias and a common source of it?

    Systematic unfair outcomes produced by a model, often caused by biased or unrepresentative training data reflecting historical or sampling inequities.

Data Science & Machine Learning Data Engineering, Deployment and Projects FAQ

What is in the Data Science & Machine Learning Data Engineering, Deployment and Projects syllabus?

Data Science & Machine Learning Data Engineering, Deployment and Projects is split into 4 chapters: Databases and SQL for Data Science, Big Data and Data Pipelines, Model Deployment and MLOps and Capstone Projects and Best Practices. Together they contain 12 topics and 22 sub-topics.

How many chapters are in Data Science & Machine Learning Data Engineering, Deployment and Projects?

4 chapters, containing 12 topics and 22 sub-topics. The largest chapter is Databases and SQL for Data Science, with 3 topics.

Are there flashcards for Data Science & Machine Learning Data Engineering, Deployment and Projects?

Yes โ€” a 51-card Data Engineering, Deployment and Projects deck, printed in full in the flashcards section of this page and available in the Examius app with spaced repetition. The free plan covers one exam of your choice, including its flashcards; Examius Pro, a one-time purchase, unlocks every other exam and deck.