![]() ![]() Part IV: SQL Server 2008 Database Management (Chapter 11-16). ![]() 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. ![]() 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. The third part: SQL Server 2008 data processing (Chapter 6-10). 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. Part 2: daily Operations of SQL Server 2008 (chapters 3-5). Then, various tools used in managing SQL Server 2008, such as SQL Server Management Studio and configuration manager, are introduced in detail. Then, the new functions and features of SQL Server2008 are introduced, and SQL Server2008 database is installed. Part one: basic knowledge of SQL Server 2008 (chapters 1 and 2).įirstly, 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |