Internship
Student login
← Data Science learning path
Data Science · Module 3 of 10

Data collection and SQL

Gather data from files, databases and APIs.

📖 Key ideas

  1. Sources: CSV/Excel files, databases, APIs, web data, surveys.
  2. SQL queries pull data: SELECT, WHERE, GROUP BY, JOIN.
  3. APIs return JSON; use requests in Python.
  4. Respect privacy, terms of use and consent.
  5. Document data sources and dates.
💡 Real-life example: Collecting data is grocery shopping: the right ingredients from trusted shops, with receipts.
SQLDatabase query language
APIProgrammatic data source
Data sourceWhere data comes from
ConsentPermission to use personal data