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.
En esta página del sitio puede ver el video en línea Tutorial 27 –Data Types in SQL | PostgreSQL de Duración hora minuto segunda en buena calidad , que subió el usuario tuplespectra 17 junio 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 831 veces y le gustó 21 a los espectadores. Disfruta viendo!
