"Mysql Company staff Study" chapter One of the troubles of small a

　　chapter I the annoyance of small a ----- why learn a database and how to select a database

Small A is a company's staff, the company data department employees, the normal size of work, completely inseparable from the excell, and recently small a but more and more distressed, not from the good friend small y spit groove. Small y is a programmer for an internet company with years of experience in development.

Small y: "Small A, you recently ' Yintang black ', more and more fatigue and weakness, how?" What's the problem at work? "。

Small A: "Alas, not to mention, the recent rapid development of the company, the data volume is getting bigger, I that ' need ' computer, close open Excell to card a half-day, plus processing and calculation, one day down, the time of the lag, are enough for me to eat a few KFC's." "。

Little y: "... Also you can put time and eat, then you did not and the company asked to change the computer configured? "。

Small A: "Old Long mentioned, the company said to consider the cost, not to change a computer, and now so large data volume, to my calculation and analysis on the Excell, waiting for the time of day, all want to take the package of melon seeds knock, not only did not finish the work on time, but also let me department manager said several times." "。

Small y: "haha, then I give you a way, so that you can easily solve these problems."

Little a: "What way?" Let me talk to you quickly. "。

Little y: "Don't worry, I will slowly tell you, I recommend to you, is the necessary database for our programmers."

Small A: "Database?" Literally, is the warehouse where the data is stored? "

Little y: "Yes, the database can hold a lot of data and manipulate it, but the world, no matter what, there are always competitors, such as you are now using Microsoft Office Bar, then you should also know the WPS of Jinshan it?" "。

Little a: "Of course I know, but WPS is small, lightweight, but office is old, most companies still keep office, but the operation of the 2 is basically similar, even some calculation and operation of the function, is the same. "。

Small y: "Yes, the same database is the same, now the mainstream of Oracle, SQL Server, MySQL, and so on, although there are many kinds, but its essence, the wording, all follow the SQL standard, so you learn one, you can quickly learn other databases." "

Little a: "So, what should I learn?" "。

Small y: "This is also a lot of people want to ask questions, in fact, learn which can be, after all, the technology is not under pressure, in the selection of which time, according to your actual consideration, for example, Oracle is currently the most mainstream database of large companies, SQL Server and MySQL basically dominate small and medium-sized enterprises, But Oracle as eldest brother, its software installation process, operation and learning process, will be more difficult than SQL Server and MySQL, like you do not use the database to learn the primary novice, or choose SQL Server and MySQL bar.

Small A: "That basic I want to rule out Oracle's learning, then SQL Server and MySQL I should choose which one?" "。

Small y: "This is very simple, SQL Server and MySQL is very difficult, but your company did not purchase the use of SQL Server, you are privately used in the company, was found to be fined, in order to avoid embarrassment, you still prefer to learn MySQL, Because MySQL is a fully open source free database. "。

Small A: "The original still have this fastidious, said office is also charges, but WPS is free, this is a reason?" "。

Little y: "You're absolutely right, you might think that hacking office or SQL does not work, actually in the company, or as much as possible to avoid this behavior." Well, now that we've decided on MySQL, we're going to start studying. "。

Small a: "OK, but I am hungry now, we first go to eat delicious, you teach me mysql!" "。

Little y: "Your Enthusiasm for learning, to have so much better, OK, then we go to eat!" "。

"Mysql Company staff Study" chapter One of the troubles of small a