Some insights about databases and SQL Server

(1). With the advent of the big data age, data plays an increasingly important role in our lives, and we are increasingly dependent on data. Therefore, it is a very important technology to study and master the relevant knowledge of database and to design and develop the database.

(2). When you run SQL Server, to create a new database, you first need to create a new library with the CREATE DATABASE statement, and when you see the top left of your SQL Server software that shows the library you created, you can legitimately create, insert, Deletes a series of operations.

(3). The integrity of the database must be considered, in the establishment of the database, the first consideration should be the integrity of the database (Entity integrity, operational integrity, etc.).

(4). The security of the database must be considered in the first place. Nowadays, people attach more and more importance to security, so when designing and creating a database, we should know the security factors such as permission.

(5). The knowledge of the database is particularly important. In the mind should have a systematic understanding, this can be done to ensure efficiency.