Week 3: Task Runners, Automating Queries, and the Basics of SQL

• What is a build system or task runner?
• Project Structure
• Basics of SQL

Learning Outcomes

• Experience using CRSP data Let’s replicate the CRSP value weighted market index and the S&P 500 index.

• Task Runners Now, discuss incorporating automated data downloads into our workflow. Discuss Build Systems and Task Runners

• Query Automation We’ll then put these two concepts together to demonstrate how to automate a data query from a database.

• Basic of SQL In our query automation discussion, we’ll discuss some of the very basics of SQL—enough to allow us to make simple joins in our queries.

Agenda

• Discuss HW 3

  • Start HW 3 together.

• Basics of SQL

• Task Runners

• Introduction to “Blank Project” Template