How ops learns the database becomes a senior DBA

1. Database design and SQL statement additions and deletions.

2. I believe that many small partners learn the operation and maintenance courses without the development experience of the database is very tired or even do many years of operation, can not be flexible to write SQL statements and additions to the search!

3. Actually learning the database is tricky, first of all we have the initial database type Serversql MySQL and other database types. You have to learn how to install the database http://linuxclub.info/centos-6-5%E4%B8%8B%E7%BC%96%E8%AF%91%E5%AE%89%E8%A3%85mysql-5-6-20%EF%BC%9B% e5%8f%af%e4%bb%a5%e6%89%be%e6%88%91%e8%a6%81%e6%9c%80%e6%96%b0%e7%9a%84mysql%e5%8c%85%e5%93%88/

4. The second is to learn the database design, and then in their own design of the database using SQL statements as much less, the last is to consider the database Advanced development view function stored procedure transaction and lock index. Of course, doing operations can actually understand the line without further study.

5. When you go through the previous database design and additions and deletions to SQL statements, let's talk about database management DBA management MYQL Secure backup restore replication Log management. I hope you will become a database expert at an early stage in the workplace.

Like my article's little buddy can add big face cat qq:203833507 welcome everyone to discuss the exchange

This article is from "Poker Face" blog, please make sure to keep this source http://lirenpgood.blog.51cto.com/9747573/1828391

How ops learns the database becomes a senior DBA