Steps To Build A Web App Connected To Sql Server

First time asking a question here and I feel like a noob for asking this but I figured I might get some helpful info here. I work as a data analyst creating reports in Tableau and

Solution 1:

1. Pick a programming language (e.g. Java or JavaScript).
2. Pick a web server that you can run server side code written in that language on (e.g. Tomcat or Node.js).
3. Find a library for that programming language that can interact with the SQL server you are using.
4. Write a server side program (in your language of choice) that can:
   1. read the data from an HTTP request.
   2. use it to query your database.
   3. return that data (probably formatted as JSON) in the HTTP response.

(Node.js isn't technically a web server, but the usual way to run server side code written in JS is to write a program in JS that has a built-in web server and then run that program with Node.js).