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
Nesta página do site você pode assistir ao vídeo on-line Python HOW TO connect Projects to a Database? [FULL 40-MINUTE TUTORIAL] duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário JimShapedCoding 31 Maio 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 4,645 vezes e gostou 155 espectadores. Boa visualização!
