Javascript Notebook
  • Introduction
  • Intro to JavaScript
    • Section 1 - Getting Started
    • Section 2 - Execution Contexts and Lexical Environements
    • Section 3 - Types and Operators
    • Section 3 Part 2 - Closures and Callbacks
    • Section 4 - Objects and Functions
    • Section 5 - Object Oriented Javascript and Prototypal Inheritance
    • Section 6 - Building Objects
    • Section 7 - Odds and Ends
    • Section 8 - Examining Famous Frameworks and Libraries
    • Section 9 - Let's Build a Framework or Library!
  • Midterm Review
  • Final Review
  • jQuery
    • Section 1 - Selectors
    • Section 2 - Events
    • Section 3 - Effects
  • Node.js
    • The Node Core
    • Modules, Exports, and Require
    • Events and the Event Emitter
    • Databases and SQl
  • D3.js
    • Diving In
    • Bar Chart
    • Creating A Complex Bar Chart
Powered by GitBook
On this page

Was this helpful?

  1. Node.js

Databases and SQl

PreviousEvents and the Event EmitterNextD3.js

Last updated 5 years ago

Was this helpful?

  • 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: