SQL

SQ01 - SQL Basic Syntax

Junior

You should know how to construct basic SQL queries for creating, reading, updating and deleting data.

You shoud know how to read records using select:

You should know how to perform simple aggregation:

You should know how to insert records with insert.

You should know how to update records with update.

You should know how to delete records with delete.

You should understand the purpose of null.

Getting Things Done in Next.js:

SQLBolt:

Junior

You should understand the purpose of foreign keys and how to construct queries that read data from multiple tables.

You should understand the purpose of foreign keys.

You should understand how to perform inner joins.

You should understand how to perform other joins:

Getting Things Done in Next.js:

SQLBolt:

PostgreSQL Documentation:

Junior

You should understand how to create, alter and delete tables.

You should understand how to create tables with create table.

You should understand how to alter tables with alter table.

You should understand how to drop tables with drop table.

SQLBolt:

The are no optional resources for this skill.