Tutorial 27 –Data Types in SQL | PostgreSQL

In this video, I explained the commonly used datatypes in SQL.

**Books I recommend**

Below is the link to the PostgreSQL Playlist

Below is the link to the PostgreSQL documentation page

***************** Statements used in this video *****************
CREATE TABLE IF NOT EXISTS student_table(
student_id serial,
class_id integer,
fname varchar(180),
lname varchar(180),
height numeric,
weight numeric,
date_of_birth date,
email varchar(180),
tuition_paid numeric,
is_tuition_paid boolean,
date_tuition_paid Timestamp
);

INSERT INTO student_table (class_id, fname, lname, height, weight, date_of_birth, email, tuition_paid, is_tuition_paid, date_tuition_paid)

SELECT *
FROM student_table

Please don’t forget to LIKE, SHARE, COMMENT and SUBSCRIBE to our channel for more AWESOME videos.

DISCLAIMER: This video and description has affiliate links. This means when you buy through one of these links, we will receive a small commission and this is at no cost to you. This will help support us to continue making awesome and valuable contents for you.

[etudayejogogo]

I have been blessed by watching Ur YouTube videos on Postgres, thank you so much.

[bayoadegun]

Thanks for the wonderful session on datatypes.