Skip to content

Latest commit

 

History

History
19 lines (17 loc) · 838 Bytes

backend-sql.md

File metadata and controls

19 lines (17 loc) · 838 Bytes

SQL (Fill out more)

  • What is an inner join? Use the Venn Diagram to help, but allows you to bring in extra columns from another table so long as there is a key to match both tables
    • An inner join is the intersection of data from both table A and table B
  • What’s a left join, right join?
    • Left joins, right joins are basically outer joins that get all the data from both table A and table B plus the data from either the left (table A) or right (table B)
  • What is an outer join?
    • A full outer join (besides left/right) gets all table data from both A & B tables
  • What’s a trigger?
  • What’s a foreign key?
  • What’s the purpose of an index?
  • What’s normalization?
  • What is a trigger? What's an event?
  • Largest db you worked with?
  • What is ORM?
  • How would you optimize a database?
    • Indexes
    • Redundancy