Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Excellent SQL Encoder growth and Advanced Route

2025-03-12 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Learning is a process of not advancing or falling behind, not with rhythm, but with facts.

For engineers at a higher level, the difficulties they need to overcome, the books they read and the paper they read will deepen step by step. For example, when you are still reading the database implementation, people are already studying the principle and implementation of distributed storage.

You say you don't want to be so tired, but you just want to find a technology with a long half-life to make a living, which is also an attitude towards life. There's nothing wrong with it, it's just a personal interest.

You may have a strong product view, and your understanding of the product is as profound as that of the second master or even Master Qiao, and you may be an excellent product manager; you may be able to quarrel with Indians, French and Germans in three or four foreign languages, deal with all kinds of Party, go in and out of various high-end parties, and occasionally check ROI with SQL, which is also very remarkable.

SQL, and even the whole technology system, is not the only one who eats. Don't put the technology too mythically. If people buy a mobile phone and a moments on WeChat, they still earn NT $100,000 a month. If you think that technology is the holy spirit and the only way to get rich, you will be disappointed. It's just a choice. It happens to be a toy you like, and it just happens to support you, take a little time, and support a family. Why not?

However, if you do not have the above qualities, and your father is not Li Gang, then technology is the only way for you to gain a foothold in society quickly. I didn't say that. Wu Jun said in his get column that the way for people with no resources, no family background and no godfather to support themselves quickly is to learn skills, and then go to big cities to find a job and work first.

When it comes to craftsmanship, there is a distinction between superb and mediocre. The transition from mediocrity to exquisite is the pursuit of craftsmen. Some people are very savvy, master lead, and get started, plus their own exploration is also diligent, a craft, such as SQL, completely mastered in two years, many OCP are proficient in two years. And some less savvy, mediocre people, such as me, only after playing for five or six years did they feel that they were getting started, and it took more than ten years to say that they were enthusiasts with some experience. This is not my low profile, nor is it hypocritical, it is a fact.

People rush to work day and night and have a good brain. In winter, when I was still greedy for warm quilts, they were reading books; when I was drinking coffee at Starbucks or holding Costa coffee in the cinema to pursue Star Wars, Transformers and the couplet, they solved problems at the client's scene and were on call on weekends. Why not give them proficiency!

So the first step of getting started is to take the time to read books as examples, ask questions, and communicate.

How to tell if you are getting started or advanced, or if you haven't entered at all?

Try to answer the following questions. If you can't answer them immediately, you're not getting started:

1) how to create a single valued function (scalar-valued function) and a table valued function (table-valued function)

2) the difference between Left Join and Inner Join 3) more than 10, 000 result sets are returned, how to display them in pages

Do not read books, do not check Baidu, Google, can answer the following questions correctly, you can basically conclude that you are in the advanced stage.

1) without a loop, write a script that sequentially generates the result set of dates in any specified range

2) it is known that the order amount table stored on a monthly basis has the main fields of annual, monthly and sales amount, and does not need Join to solve the month-on-month growth.

So proficient in:

1) it is known that select max (InsertDate) from auditLog has been running for 30 minutes. What will you do to tune it?

2) if there are two tables with 1 billion and 200 million pieces of data respectively, what if 200 million pieces of data are merged into the 1 billion table?

3) take a look at this question. Can you answer it? This question is worth 100 RMB.

Master it and go up to the next level?

This layer has only been seen on Qcon, in Github's open source Hive/Spark SQL source code, and in the oceanbase project developed by Ali. It is said that it can change the access of the data layer at will, automatically identify partitions, sub-tables, sub-libraries, and intelligently route each set of data interfaces.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report