SQL Server Knowledge Point systematization study

First: basic knowledge of SQL Server 2008 (chapters 1th, 2).

First, we introduce the principle knowledge of database, such as the structure of relational database and the theory of usage paradigm .Specificationdatabase and E-r model, and then the new features of SQL Server2008 andfeatures,installation sql  server 2008 the database, and then details the various tools used to manage sql server 2008, such as Sql server management Studio and Configuration Manager.
second: sql server 2008 daily Operation Chapter (3rd to 5th).

     This article provides a practical perspective on the various daily operations of databases, tables, schemas, indexes, and views in sql server 2008, including database elements and files, creating databases, modifying/deleting databases, Detach/Attach databases, system tables and temporary tables, column data types, create tables, modify table and column properties, move objects to new schemas, use views to update data, type indexes, create and modify indexes, and more.
third: sql server 2008 data Processing chapter (6th to 10th).

     This article is one of the main points of this book, first of all, the SELECT, INSERT, UPDATE and DELETE statements to the data query, inserting, updating and deleting, and then to explain the connection between the multiple tables query, Subqueries and the use of XML queries, as well as a simple introduction to the Transact-SQL language. Finally, two important database objects are introduced: stored procedures and triggers, including the creation and execution of normal, parameterized stored procedures, management of DML and DDL triggers, and so on.
fourth: sql server 2008 database Management Chapter (11th to 16th).

     This article on how to manage the sql server 2008 database, mainly including the management of database security, management database backup and recovery, management database automation, management Integration Services, Manage reports and analytics services, and more.
Fifth: sql server 2008 Advanced Application Chapter (17th to 19th).

    This article explains the advanced applications of sql server 2008 in 3 ways, and the 17th chapter describes how to copy and distribute from one database to another using replication technology, and the 18th chapter describes how to monitor server performance, Track user activity and optimize sql server 2008 performance; The 19th chapter describes how to use ADO to connect, manipulate, read, display, and bind data from sql server2008 databases.
sixth: sql server 2008 Comprehensive examples (chapters 20th, 23).

This article through 4 comprehensive examples to introduce the SQL Server 2008 database in the actual application, respectively is the address book, the Enterprise website, the log Management module and the voting management system.

This article from the "10675043" blog, reproduced please contact the author!

SQL Server Knowledge Point systematization study