SQL #3: SELECT and INSERT data
SQL #3: SELECT and INSERT data
PostgreSQL
Content:
00:00 - Overview
00:35 - Bible Verse
00:48 - ERD review
01:40 - Create tables
02:35 - #1 Basic SELECT
03:23 - #2 Basic INSERT
09:50 - #3 SELECT specific columns
11:40 - #4 WHERE clause
15:27 - #5 AND / OR
18:52 - #6 LIKE expression
21:07 - #7 IN
22:20 - #8 BETWEEN
23:21 - #9 SUBQUERY
Other Playlists:
Python for Beginners: • Python for Beginners (Taglish)
SQL for Beginners: • SQL for Beginners (Taglish)
-------------------------------------------------
Code for creating the tables
-------------------------------------------------
BEGIN;
CREATE TABLE IF NOT EXISTS public.student
(
id serial PRIMARY KEY,
name character varying(45) COLLATE pg_catalog."default" NOT NULL,
email character varying(45) COLLATE pg_catalog."default",
phone character varying(20) COLLATE pg_catalog."default",
reg_date timestamp without time zone NOT NULL DEFAULT now(),
status character varying(10) COLLATE pg_catalog."default"
);
CREATE TABLE IF NOT EXISTS public.subject
(
id serial PRIMARY KEY,
name character varying(45),
description text,
status character varying(10)
);
CREATE TABLE IF NOT EXISTS public.student_subject
(
student_id serial NOT NULL REFERENCES public.student (id) MATCH SIMPLE,
subject_id serial NOT NULL REFERENCES public.subject (id) MATCH SIMPLE
);
END;
On this page of the site you can watch the video online SQL #3: SELECT and INSERT data with a duration of hours minute second in good quality, which was uploaded by the user #learning-diaries 24 February 2023, share the link with friends and acquaintances, this video has already been watched 40 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
