Week 11

Lab 9

Monday, Nov 04

GitHub

Objectives

  • Understand reactivity in Shiny
  • Work on project proposal

Databases and SQL

Tuesday, Nov 05

Learning objectives

  • Understand DBMS and terminology
  • Connect to a SQL database
  • Query a database in R
  • Connecting dplyr to a database

Materials


SQL and beyond

Thursday, Nov 07

Learning objectives

  • sqlite3
  • Join tables
  • Create sub queries
  • Working with indices
  • SQL vs NoSQL

Materials


Exercise of the week

No exercise this week. Focus on Homework 6.

Previous
Next