Tutorial 27 –Data Types in SQL | PostgreSQL
In this video, I explained the commonly used datatypes in SQL.
*Books I recommend*
1. Grit: The Power of Passion and Perseverance https://amzn.to/3EZKSgb
2. Think and Grow Rich!: The Original Version, Restored and Revised: https://amzn.to/3Q2K68s
3. The Book on Rental Property Investing: How to Create Wealth With Intelligent Buy and Hold Real Estate Investing: https://amzn.to/3LLpXRy
4. How to Invest in Real Estate: The Ultimate Beginner's Guide to Getting Started: https://amzn.to/48RbuOb
5. Introducing Python: Modern Computing in Simple Packages https://amzn.to/3Q4driR
6. Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter 3rd Edition: https://amzn.to/3rGF73G
Below is the link to the PostgreSQL Playlist
• Tutorial 1 - What is Data? | What is Datab...
Below is the link to the PostgreSQL documentation page
https://www.postgresql.org/docs/curre...
Link to the primary key video 👉 • Tutorial 20 – Primary key in SQL | Postgres
Link to the foreign key video 👉 • Tutorial 21 – Foreign key in SQL
**************** 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)
VALUES(1, 'John', 'Doe', 160.02, 74.8, '2000-03-14', 'email@domain.com', 25000, true, '2023-06-17 3:00:00');
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.
On this page of the site you can watch the video online Tutorial 27 –Data Types in SQL | PostgreSQL with a duration of hours minute second in good quality, which was uploaded by the user tuplespectra 17 June 2023, share the link with friends and acquaintances, this video has already been watched 831 times on youtube and it was liked by 21 viewers. Enjoy your viewing!
