Skip to content

Latest commit

 

History

History
24 lines (20 loc) · 488 Bytes

midterm_review.md

File metadata and controls

24 lines (20 loc) · 488 Bytes
Raw

Midterm Review

Resources

  1. Midterm review questions
  2. Common points of confusion notebook

Python

  1. Functions
  2. if/elif
  3. Integer division
  4. Methods

Databases

You should have a reason for everything you include in a query

  1. Joins (only use the ones you need)
    • Joins are about table structure
    • Only include the tables you need
  2. Nested queries (keep them simple)
  3. Extra aggregation (only use it if you have a reason to)