The primary DBA Learning Path reference

Source: Internet
Author: User
Tags dba failover

Today in Monday dragged a tired body 11 o'clock before leaving the company, home estimated to write this blog will be 17th number.

A person walking on the way home, very dark, suddenly a lot of feelings, a person in Beijing to fight, dare not stop learning footsteps, because as long as the stop will feel lonely.

Review your career, write programs, do operations, and engage in bi. There is no goal, but hard work, but also a steady progress. Three years later, think of a career in the fork, think of what they want to do? Look back at the code you wrote a little bit of the high-end shadow Ah!! Anyway, do not want to be a yard farm, so resolutely left the company that once worked for three years, from Dalian came to Beijing.

    • Envy business experts, once crazy research business dream of becoming an expert in ERP. Yards of farmers want to become industry experts seem to see the road ah .... Still have to go on yards ....
    • Worship once the project manager, also my Enlightenment teacher, tested PMP dry project management bar. For a person with no management experience, a bunch of big theories, which company will bring you the project ... Worked years in a company? ...
    • SQL SERVER DBA finally embarked on this road ....

DBA This road is still not a good way to go, want to be a DBA just rely on the development will write the point of SQL if you can find work, please laugh .... But it's easier to feel better than the project manager and the industry experts, and maybe it's a good choice when you're older and you don't move a bit. But the DBA is just as difficult to get started, a lot of people often ask how to get started, who can take me to give me a chance? That's what I'm asking, looking for a job interview.

Excuse me: How many years work experience?

Three years ...

Excuse me: How about database working experience?

Summon up courage: three years (not in fact a year) ...

I'm sorry, we need 5-10 years!

--------------------------------------

Excuse me: Do you have too much available load balancing? Mirroring, publishing subscriptions, failover clustering, and so on? Have you ever tuned in parallel? System monitoring, stress testing, and so on.

Didn't...

.......

--------------------------------------

Negative energy

Positive Energy

Share the path of your own MSSQL learning. (now it's still a creep, give advice and thanks to the great God)

My own SQL Learning path has a lot of level under the specific said:

  • LV1: In program development, there are a lot of complex logic SQL statements, report queries, such as more than 2000 rows of stored procedures, stored procedures nested stored procedures and so on.
      • Developers who have written this complex SQL program may have a feeling that my database is invincible.
      • In the project of special love to write SQL, some old staff some complex SQL will also let you help.
        • It feels so good at this time!
  • LV2: Start learning the optimization of SQL statements and start analyzing execution plans slowly.
      • Although the implementation of the plan is not very clear, but already know where the statement is slow, know how to use indexes, temporary tables and other simple optimization methods.
      • Slowly know what is the cache plan and what is the parameter sniffing.
        • SQL statement a few minutes into a few seconds, it feels so wonderful ~ ~ Haha ~
  • LV3: Start learning about the principles of database architecture, learn to view current status using System table view
      • This stage is a painful and lengthy need to see a lot of book hands-on practice is also essential.
      • After reading the 2005 Technical Insider's 4 book, can give the people around from the principle of what is SQL how to run the ~ fluttering feeling came again.
        • This stage is excited and confused, feel that they will be a lot of things but at the same time feel that they do not have anything ...
  • LV4: Several lines began to emerge, SQL development, optimization, cluster technology, troubleshooting.
      • More advanced applications for SQL development.
      • Basic application of Profiler, Perfmon (although many parameter indicators do not understand), can read the simpler execution plan and make the statement optimization according to the situation.
      • Can build transaction log transport, mirroring, publish subscriptions, failover clusters.
      • Simple faults can be solved.
        • I was on the path of the Junior DBA ....
  • LV5: Continue to learn the principles of SQL, deep button details, see the Great God's Blog articles to do their own simulation scenarios.
      • Learn more about the application of database features. There is a problem with more knowledge of the reserve processing problem.
      • Familiar with routine routines, find out the system bottlenecks and what to do, the statement optimization tips and so on.
        • Long long and long experience of accumulation. I'm just here!
  • LV6: ... Cond......
  • LV7: ... Cond......

........................

The above content must continue to study hard, and then learn, if the database technology is not interested in reading, study is painful can decisively abandon the database this road .... Try the business Specialist \ Project Manager/yourself as the boss and so on.

Finally, take a picture to cheer for yourself ~ and salute the Great gods ~

  

Transferred from: https://www.cnblogs.com/double-K/p/4970560.html

The primary DBA Learning Path reference

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.