Need some advice on building a project for work. Node Express SQL React

So i am still relatively new to node and am looking for a little advice on a project for work.THE PROJECT: I want to track a collection of financial data for a group of companies. The data is available on either EDGAR sec website or a few other locations. Currently we have unbelievably convoluted excel spreadsheets that get saved into 1000 versions with multiple copies saved across the shared drive and my job every quarter is to go in and reconcile the lists and update our supposed master list. I think this can be automated or at least sped up significantly with a bit of code. My stretch goal is building this into a system that the senior members of the team can view the data for themselves and generate reports they want to see easily via a friendly and approachable front end. Hence, the goal is a web app that tracks, updates, and displays the company data.My Questions are:DATABASE STRUCTURE: Given the nature of the dataset and volume of data, I am leaning to using SQL over Mongoose, both for the relational nature of storing company data, and then that company's historical quarterly financial data over a period of 5-10 years, and the ability to perform analytics much easier (eg: average asset growth of all TX based companies in 2Q2016). I have really only created with mongoose so far (tutorials only want to do the MERN stack). Through online courses and udemy/youtube/sqlbolt/etc. I feel like I can get my basic SQL commands down. The elephant is in building/designing my database structure. I am trying to think about how to lay it out now for optimal usability and performance, and reduce the need to refactor at a later date. What are the best resources to learn this? Are there production datasets available I can search through, see how they are organized, and get an understanding of how I should look at mine?API STRUCTURE: I am going for a RESTapi backend, hopefully making things quick and easy to work with once I get to the front. Is there a resource to learn how large production APIs are built? Ive run the gambit of tutorials here as well, even created a collection of small applications for menial tasks (For Christmas, my family used my secret santa app that allows users to create a product wishlists and randomly assigns them to a user who doesnt have a santa yet). Those are all small potatoes by comparison but the best way to learn is to just in to the deep end.SQL WITH NODE: This one I am not too worried about, as I get the concepts enough I can probably figure it out. But if anyone has a great resource in the form of a tutorial/medium article/youtube vid/etc., Ill take it.Thanks for any advice!

Submitted February 14, 2019 at 03:58AM by Xzas22