September 7, 2019

How to get started with SQL

SQL (Standard Query Language) is a programming language used for database filtering and editing. It is used in places like hospitals and libraries. Useful links below.

Tutorial with an online practice environment:
https://www.tutorialrepublic.com/sql-tutorial/sql-get-started.php
https://www.tutorialrepublic.com/codelab.php?topic=sql&file=select-all

Step-by-step tutorial with quizzes:
https://www.w3schools.com/sql/default.asp

If you know R programming, you can also pass SQL queries through R:
https://db.rstudio.com/getting-started/database-queries/

R programming lesson #2: merging datasets (RNA-seq and Human Protein Atlas example)

Lesson goal: take your dataset and add columns from another dataset. You will add columns by matching shared values between the two datasets...