Databases are one of the 3 core systems (Database, API, UI) that make web apps work. The most common database systems use the language SQL (Structured Query Language). In this course, we install and use the MySQL database system, learn the SQL language, and use MySQL to serve as the database for an ExpressJS web app.
MySQL download page: https://dev.mysql.com/downloads/
Mac download instruction video: https://www.youtube.com/watch?v=2cvH0HRjZF8
W3Schools SQL data types: https://www.w3schools.com/sql/sql_datatypes.asp
W3Schools SQL tutorial: https://www.w3schools.com/sql/default.asp00:00 Intro
01:05 Server setup
04:31 Database connection
15:29 API design
18:37 Using EJS to render the webpage
22:12 Sending form data to the API
27:35 Executing SQL queries from the server
29:16 Table design
32:59 Callback hell, the pyramid of doom
36:45 Solution: implement a promise
43:10 Saving messages
49:03 Showing messages on the webpage
56:49 Outro
1 Comments