How to connect to a database using Python | Python Connect to SQL Server | Query database
In this video, we are covering how to connect to a SQL Server database using Python. This is a common question that comes up in the ETL series. So, I decided to cover it and direct viewers to it if they are facing this issue. There are few pre-requisites for this.
We need SQL Server database installed and configured. Link to this video:
• Install SQL Server Express 2019 Step by St...
Also, we will use Jupyter notebook to troubleshoot the database connection. Jupyter notebook installation is covered in this video here. Video link:
• Install Jupyter Notebook on Windows | Pyth...
SQL Server ODBC driver 11 for SQL Server for Windows link:
https://www.microsoft.com/en-us/downl...
Link to GitHub repo for Notebook:
https://github.com/hnawaz007/pythonda...
#python #database #sqlserver
Subscribe to our channel:
/ haqnawaz
-----------------------------------------
Follow me on social media!
GitHub: https://github.com/hnawaz007
Instagram: / bi_insights_inc
LinkedIn: / haq-nawaz
-----------------------------------------
Topics covered in this video:
0:00 - SQL Server connection overview
0:41 - Download & Install SQL Server Native Client
1:25 - Jupyter Notebook
1:22 - Jupyter Notebook
2:06 - Database Details
2:48 - Create Database Connection
3:51 - Database setup overview
4:41 - Query Database
5:22 - Common issues & and troubleshooting
On this page of the site you can watch the video online How to connect to a database using Python | Python Connect to SQL Server | Query database with a duration of hours minute second in good quality, which was uploaded by the user BI Insights Inc 24 November 2022, share the link with friends and acquaintances, this video has already been watched 8,072 times on youtube and it was liked by 105 viewers. Enjoy your viewing!
