Week 3 - Markdown, SQL I :: STAT430 - Data Science Programming Methods

DSPM > Lectures > Week 3 - Markdown, SQL I

Week 3 - Markdown, SQL I

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
Commands introduced: select; where; select distinct; select limit
To be followed in Week 4 with SQL II