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 working with SQL server. I've had some minimal experience programming in Java, Javascript, and HTML. D3 has really peaked my interest as a powerful language that could be used to create more complex/creative dashboards. I essentially would like to use D3 and Javascript to create dashboards based off data housed on SQL server but having never built a web app I'm a little overwhelmed at what all I would need to do to accomplish such a feat. I know I would need an API etc, I'm just not sure of the steps needed to make it all happen. Can anyone explain to me what I would need to do (step by step) from a "birds eye view", so I have a good idea of what direction I need to go in? Thanks.

828 1 1 gold badge 12 12 silver badges 35 35 bronze badges asked Jan 7, 2016 at 15:25 MattyKluch MattyKluch 19 2 2 silver badges 11 11 bronze badges "D3 has really peaked my interest as a powerful language" — It's a library, not a language. Commented Jan 7, 2016 at 15:30

What backend would you be using? If it's Java I personally have no idea. But if you're willing to experiment with NodeJS you would basically only need some library like this: github.com/felixge/node-mysql.