Скачать или смотреть 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