Databases

Class Schedules Official Website MigraCode Syllabus How to teach tech

Search…

Databases

Learning Objectives
By the end of this lesson students should be able to
Explain why databases are needed in Web Development
Define what SQL is and what it is used for
Describe what table, rows and columns are used for in a relational database
Install and create a database using PostgreSQL
Create a table in a database using PostgreSQL
Insert data into a table using PostgreSQL
Retrieve data from a table using PostgreSQL
Retrieve data from a table using conditionals in PostgreSQL
List the different kinds of data that can be held in a PostgreSQL database
Add and remove columns in a pre-existing table using PostgreSQL using ALTER
Rename tables and columns in a pre-existing table using PostgreSQL using DELETE
Update rows in a pre-existing table using PostgreSQL using UPDATE
Combine tables together using PostgreSQL using INNER JOIN
Connect a PostgreSQL database to a NodeJS application
Retrieve data from a PostgreSQL database in a NodeJS application
Create an API endpoint that can add data to a database
Write code that effectively validates data before adding it to a database
Be aware of the dangers of SQL injection attacks, and how to avoid them
Create an API endpoint that can retrieve data from a database with multiple parameters
Create an API endpoint that can update data in a database
Create an API endpoint that can delete data in a database
Lessons
1 - Introduction to SQL
2 - SQL with Node
3 - CRUD with SQL and Node
​

3 - Workshop

1 - Introduction to SQL

Last modified 11mo ago

Export as PDF

Copy link

Contents

Learning Objectives

Lessons