如何开始使用数据库 [英] How to get started on database

问题描述

嘿伙计们。我正在c＃中构建一个用于库存管理的应用程序。它将处理许多订单，产品，客户等。该软件将具有桌面和移动版本（在xamarin的帮助下），所有这些都将输入和输出信息。

我还在学习使用XAML的c＃但是我对数据库知识非常有限，以及我将如何存储所有信息。存在许多不同的数据库技术，因此不知道选择哪一种。



理想情况下，我希望将信息存储在计算机或内部网络服务器上的某个位置，但也可以选择将数据库传输到云（Internet）而不需要太多安装。



我知道MySQL是一个实际的数据管理软件，它包含所有数据，SQL是一种（编程）语言，用于进行查询和执行其他命令到MySQL。我应该开始学习这项技术，并且能够将它用于我想要构建的内容吗？如果是的话，这个课程（下面的链接）是否足够全面？

一旦我熟悉MySQL，我该如何将它移到云端？



https://www.udemy.com/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/



如果我不够清楚或犯错误，我将非常感谢您的任何指导，建议或指示。



谢谢。



我尝试过：



一般搜索

观看教程

阅读文章

解决方案

是的，您可以使用MySQL构建您想要构建的内容。但我建议你可以使用Microsoft SQL Server，以防你坚持使用.Net框架，只需阅读有关MySQL over SQL Server的参考资料

1. mysql - SQL Server与Visual Studio有什么特别的优势吗？ - 软件工程堆栈交换 [ ^ ]

2. MS SQL vs. MySQL：哪个关系数据库适合你？ [ ^ ]

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

解决方案

Yes, you can use MySQL to build what you would like to build. But I would suggest that you can go with Microsoft SQL Server in case you are sticked with .Net framework, just read this references about MySQL over SQL Server
1. mysql - Are there any special advantages of SQL Server with Visual Studio? - Software Engineering Stack Exchange[^]
2. MS SQL vs. MySQL: Which Relational Database is Right for You?[^]

这篇关于如何开始使用数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！