Tutorial 30 – How to create database, table and insert in PostgreSQL смотреть онлайн

In this video, I explained how you can create a database, database table and insert records into the created database table. I also explained how to use primary key and other column constraints when creating table.

**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
https://www.youtube.com/watch?v=oFaLUCWRnRE&list=PLACD_PaYcVF09khO58CISr08Uy6w3cAIF

Below is the link to the PostgreSQL documentation page for creating table
https://www.postgresql.org/docs/current/sql-createtable.html

Link to the SQL Data Types video ? https://youtu.be/q__h-KSLNOo

Link to the primary key video ?https://www.youtube.com/watch?v=Ko2rVWRU8wI

Link to the foreign key video ? https://www.youtube.com/watch?v=zJIjtR-1puI&t=139s

Link to the NOT NULL and CHECK constraints video ? https://www.youtube.com/watch?v=-a4nTPNAlss

Link to the unique and default constraints ? https://www.youtube.com/watch?v=FcCsq-TveNw

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.