Manual Override: Linux & SQL

A hands-on introduction to the command line and SQL. You type the commands. No videos, no syntax tables to memorise. Each lesson hands you real material and a question you have to answer yourself, and you answer it by typing real commands. Get one wrong and you get a real error message, worded the way a real terminal words it. WHAT YOU LEARN · Filesystem: pwd, ls (with -a / -R), cd, cat, find · Text: head, tail (with -n +N / -n -N), wc, sort, uniq · Search: grep, with -i / -R / -F / -n and regular expressions · Compare and verify: diff (normal and -u unified format), sha256sum · SQL: SELECT, WHERE, ORDER BY, LIKE, JOIN, GROUP BY / COUNT / HAVING · One habit running through all of it: any conclusion should be something a stranger can re-run command by command HOW THE COURSE IS BUILT Eleven lessons, each with one answer you have to find for yourself. The material is a virtual filesystem…