Hello @Anshal,
<In addition to Sam Cogan's answer>
Here are a few scenarios for the use cases:
Scenario 1: If you want to access your resources outside your Vnet, you can use public endpoints. An example use case: An azure storage account contain files that need to be accessible via the internet. In this case, a public endpoint can be created to download the files directly from the internet.
Scenario 2: If you want to access your resources within your Vnet, you can use private endpoints. An example use case: An azure storage account contains sensitive data to be accessible within your Vnet. In this case, you can use a private endpoint to ensure that traffic to the storage account stays within the Azure network and is not exposed to the public internet.
Scenario 3: Azure Service Endpoints enable private connectivity to Azure services from within a virtual network. An example use case: You have a scenario, where an application running on a virtual machine needs to access an Azure Storage account. By creating a service endpoint, traffic to the storage account is restricted to the virtual network. So you are keeping the data within the virtual network, rather than going over the internet.
Scenario 4: An Azure private link, is a way to access Azure PaaS services (like Azure SQL, Cosmos DB, etc.) over private endpoints in VNet, eliminating exposure to the public internet. An example use case: use Azure Cosmos DB to store data and wants to access it over a private endpoint within the virtual network. This will improve security by eliminating exposure to the public internet.
Video tutorial: Public endpoints, Private endpoints and Service endpoints.
Private link deep dive
Please check the below reference documents:
https://learn.microsoft.com/en-us/azure/private-link/private-link-overview
https://learn.microsoft.com/en-us/azure/private-link/private-endpoint-overview
https://learn.microsoft.com/en-us/azure/virtual-network/virtual-network-service-endpoints-overview
I hope this helps. Please let us know if you need any further clarification.