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/

How to format final figures for publication

General figure guidelines File types and file sizes TIFF images with LZW compression to reduce the file size PDF files for vector images Not...