Overall summary of SQL video

Or like English 7, 8 minutes of short video, Mr Chen's VB video, Jiang Jianling Teacher's SQL video, are in 30-40 minutes, a tomato is not enough, two tomatoes with no end. But fortunately, whether it is Mr Chen's VB video, or the Jiang Jianling Teacher's SQL Server video, which is a great amount of information, after reading can learn a lot of knowledge. Draw a picture and organize the knowledge in the video.

The main introduction of the video SQL Server the Knowledge and SQL Server2000 method of use.

Starting from Software:

mainly talked about the use of Enterprise Manager and T-SQL statement to the database, database objects, and other related operations to do the following

1. Create
2. View and modify
3. Delete
4. Renaming

The concepts of database and database objects are described, and they are manipulated

1. Database

Have a fixed system database

System Data Sheet

1. Data Objects

The database object is the software open, in the database below we can see, there are tables, views, triggers, stored procedures, rules, indexes, roles and so on.

1. Database files

Main files, secondary files, log files. And what they mean in the database.

Language is the same language, many with VB the language is similar.

1. Data Type    

1. Function

1. Cursor
2. Process Control
3. Variable

highlighted in the video, with Enterprise Manager and T-SQL statements on the operations of databases, views, tables, roles, stored procedures, indexes, triggers. Learn more about The operations of these T-SQL statements with examples.

It also describes the concept of transactions and the role in data processing, the concept of constraints and the method of creation.

The explanations of indexes, triggers, stored procedures, and constraints are also more detailed.

1. Enterprise Manager in SQL Server2008 in the absence of, the generation is SQL Server Manger Studio operation has a little different, some can not find, Baidu found the relevant items.
2. T-SQL the code is generic.

SQL Server Primer Classic, see is vague, but the video, gave a good knowledge to explain, learning knowledge are interrelated, self-textbook database system principle after watching the video, the fifth chapter after the knowledge is basically solved, the knowledge associated with, need to learn the knowledge gradually less , the efficiency has improved.

Overall summary of SQL video