Azure DevOPs

My requirement is to configure the alerts for Database and App Service using Azure Sentinel. For this I need KQL(Kusto query language) queries to set the alert rule logic, so that the query can get the logs of the resource from 'log analytic workspace' which is configured to Microsoft sentinel.
I need the KQL query logic for the following alerts:
For" DATABASE":
Maximum CPU Percentage alert
Failed connections to the Database alert
Dtu used capacity alert
Deadlocks alert
Firewall blocked alert
Data IO percentage alert

For "APP SERVICE":
App Service Identity
CPU Time alert
HTTP 5xx alert
HttpResponseTime alert
Requests in the Application queue alert
App Service Threads alert