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.
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
- SQL Server Installation vidoe: https://morioh.com/a/2a0dc9889b7d/how-to-install-sql-server-on-windows-10
- Also, we will use Jupyter notebook to troubleshoot the database connection. Jupyter notebook installation is covered in this video here. Video link:
https://morioh.com/a/56b56986266c/how-to-install-jupyter-notebook-on-windows - SQL Server ODBC driver 11 for SQL Server for Windows link:
https://www.microsoft.com/en-us/download/details.aspx?id=36434 - Link to GitHub repo for Notebook:
https://github.com/hnawaz007/pythondataanalysis/blob/main/ETL%20Pipeline/Connect%20to%20SQL%20Server%20with%20Python.ipynb
2.55 GEEK