CloudVision PostgreSQL Mastery
Level 1 · Foundations
postgres
· 0 tables · 0 rows
0/21
reset
enrol to run
Mission & Theory
Creating Your First Database
Create a new database called
school
.
Objectives
Explain what a PostgreSQL database is
Create a database using SQL
Understand what happens internally when PostgreSQL creates a database
Learn
CREATE DATABASE
PostgreSQL Cluster
System Catalog
Verification
Prefill expected statement
Verification
Check with
\l
Missions in this level
1
Creating Your First Database
2
Connecting to a Database
3
Creating Your First Table
4
Inserting Data
5
Querying Data
query.sql
localhost:5432 · db
postgres
· user postgres
Live Schema Map
0 views · 0 indexes · 0 roles
No tables in
postgres
yet — run a CREATE TABLE to draw one.
Executor
Parse
›
Rewrite
›
Plan
›
Execute
›
Storage
idle
Live Database Explorer
PostgreSQL Cluster
postgres (connected)
public
no tables
template0
template1
Command breakdown
CREATE
SQL keyword that tells PostgreSQL to create a new object.
DATABASE
Specifies the object type to create.
school
The name of the new database.
;
Ends the SQL statement.
terminal
results
problems
history
CloudVision PostgreSQL — type SQL below and press ⌘/Ctrl+Enter (or the play button) to run it.
Talk with Zia