Powercoders Resources

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:

https://codebeautify.org/

Draw data model online:

https://yuml.me/diagram/scruffy/class/draw

Open Data about Flights:

https://openflights.org/data.html

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)

Read about YAML and comparison with XML and JSON: https://en.wikipedia.org/wiki/YAML
Look at an example reading XML data from PHP: https://www.w3schools.com/php/php_xml_simplexml_get.asp

Report abuse