Create the first table for the Penguin online store in PostgreSQL using PgAdmin

Описание: This video explains the very first steps working with PostgreSQL (version 11 in this example):
connect to the database
create schema
create table
run SELECT on the table to see the data
rationale: why using relational databases

Prerequisites: installed version of PostgreSQL and PgAdmin

For installation tutorial for Linux Mint/Ubuntu here:
   • Installation of PostgreSQL and PgAdmin 4 o...  

Sample data:
CREATE SCHEMA backend;

CREATE TABLE backend.customer_order (
order_id text,
created timestamp without time zone,
item_name text,
item_brand text,
item_size text,
customer_firstname text,
customer_lastname text,
customer_address text,
customer_age integer
);

-- Set search_path variable to schema "backend" to be able to use "customer_order" instead of "backend.customer_order"
SET search_path TO backend;

INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1056', '2015-03-25 01:56:37.904506', 'Jeans', 'Wrangler', '36/34', 'John', 'Doe', 'Main str. 1', 35);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1057', '2015-04-08 19:13:49.242515', 'Blue T-Shirt', 'Adidas', 'L', 'Brian', 'O''Brian', 'Park str. 10', 48);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1058', '2015-05-03 05:29:25.927882', 'Blue T-Shirt', 'Adidas', 'M', 'John', 'Doe', 'Main str. 1', 35);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1037', '2014-10-19 02:06:33.27487', 'Sneakers', 'Ecco', '38', 'John', 'Doe', 'Main str. 1', 35);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1038', '2014-10-20 18:20:53.807563', 'Sneakers', 'Ecco', '43', 'Alisha', 'Cruz', 'Maple str. 1002', 28);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1039', '2014-11-12 07:08:13.352507', 'Jeans', 'Wrangler', '32/30', 'Rose', 'King', 'Main str. 34', 48);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1040', '2014-11-14 06:22:25.777536', 'Sneakers', 'Ecco', '41', 'John', 'Doe', 'Main str. 1', 35);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1041', '2014-11-17 23:59:05.14378', 'Blue T-Shirt', 'Adidas', 'M', 'Renee', 'Sims', 'Third str. 38', 35);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1001', '2014-01-16 20:04:59.946198', 'Jeans', 'Wrangler', '34/36', 'Britney', 'Doe', 'Main str. 1', 32);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1002', '2014-01-23 22:17:24.884522', 'Jeans', 'Wrangler', '34/34', 'Britney', 'Doe', 'Main str. 1', 32);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1003', '2014-02-07 02:49:57.930249', 'Sneakers', 'Ecco', '43', 'Leo', 'Gill', 'Third str. 12', 29);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1004', '2014-02-14 02:36:15.004689', 'Jeans', 'Wrangler', '32/30', 'Leo', 'Gill', 'Third str. 12', 29);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1005', '2014-03-03 18:09:34.918494', 'Sneakers', 'Ecco', '40', 'Renee', 'Sims', 'Third str. 38', 35);
INSERT INTO customer_order (order_id, created, item_name, item_brand, item_size, customer_firstname, customer_lastname, customer_address, customer_age) VALUES ('1006', '2014-03-06 16:19:54.207748', 'Jeans', 'Wrangler', '30/30', 'Leo', 'Gill', 'Third str. 12', 29);

Check for more:
Homepage: https://ohveevee.tk
Facebook:   / ovolynets.87  
Instagram:   / oleks_volynets  
Twitter:   / oleksvolynets