Class Schedules
Official Website
MigraCode Syllabus
How to teach tech
Search…
Welcome to the MigraCode Volunteer Guide
General information
About MigraCode
Working with our students
Volunteering types
Coding Course
Class Information
Class Example
Teaching instructions
Introduction
HTML/CSS
JavaScript I
Javascript II
Javascript III
React
NodeJS
Databases
1 - Introduction to SQL
2 - SQL with Node
3 - CRUD with SQL and Node
Professional Skills
Basic Computer Literacy Course
Teaching instructions
Useful Links
Class Schedules
Official Website
MigraCode Syllabus
How to teach tech
Powered By
GitBook
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
​
Previous
3 - Workshop
Next
1 - Introduction to SQL
Last modified
11mo ago
Export as PDF
Copy link
Contents
Learning Objectives
Lessons