Learning Objectives

• understanding when and why a database is useful
• extracting specific data
• manipulating the selected data
• combining different datasets
• creating your own database

Using databases and SQL

• Selecting Data
• Sorting and Removing Duplicates
• Filtering
• Calculating New Values
• Missing Data
• Aggregation
• Combining data
• Data Hygiene
• Creating and Modifying Data

Bibliography

• SQL tutorial at w3schools.com
• Any textbook on plain SQL

Online databases

Here you can find some publicly accessible, online SQL interfaces to open databases.

• Wikipedia database, (dabatase schema)
• Gene Ontology, (schema and manual)

A list of academic databases can be found on Wikipedia. Check the free ones (by sorting the table) and see if in your filed there is a database you can query online or download an query locally.