Illustration of SQL Server

So far, we have finally completed the SQL Server video and PPT review. Looking back on the long video path over the past 10 days, I always thought that the more things I talked about later, the more I thought, the more I rushed down.

Of course, the 40 sets of videos have gained a lot. I have a more detailed understanding of SQL Server basics. However, the specific implementation and operations should be mastered in future practices. The following figure shows the basic knowledge of the database.

This is a general overview chart, modeled on SQL Server2000. Due to the illustration, I need to divide the course into eight parts based on the aesthetics and specific analysis. For more information about the basic database and storage structure, see object, language basics,ProgramDesign, permissions, management, and transactions should be focused on.

 

This is a further detailed diagram (Http://pan.baidu.com/disk/home#dir/path=%2F%E6%95%B0%E6%8D% AE %E5%BA%93%E5%AF%BC%E5%9B%BE--- SQL
Server2000 mind map, because all the expanded maps are too large, this is my internal map on the network disk, you need to install mind manager to download and view; the above texture can still be seen by using Ctrl + scroll zoom ). In the figure, nine items are listed for common objects in SQL Server, but the operations on these objects are nothing more than adding, deleting, modifying, and querying four items. Other details and features need to be analyzed.

Database management mainly involves addition, deletion, modification, and query, as well as very important data backup and recovery. This is a key to ensuring the success of our work. data import and export is very simple, however, data operations are also very important for us to facilitate data entry and quantitative analysis of specific data.

As for transactions, we mainly understand their meaning and understand their working principles and lock mechanisms.

Database language basics and T-SQL programming are very important, he is our implementationCodeThe most important basis and method of operations. In particular, understanding the nine common statements and syntaxes of the T-SQL language, fully understanding its data type, use in the right place will make the program execution more efficient, reduce time consumption.

At the same time, we also need to understand and use batch processing, functions, operators, control processes, and other control and calculation methods to make comments.

For database permissions, we master the SQL logon methods and understand the permissions and server roles. If it is the creator, it is necessary to manage and delegate permissions to ensure database security and user permissions.

For all the general diagrams, we have described in detail the contents of all the diagrams. Please refer to the above link for correction )!

In general, the basic knowledge of the database is relatively simple, but very important, grasp the T-SQL language and enterprise manager with the application, will make our database learning flat!