Tutorial 27 –Data Types in SQL | PostgreSQL

Pubblicato il: 17 giugno 2023
sul canale di: tuplespectra

831

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.

In questa pagina del sito puoi guardare il video online Tutorial 27 –Data Types in SQL | PostgreSQL della durata di ore minuti seconda in buona qualità , che l'utente ha caricato tuplespectra 17 giugno 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 831 volte e gli è piaciuto 21 spettatori. Buona visione!