Learning from the database, database Learning

Learning from the database, database Learning

This time, I learned a lot about the evaluation system, learned a lot about the system of the eighth division, and learned a lot about database operations.

We have been using SQL server databases when we are working on the data center in the West, but we are still very narrow and narrow, only know simple data

Perform database operations. The following are some of the achievements in the past few days.

1. First-eye feelings

The first time I saw the database, I was shocked. So the multiple tables are different from what I originally thought. Then, when I was reading the database tables

I was very careful. I was so scared that I broke the database. Even though I didn't know where the fear came from, I was so worried,

While reading the document while operating the database, each operation is checked several times, and the database has been delayed.

Ii. Change

Since we want to maintain the evaluation of the database, we can't keep staring at the database without any operations. We always need to clear the database before importing data, so

With special care, the database is moved and some deletion operations are performed by document. The development of things is always unexpected, and the data is cleared.

We were shocked to find that there was no data after logging on to the evaluation site. Fortunately, we had a backup, which would be a big deal to restore the database, but now we have a feature

Don't exercise well. Our Chances are in front of us. We know more about this system by making mistakes, so we observe database tables through various ways.

The relationship between the two databases was found to be incorrect, and then the database was restored to the correct operation. At this time, I have already

Calm down

3. Qualitative Change

With the data import process, we encountered various errors, which were difficult to solve through the basic system. At that time, I did not know the problem.

What should I do? later I saw that I was brave enough to operate the database through SQL statements. I thought that I had learned so thoroughly about the database.

I dared to operate the database directly. I found that the relationship between the original database is not as complicated as I thought. I will understand it after careful research.

A lot. Looking back at the database is the same as looking at the database in the data center ..

Summary: in some cases, we are always scared, so we don't dare to do it, so we don't know it deeply. In fact, we can change us.

In this way, you may find that it is not as difficult as you think;

The same is true for our learning. Do not be afraid of new knowledge. We can open the veil layer by layer like peeling an onion.