CBT Nuggets | How to Create PostgreSQL Tables with pgAdmin for Beginners in (about) 1 hour @cbtnuggets | Uploaded 1 year ago | Updated June 07 2023
CBT Nuggets trainer Jonathan Barrios demonstrates how to create databases and tables in pgAdmin. pgAdmin is a popular and feature-rich administration and development platform for PostgreSQL, which is one of the most advanced open source databases on the market.
00:00 — Create Table - Syntax
07:26 — Create Table
20:58 – Manipulating Database Tables
22:55 — INSERT Syntax
32:40 — UPDATE Syntax
45:08 — Delete Syntax
49:08 — ALTER Syntax
59:13 — DROP Syntax
01:01:18 — CHECK Constraint Syntax
*Watch the entire SQL for Data Practitioners course here:* https://training.cbt.gg/bdo
*Not a CBT Nuggets subscriber? Start your free week:* https://www.cbtnuggets.com/signup
*Meet Jonathan Barrios:* https://www.cbtnuggets.com/trainers/jonathan-barrios
*Do you have passion for learning _and_ teaching? Apply to become a CBT Nuggets trainer:* https://training.cbt.gg/sv6
-----------------
Connect with CBT Nuggets for the latest in IT training:
• Twitter - https://twitter.com/CBTNuggets
• Facebook - http://facebook.com/CBTNuggets
• Instagram - http://instagram.com/CBTNuggets
• LinkedIn - https://www.linkedin.com/company/cbt-nuggets
#sqlforbeginners #postgresql #pgadmin #createdatabase #ittraining #cbtnuggets
CBT Nuggets trainer Jonathan Barrios demonstrates how to create databases and tables in pgAdmin. pgAdmin is a popular and feature-rich administration and development platform for PostgreSQL, which is one of the most advanced open source databases on the market.
00:00 — Create Table - Syntax
07:26 — Create Table
20:58 – Manipulating Database Tables
22:55 — INSERT Syntax
32:40 — UPDATE Syntax
45:08 — Delete Syntax
49:08 — ALTER Syntax
59:13 — DROP Syntax
01:01:18 — CHECK Constraint Syntax
*Watch the entire SQL for Data Practitioners course here:* https://training.cbt.gg/bdo
*Not a CBT Nuggets subscriber? Start your free week:* https://www.cbtnuggets.com/signup
*Meet Jonathan Barrios:* https://www.cbtnuggets.com/trainers/jonathan-barrios
*Do you have passion for learning _and_ teaching? Apply to become a CBT Nuggets trainer:* https://training.cbt.gg/sv6
-----------------
Connect with CBT Nuggets for the latest in IT training:
• Twitter - https://twitter.com/CBTNuggets
• Facebook - http://facebook.com/CBTNuggets
• Instagram - http://instagram.com/CBTNuggets
• LinkedIn - https://www.linkedin.com/company/cbt-nuggets
#sqlforbeginners #postgresql #pgadmin #createdatabase #ittraining #cbtnuggets