3. Data Acquisition and Integration

Topics, Class Notes and Code Assignments and Side Readings
  • Data Archtecture and Infrastructure
    • Data architecture
    • Data infrastructure: types, compoenents, and aspects
  • Data Integration
    • Major data integration techniques
    • ETL tools
  • Relational database and SQL
    • SQL syntax
    • Basics of relational database
  • Notes and code
  • Practicing SQL

  • Assignment #1: Data Integration
    • This assignment focuses on using SQL to extract information from multiple ralational data sources to create single data file.