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

Published: 28 November 2024
on channel: Learning and Technology with Frank

3,463

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
https://skl.sh/3NC0Elm

Here is my Amazon Store - I try to keep it updated 😁
US Store https://www.amazon.com/shop/learninga...
Canada https://www.amazon.ca/shop/learningan...

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
🏫 Join our community on Skool - we discuss Educational Technology and more!
https://www.skool.com/learning-and-te...

✍️ BLOG: https://www.summittechacademy.com
🔉 PODCAST: https://thelearningmindset.buzzsprout...
🧠 The Learning Mindset: https://learningmindset.ca

🛒 My Amazon Stores:
📦 US Store https://www.amazon.com/shop/learninga...
📦 Canada https://www.amazon.ca/shop/learningan...

some of the links may support the channel as affiliate links

Some of my Favourite Software and Tools for Teaching (some with discounts!)

🧑‍🎓Coursera
Learn something new every day
https://imp.i384100.net/qzVZrb

🎥TechSmith
Create content using powerful tools
https://techsmith.z6rjha.net/zxRkv7

🏫iSpring
Create amazing courses as easy as you create PowerPoint slides
https://www.ispringsolutions.com/#a_a...

🐧Linux Foundation
Get trained and certified in Linux
https://shareasale.com/r.cfm?b=734319...

📝Scrintal
The playground for your mind - take notes, and more
https://scrintal.com/?utm_source=YT&u...

On this page of the site you can watch the video online Use Python to Query an Azure SQL Database - Get that data! with a duration of hours minute second in good quality, which was uploaded by the user Learning and Technology with Frank 28 November 2024, share the link with friends and acquaintances, this video has already been watched 3,463 times on youtube and it was liked by 97 viewers. Enjoy your viewing!

142