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.
Auf dieser Seite können Sie das Online-Video Tutorial 27 –Data Types in SQL | PostgreSQL mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer tuplespectra 17 Juni 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 831 Mal angesehen und es wurde von 21 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
