Mon Jun 18

Data Structures

9 – 12h Teaching

Teacher:

  • Franck

Goals

  • I understand the idea of "Data Modeling"
  • I have structured data in YAML, XML, JSON, CSV
  • I have successfully modeled Flights data structures


Useful online resources:

Transform between YAML, XML, JSON, CSV:

Draw data model online:

Open Data about Flights:


Slides (course and exercises)

PowerCoders - Database - Day 1

open speakers-note (S) to copy/paste the code

12 – 13.30h Lunch

13.30 – 17h

  • Sylvain

Data Structures Exercises

  • Afternoon exercise - Install MAMP with MySQL and load some data
    1. Install MAMP
    2. Connect to MySQL from the command line
    3. Download the OpenFlights project to get the scripts to create and load data
    4. Run the scripts from the MySQL command line and list the tables

You can look at the files. We will use this database tomorrow.



If you want to go further (not required for next course)