Databases and SQl

• Databases

  • Store data

  • Change data

  • Grab data

  • Tabularized

    • Columns and rows

  • Relational Databases

    • Not just one table

    • Connect two different tables with an id

    • Avoiding repeating information

• SQL (structured query language) is what we then use to ask questions about the database. Using the three different tables above, we can get back information like this:

• Javascript can treat this table an as object that matches the data.

[
  {
    ID: 1
    Firstname: 'John',
    Lastname: 'Doe',
    Address: '555 Main St.'
  },
  {
     ID: 2,
     Firstanme: 'Jane'

     ...
  }
  ..
]

Node and MySQL: