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
Auf dieser Seite können Sie das Online-Video Python HOW TO connect Projects to a Database? [FULL 40-MINUTE TUTORIAL] mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer JimShapedCoding 31 Mai 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 4,645 Mal angesehen und es wurde von 155 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
