Use Python to Query an Azure SQL Database - Get that data!

preview_player
Показать описание
If you are using an Azure SQL database and want to connect to it and pull data using Python - then this video will show you how! In this video, I'll show you how to create an Azure SQL database, connect to it with Python, and query the database.

Microsoft Whiteboard course that I've created on Skillshare

Here is my Amazon Store - I try to keep it updated 😁

Note: some links are affiliate links and I may earn a small percentage of the sale at no additional cost to you. Thanks! It really helps the channel.

00:00 Introduction
01:17 Creating an Azure SQL Database
02:15 Cost Planning for the Database
06:22 Frank from the Future - deleting resources
13:16 Getting the Server Name and Connection Info
14:13 SQL Server Management Studio to Confirm Connection
14:56 Cat on the Internet
15:58 Python
16:29 Install pyodbc
17:38 Confirm ODBC in the Operating System
18:49 Connection String
20:34 TRY EXCEPT code block
21:59 SQL Query
23:31 Run the Program

#AzureSQL #data #python #sql
Рекомендации по теме
Комментарии
Автор

Thank you for always making such wonderful videos. I will come back to revisit you.
I will continue to support you from the bottom of my heart.

HouseMike-qzdw
Автор

Great stuff, just what I was looking for! Apart from your pronunciation of the word Resources 😛 I look forward to more videos.

hankerino