内容简介

本书主要讲述如何实现SQL Server 7．0数据库，内容包括Transact-SQL语言的介绍、数据库和表的创建、数据完整性的概念、索引的设计与创建、一般和查询、数据的汇总、事务的处理、使用分布式数据、视图的实现、使用存储过程和触发器，同时还介绍了加锁和文本查询；本书阐述了大量的基本知识，并提供了循序渐进的练习，使读者可以充分了解和掌握SQL Server 7.0。 本书适用于计划参加相关的微软认证考试的人员使用。

目录

about This Curse Introduction Introductions Course Materials Prerequisites Course Outline Course Outline Course Outline Appendices Microsoft Certified Professional Program Facilities Module 1 : SQL Server Overview What Is SQL Server SQL Server Architecture SQL Server Security SQL Server Databases Working with SQL Server Lab II: SQL Server Overview Review. Module 2: Overview of Transact-SQL SQL Server Programming Tools. The Transact-SQL Programming Language Elements of Transact-SQL Ways to Execute Transact-SQL Statements How Queries Are Processed Recommended Practices Lab 2. l : Overview of Transact-SQL Review Module 3: Creating Databases How Data Is Stored Creating Databases Modifying Databases Creating Filegroups Lab 3. l : Creating Databases The Library Database Creating Data Types Creating Tables Generating scripts Recommended Practices Lab 3.2: Creating Database Objects Review Module 4:Implementing Data Integrity Types of Data Integrity Enforcing Data Integrity Using Constraints Using Defaults and Rules Deciding Which Enforcement Method to Use Recommended Practices Lab 4. l : Implementing Data Integrity Review Module 5:Planning and Creating Indexes Introduction to Indexes Index Architecture Creating Indexes CREATE INDEX Options Lab 5. l : Creating Indexes Maintaining Indexes Performance Considerations Recommended Practices Lab 5.2: Maintaining Indexes Review Module 6: Querying Multiple Tables Combining Data from Multiple Tables Combining Multiple Result Sets Creating a Table from a Result Set Recommended Practices Lab 6. l : Querying Multiple Tables Review Module 7: Advanced Query Techniques Introduction to Subqueries Nested Subqueries Correlated Subqueries Using the EXISTS and NOT EXTSTS Keywords Modifying Data Recommended Practices Lab 7. l : Advanced Query Techniques Review Module 8: Summarizing Date Using Aggregate Functions. GROUP BY Fundamentals Generating Aggregate Values Within Result Sets Using the COMPUTE and COMPUTE BY Clauses Listing the TOP n Values Recommended Practices Lab 8. l : Summarizing Data Review Module 9: Managing Transactions and Locks Introduction to Transactions and Locks Managing Transactions Managing Locks Deadlocks. Recommended Practices Lab 9. 1 : Managing Transactions and Locks Review Module 10: Working with Distributed Data Introduction to Distributed Queries Executing an Ad Hoc Query on a Remote Data Source Setting Up a linked Server Environment Executing a Query on a linked Server Executing a Stored Procedure on a linked Server Modifying Data on a linked Server Distributing Data. Recommended Practices Lab 10.l : Working with Distributed Data Review . Module 11 : Implementing Views What Is a View Advantages of Views Defining Views Modifying Data Through Views Performance Considerations Recommended Practices Lab 1l.1: Implementing Views Review Module