Shulou(Shulou.com)06/01 Report--

Part one: basic knowledge of SQL Server 2008 (chapters 1 and 2).

Firstly, the principle knowledge of database is introduced, such as the structure of relational database and the standard database using normal form theory and Emurr model. Then, the new functions and features of SQL Server2008 are introduced, and SQL Server2008 database is installed. Then, various tools used in managing SQL Server 2008, such as SQL Server Management Studio and configuration manager, are introduced in detail.

Part 2: daily Operations of SQL Server 2008 (chapters 3-5).

This article introduces various daily operations of databases, tables, schemas, indexes and views in SQL Server 2008 from a practical point of view, including database elements and files, creating databases, modifying / deleting databases, separating / attaching databases, system tables and temporary tables, column data types, creating tables, changing table names and column attributes, moving objects to new schemas, updating data using views, types of indexes, creating and modifying indexes, etc.

The third part: SQL Server 2008 data processing (Chapter 6-10).

This article is one of the key points of this book, which first introduces the query, insertion, update and deletion of data by SELECT, INSERT, UPDATE and DELETE statements, and then introduces the use of join query, subquery and XML query between multiple tables, as well as a brief introduction to the Transact-SQL language. Finally, two important database objects, stored procedures and triggers, are introduced, including creating and executing ordinary and parameterized stored procedures, managing DML and DDL triggers, and so on.

Part IV: SQL Server 2008 Database Management (Chapter 11-16).

This paper introduces how to manage SQL Server 2008 database, including database security management, database backup and recovery, database automation, management integration service, management report and analysis service, etc.

Chapter 5: advanced applications of SQL Server 2008 (chapters 17-19).

This article explains the advanced applications of SQL Server2008 from three aspects, in which Chapter 17 describes how to use replication technology to replicate and distribute from one database to another; Chapter 18 describes how to monitor server performance, track user activity, and optimize SQL Server2008 performance; Chapter 19 describes how to use ADO.NET to connect, manipulate, read, display, and bind SQL Server2008 database data.

Part VI: comprehensive examples of SQL Server 2008 (chapters 20 and 23).

This paper introduces the application of SQL Server 2008 database in practice through four comprehensive examples, which are address book, enterprise website, log management module and voting management system.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.