Current location - Loan Platform Complete Network - Big data management - Learn sql well with big data
Learn sql well with big data
Well, I don't know if you have a programming foundation before, just pretend you don't.

You don't need to look at the programming language, but you must have simple programming ideas. For example, 1+2+3+. . . +100, this mathematical algorithm is called 1+ 100.

2+99

. . . That's true, but it's not used in the program, so it's still very useful to have a brief look at C's programming ideas, mainly the algorithm part.

At present, the mainstream databases are oracle, mssql, mysql, db2 and so on. Personally, I think it's Oracle Bone Inscriptions.

It's promising, and the certification exam is not cheap, but it's not recommended that you learn this first. Of course, you can learn this first if you like.

There are several directions for the future development of learning database. 1 is the direction of DBA, and the future is database optimization and configuration. Because the current trend is big data, optimization in this area is still very important. The second direction is database programming, that is, database operation, and a series of programming to achieve a certain function. The most important thing is to learn to write sql language, although there are many types of databases on the market. But sql languages are basically the same, but learning this well is not the ultimate goal. In the future, you have to be able to write stored procedures, triggers and custom functions, which is also very troublesome anyway.

Take oracle as an example, it has many third-party tools, but its own sqlplus and so on, personally feel very bad. . .

Let's talk about this first, and then ask if you don't understand.