For security you often do not want the fronted server to directly access the database, but rather use an webapi project. It is not clear if you did a web project or static web project and a separate webapi project.
If you built you angular as a static site and a webapi site using angular dev servers proxy support, then you want an azure static site for the frontend and config the api to a web app ir azure functions
If the angular site is core site, then deploy as webapp and the optional webapi as webapp
You have several Sqlserver deployment options for azure.
- You can create a database project in visual studio and deploy the project. You can check in to GitHub and use GitHub actions to deploy.
- You can attach with azure data studio and run scripts.
- You can use azure database console and run commands
- You can add startup code in the .net app to create the database