Seminar 2 - Database Handling

Date: 2009-11-17
Presentation: download

Topics:
(1) type of databases, main concepts of relational databases
(2) introduction to the SQL language
(3) mySQL database server for Windows
(4) example python code, using mySQL (upload and query network data, create diagramm; you will need the mysql-python and the matplotlib python packages to run it) (download)


Interesting links:
MySQL Community server 5.1: http://dev.mysql.com/downloads/mysql/5.1.html
SQL on wiki: http://en.wikipedia.org/wiki/SQL
SQL tutorial on W3 schools: http://www.w3schools.com/SQl/default.asp
MySQL 5.1 reference manual: http://dev.mysql.com/doc/refman/5.1/en/index.html
mysql-python package installer (needs to be installed for running the example code): http://sourceforge.net/projects/mysql-python/
matplotlib package installer (needs to be installed for running the example code): http://sourceforge.net/projects/matplotlib/
matplotlib project home page: http://matplotlib.sourceforge.net/