Chapter 1 of Mysql Enterprise Employee Study: A's troubles and growing troubles

Chapter 1 of Mysql Enterprise Employee Study: A's troubles and growing troubles

　　Chapter 1 A's troubles----- Why learn about databases and how to select Databases

Mr. A is A staff member of A company and an employee in the data department of the company. His daily work is inseparable from EXCELL. Recently, Mr. A has become more and more worried and can't help but speak out to Mr. Y, A good friend. John is a programmer in an Internet company and has many years of development experience.

John: "A, you have recently 'printed A black out' and are getting tired and weak. Why? What problems have you encountered at work? ".

Small A: "Alas, don't mention it. Recently, the company has been developing rapidly and the data volume is getting bigger and bigger. It will take me half A day to turn off EXCELL, plus processing and computing, one day, the choppy time is enough for me to eat a few times of KFC. ".

John: "... you can get the time and food together. Why didn't you ask for a new computer with the company? ".

A: "I mentioned it earlier. The company said that we should consider the cost and never change A computer. Now, I need to calculate and analyze such A large amount of data on EXCELL, every day, I want to get a good bag of melon seeds, not only fail to finish the work on time, but also let the department manager say a few times. ".

John: "Haha, let me give you a solution so that you can easily solve these problems ".

A: "What is the solution? Let me know. ".

John: "Don't worry. Let me talk to you slowly. What I recommend to you is an essential database for our programmers ".

A: "database? Literally, is it a data warehouse? "

John: "Yes. Databases can store a large amount of data and operate on the data. However, no matter what the world is, there are always competitors, for example, if you are using Microsoft's Office, do you know Kingsoft's WPS? ".

Small A: "Of course I know, but although WPS is small and lightweight, Office is A veteran after all. Most companies still use Office, but the operations of the two are basically similar, the same is true for computing and operation functions. ".

John: "Yes, the same is true for databases. Currently, there are many mainstream databases, such as Oracle, SQL Server, and Mysql. Although there are many, they are essentially the same. In terms of writing, all follow the SQL standard, so you can quickly learn other databases after learning one of them. "

A: "Well, which one should I learn? ".

John: "This is also a question that many people want to ask. In fact, you can choose either of them. After all, you can choose which one you want to choose based on your actual needs, for example, Oracle is the most mainstream database of large companies, while SQL Server and Mysql are basically dominated by small and medium-sized enterprises. However, as a big brother, Oracle is the software installation process, operation and learning process, it will be a little more difficult than SqlServer and Mysql. For example, if you are not a database-based cainiao, choose SqlServer and Mysql ".

A: "I want to exclude Oracle learning. Which one should I choose for Sqlserver and Mysql? ".

John: "This is very simple. SQL Server and Mysql are very difficult, but your company does not have the right to use SQL server. If you use SQL server without permission, you will be fined, to avoid embarrassment, you should first learn Mysql, because Mysql is a completely open-source free database. ".

A: "I still pay attention to this. Office is also charged, but WPS is free. Is this A truth? ".

John: "You are totally right. You may think that cracking Office or SQL is not enough. In fact, you should try to avoid such behavior in the company. Now that Mysql is decided, we have to start learning. ".

A: "Okay, but I'm hungry now. Let's have A delicious meal first. Please teach me Mysql again! ".

John: "your enthusiasm for learning should be so high. Okay, let's go to dinner first! ".