How to build a CRUD API with Azure Functions and Azure SQL Database - Tutorial Step by Step

preview_player
Показать описание
In this video we go through the Azure Documentation of how to build a CRUD API using Azure Functions and Azure SQL Database. We build 3 APIs, one for creating an item in the database, one for selecting specific records from the database and one for deleting items. We also see how to use PyODBC to access the Database and run our own queries. The code is already on the documentation and can be found at:

Follow me on social media:

00:00 - Intro
00:48 - Function App and access to Azure SQL Database
04:04 - Upsert API
12:46 - Read API
20:15 - Delete API
25:29 - Deploy & Configuration & Run APIs
28:55 - PyODBC
29:25 - Conclusion
Рекомендации по теме
Комментарии
Автор

My SQL SERVERE MANAGED INSTANCE. is on a different resource group and different subscription that of Azure Functions and Data factory can you please tell me how to resolve this. Your help is highly appreciated

venkataramanapotluri
Автор

Can I use the same process to add and delete records from SQL SERVERE MANAGED INSTANCE. While consuming these functions in ADF pipeline what changes I have to make? Your help in this regard is very highly appreciated

venkataramanapotluri
Автор

Thank you. Could you advise how to test the app?

tadastadux
Автор

❤❤❤ simple and elegant.. keep up the good work.. you will grow..

Rafian
welcome to shbcf.ru