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/

Setting up Ubuntu 24.04.x LTS desktop and server, RStudio server, and JypyterLab at home

Why?  Set up a Linux server computer on a home network if: You want to run code that takes a long time to complete. Let it run on the server...