Python HOW TO connect Projects to a Database? [FULL 40-MINUTE TUTORIAL]
#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
En esta página del sitio puede ver el video en línea Python HOW TO connect Projects to a Database? [FULL 40-MINUTE TUTORIAL] de Duración hora minuto segunda en buena calidad , que subió el usuario JimShapedCoding 31 mayo 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 4,645 veces y le gustó 155 a los espectadores. Disfruta viendo!
