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

Published: 31 May 2021
on channel: 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

On this page of the site you can watch the video online Python HOW TO connect Projects to a Database? [FULL 40-MINUTE TUTORIAL] with a duration of hours minute second in good quality, which was uploaded by the user JimShapedCoding 31 May 2021, share the link with friends and acquaintances, this video has already been watched 4,645 times on youtube and it was liked by 155 viewers. Enjoy your viewing!

5,710

121