Open sqlite_tutorial.md to get started.

This 4-hour data science project will boost your data science confidence through transferrable skills essential for the modern, data-driven job market.

Here you will learn the basics of the: 1) Bash programming language, 2) SQLite database engine, 3) Git for version control, and 4) free static GitHub Pages.

Schedule: Friday, January 13
Monday, June 26 (all times PST)

• 10:00-11:00 AM - Learn basic Bash code to navigate your computer’s file system and create directories and files using pwd, ls, cd, mkdir, and touch commands.

• 11:00-12:00 PM - Build a Git repository to control version tracking with git clone, add, commit, push, and pull.

• 12:00-1:00 PM - Lunch

• 1:00-2:00 PM - Launch SQLite3 and learn to wrangle data with SELECT, FROM, WHERE, GROUP BY, and ORDER BY.

• 2:00-3:00 PM – Use the GitHub repository you build in parts 1-3 and turn it into a simple static webpage with GitHub Pages.

Online only, Zoom link provided upon registration. SUNet sign-in required.

Links to materials:

• BashGitHub
• IntroSQLite
• GitHub Pages

• Basic familiarity with computers
• Sign up for free GitHub account: https://github.com

• Make sure you have the Xcode developer toolset installed. Open a Terminal and type xcode-select --install
• When asked if you want to install the command line developer tools, click "yes/install"

• Install git/gitbash by clicking here: https://git-scm.com/downloads
• Download the file and double-click it to run the installer