scwebd

*==== REST Info: ========================*

*What _is_ REST?* https://www.restapitutorial.com/lessons/whatisrest.html

*What is REST — A Simple Explanation for Beginners, Part 1: Introduction:* https://medium.com/extend/what-is-rest-a-simple-explanation-for-beginners-part-1-introduction-b4a072f8740f

*What is REST — A Simple Explanation for Beginners, Part 2: REST Constraints:* https://medium.com/extend/what-is-rest-a-simple-explanation-for-beginners-part-2-rest-constraints-129a4b69a582

*A Beginner’s Tutorial for Understanding RESTful API:* https://mlsdev.com/blog/81-a-beginner-s-tutorial-for-understanding-restful-api

scwebd

`tree 04-HandlebarsLunch -I "node_modules"`

scwebd

*==== MySQL Resources: ========================*

*List of MySQL Data Types:* http://www.mysqltutorial.org/wp-content/uploads/0211/03/MySQL-Data-Types.jpg

*What the number actually means in INTEGER(number):* https://www.virendrachandak.com/techtalk/mysql-int11-what-does-it-means/

*MySQL ALTER TABLE (add a column, modify a column, drop a column, rename a column or rename a table):* https://www.techonthenet.com/mysql/tables/alter_table.php

*SQL Primary Keys:* https://www.tutorialspoint.com/sql/sql-primary-key.htm

scwebd

* **Instructions**

  * Your assignment is to take these two large sets of data and come up with a method to join them together in order to figure out if a given artist's song and album made it into the charts at the time of their release.

    * HINT: This can be done in a couple different ways using external data as well, but you do have all of the data you need within your database to find the correlations. Give your methods some though before having to rely upon external info.

    * HINT: Remember that MySQL has the ability to combine two or more tables together so long as they share equivalent data. What data is similar between the two lists?

  * Once you have managed to successfully bring the two datasets together, start making queries like those you made earlier to this new table as well.

scwebd

ALTER TABLE top5000 ADD INDEX song (song);

SELECT * from top5000 WHERE song = 'freebird';

scwebd

INSERT INTO top5000 (position, artist, song, year, raw_total, raw_usa, raw_uk, raw_eur, raw_row) VALUES 
(1,"Bing Crosby","White Christmas",1942,39.903,23.929,5.7,2.185,0.54), 
(2,"Bill Haley & his Comets","Rock Around the Clock",1955,36.503,19.961,7.458,5.663,0.76),
(3,"Celine Dion","My Heart Will Go On",1998,35.405,12.636,8.944,23.701,3.61);

SELECT * FROM top5000;

scwebd

*==== Inquirer Info: ================================*

*NPM Documentation:* https://www.npmjs.com/package/inquirer

*Question Types:* https://github.com/SBoudrias/Inquirer.js/#prompt-types

*Examples:* https://github.com/SBoudrias/Inquirer.js/tree/master/packages/inquirer/examples

scwebd

node liri.js concert-this "The Rolling Stones"

node liri.js spotify-this-song "Istanbul (Not Constantinople)"

node liri.js movie-this "Shawshank Redemption"

node liri.js do-what-it-says

scwebd

"Your code must be readable by other programmers.  This is not simply a matter of writing nice comments.  Rather, it requires that you craft the code in such a way that it reveals your intent.  This is hard to do.  Indeed, this may be the most difficult thing a programmer can master." -Robert Martin

scwebd

@channel Please do a `git pull` to get the latest class repo update, and then copy ‘07-firebase’ into your working directory!