Python HOW TO connect Projects to a Database? [FULL 40-MINUTE TUTORIAL]

Publié le: 31 mai 2021
sur la chaîne: JimShapedCoding

4,645

155

#PythonProjects #Python #PostgreSQL #PythonwithDB #SQL

PostgreSQL goes as one of the popular DB engines in the world, and widely used across companies!
This 40-minute tutorial will get you ready to use PostgreSQL as your Database in your Python Projects

What this video includes?
Why would you want to have a DB in Projects ?
Installing PostgreSQL and PGAdmin interface
Use the Python official library to connect apps to PostgreSQL
What is SQL ? How to run queries against your DB ?
Automate Insert/Select/Update/Delete queries with Python

👍 Subscribe for more Tutorials like this!
/ @jimshapedcoding
🔥 Comment below on other topics you want to see tutorials next on my Channel.
-----------------------------------------------

My website:
http://www.jimshapedcoding.com

GitHub Repository with the code:
https://github.com/jimdevops19/Python...

Links:
More SQL information:
https://www.w3schools.com/sql/default...

PostgreSQL download link:
https://www.postgresql.org/download/

🎥 My YouTube Gear 🎥
Camera (Canon EOS 250D) : https://amzn.to/314euVC
Microphone (Rode NT-Mini) : https://amzn.to/3bDqEer
Headphones (JBL LIVE 500BT) : https://amzn.to/3e73MDS
Tripod (Neewer Portable Tripod) : https://amzn.to/2OXleC6
Desklight(AUKEY Cordless Lamp): https://amzn.to/2QaYT4A
Keyboard ( Razer Blackwidow Green Switch ) : https://amzn.to/3bExDnu
Mouse ( Razer LanceHead ) : https://amzn.to/3if0JuV
Lights ( Neewer 2-Pack Dimmable ): https://amzn.to/3oFN1DP

Timeline for the video:
00:00 - 06:00 - Introduction / Getting Started
06:01 - 12:20 - Psycopg2 Library to connect your DB
12:21 - 20:42 - PostgreSQL management with PGAdmin
20:43 - 24:16 - Create a DB Cursor object / SELECT Query
24:17 - 26:00 - Create functions page for each query type
26:01 - 32:29 - INSERT Query
32:30 - 37:00 - UPDATE Query
37:01 - 39:57 - DELETE Query
39:58 - 40:30 - Final words

Sur cette page du site, vous pouvez voir la vidéo en ligne Python HOW TO connect Projects to a Database? [FULL 40-MINUTE TUTORIAL] durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur JimShapedCoding 31 mai 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 4,645 fois et il a aimé 155 téléspectateurs. Bon visionnage!

73,410

1.8K