Hey guys. I am building an application in c# for inventory management. It will be handling many orders, products, customers etc. This software will have a desktop and mobile versions (with the help of xamarin) all of which will be inputting and outputting information.
I am still learning c# with XAML but I have very limited knowledge when it comes to database and how I will go about storing all the information. There are many different database technologies that exist so don't know which one to opt for.
I would ideally like to store information offline somewhere on the computer or on an internal network server but also have the option to transfer the database to cloud (internet) without much setup.
I do know that MySQL is an actual data management software where it contains all the data and SQL is a (programming) language that is used to make queries and execute other commands to MySQL. Shall I start learning this technology and would I be able to use it with what I want to build? If yes, is this course (link below) comprehensive enough?
And once I am familiar with MySQL, how do I go about moving it to cloud?
https://www.udemy.com/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/
Any guidance, advice or pointers will be much appreciated and my apologies if I wasn't clear enough or have made mistakes.
Thank You.
What I have tried:
General Search
Watched Tutorials
Read Articles
Submit an article or tip