- Course overview
- Search within this course
- What is biocuration?
- Publicly available data
- Data management
- Ontologies
- Curation using text mining
- Website accessibility
- User experience and getting feedback
- Collection complete!
- Your feedback
- Get help and support
All materials are free cultural works licensed under a Creative Commons Attribution 4.0 International (CC BY 4.0) license, except where further licensing details are provided.
SQL for biological data
SQL (Structured Query Language) is a programming language for management of database, which is useful for the kind of big datasets that are often managed and curated by biocurators.
In the following video, Pedro Raposos, Biocurator and Bioinformatician from UniProt, illustrates how you can use SQL to query databases using two simple examples.
You can try out the two examples discussed in the video with this short Google Collab notebook created by Manuel Lera Ramirez, University College London.
For a more general introduction to SQL, you can try this tutorial available online https://www.w3schools.com/sql/.
In the video on the next page, discover some examples of how programming can be used for biocuration.