2 - Git, Markdown, SQL :: STAT447 - Data Science Programming Methods

DSPM > Lectures by Topics > 2 - Git, Markdown, SQL

2 - Git, Markdown, SQL

Git is the version control system these days: We learn what it is and how to use it
Plenty of simply examples for you to try
- Starting from ‘git as a time machine’ allowing access to earlier versions of files
- Branches from simple ‘will this work’ to separating alternate work
- Next are merging, then remote operations, pull requests
- We also get to GitHub, the most promiment and visible hosting site
- GitHub enables social coding and collaboration
Markdown is a very powerful and popular “mark-up” language for text
- We will learn about markup, separating content from style, and see examples
- Key idea here: Markup is independent of rendered output
- Excellent topic once again for self-study and experimentation
- pandoc used as universal converter to/from
- RMarkdown convenience wrapper around pandoc calls
  - e.g. to Javascript/HTML for (dynamic / web) presentations
  - e.g. to pdf for printable writeups, presentations, books, …
- Embedding of code (simpler Literate Programming)
SQL (Structured Query Language) is maybe the most common data processing language
- We will learn the basics of relational daya and schema
- SQL commands: select; where; select distinct; select limit
- SQL command join and its variants for combining table
- SQL command group by for grouped operations