Code Lab BetaBUILD. RUN. DISCOVER.

Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.

SQL / POSTGRESQL / Learn / LESSON 01

CREATE TABLE and types.

About 5–10 minutes

CREATE TABLE names a table and its typed columns. Common types: INTEGER, TEXT, NUMERIC(10,2). The database starts empty — create books with the requested columns.

Small example:

CREATE TABLE books (id INTEGER, title TEXT, pages INTEGER);

Your lesson

Create table books with columns id INTEGER, title TEXT, pages INTEGER.

The database starts empty. Grading checks the schema/data you create across variants.

Expected verify columns: column_name · row order is checked

Expected final state (displayed data):

Loading…

CREATE TABLE names a table and its typed columns. Common types: INTEGER, TEXT, NUMERIC(10,2). The database starts empty — create books with the requested columns.

lesson_01.sqlSQL · POSTGRESQL

Loading the runtime… The first launch may take a little longer.

… 0/20000

STANDBY

query.resultIDLE

> waiting for SELECT…
> result: —
▌

SQL

QUERY STANDBY

01The statement executes successfully

02Final state matches the displayed data

03The same holds for the additional datasets

ConsoleWrite the code. Bring it online.

›

Progress in Profile →

SQL / POSTGRESQLKALKULATORI.BG

Code Lab BetaBUILD. RUN. DISCOVER.

Code Lab is in development. New lessons and improvements are on the way. Progress can be deleted.

Loading…

SQL / POSTGRESQLKALKULATORI.BG