Introduction to SQL and relational DBMS
September 7
Responsible: A. Belikov
Lecture outline
Start and stop mysql server, create database, ingest data, simple operations, data processing with SQL.
Use mySQL and relational database to cross-identify catalogs.
Werkcollege tasks
You can download a copy of the tasks as a pdf copy, or an original PowerPoint presentation.
Description of tasks with solutions step-by-step in pdf.
Additional tasks for homework (pdf).
Necessary materials to werkcollege
How to start using mysql from python
- Download additional libraries you need for python: add_python_libs.tgz
- Select some local directory, for example, /Users/users/<your_name>/libs and unpack the packages there with command
tar -xzvf add_python_libs.tgz (please, note that an additional subdirectory python will be created)
- include the path to these libraries in the search path of python: setenv PYTHONPATH /Users/users/<your_name>/libs/python
- now you can use MySQLdb module in your python programs