| 作 者： | （美）Microsoft公司著 |
| 出版社： | 北京大学出版社 |
| 丛编项： | 微软指定MCDBA教材 |
| 版权说明： | 本书为公共版权或经版权方授权，请支持正版图书 |
| 标 签： | Sever |
| ISBN | 出版时间 | 包装 | 开本 | 页数 | 字数 |
|---|---|---|---|---|---|
| 未知 | 暂无 | 暂无 | 未知 | 0 | 暂无 |
About This Book
Chapter1 Overview of SQL Server
lesson 1:What is SQL Server
lesson 2:SQL Server Components
lesson 3:SQL Server Architecture Overview
lesson 4:SQL Server Security Overview
Review
Chapter2:Overview of Transact-SQL
lesson 1:SQL Server Programming Tools
lesson 2:Elements of Transact-SQL
lesson 3:Waysto Execute Transact-SQL Statements
Chapter3 Creating Databases
lesson 1:Introduction to Database Design
lesson 2:Introduction to SQL Server Databases
lesson 3:Creating and Dropping Databases
lesson 4:Managing Databases
lesson 5:The library Database
Review
Chapter4 Creating Database Objects
lesson 1:Creating Data Types
lesson 2:CReating Tables
lesson 3:Generating Scripts
Review
Chapter 5 Implementing Data Integrity
lesson 1:Types of Data Integrity
lesson 2:Using Constraints
lesson 3:Using Defaults and Rules
Review
Chapter 6:Planning and Creating Indexes
lesson 1:Introduction to Indexes
lesson 2:Index Architecture
lesson 3:Creating Indexes
Review
Chapter 7 Maintaining Indexes
lesson 1:Maintaining Indexes
lesson 2:Statistical Information
lesson 3:Full-Text Search
Review
Chapter 8 Querying Multiple Tables
lesson 1:Combining Data from Multiple Tables
lesson 2:Advanced Joins
Review
Chapter 9:Advanced Query Techniques
lesson 1:Subqueries
lesson 2:Using Cursors
lesson 3:Modifying Data
review
Chapter 10 Summarizing Data
lesson 1:Using Aggregate Functions
lesson 2:GROUP BY Fundamentals
lesson 3:Generating Aggregate Values within Result Sets
Review
Chapter 11 Implementing Views
lesson 1:Introduction to Views
lesson 2:Creating,Altering ,and Dropping Views
lesson 3:Advanced Topics
Review
Chapter 12 Managing Transactions and locks
lesson 1:Managing Transactions
lesson 2:SQL Server Locking
lesson 3:Managing locks
Review
Chapter 13 Working with Distributed Data
lesson 1:using External Data Sources
lesson 2:Working with Distributed Data
lesson 3:Excuting a Query on a Linked Server
Review
Chapter 14:Implementing Stored Procedures
lesson 1:Introduction to Stored Procedures
lesson 2:Creating,EXecuting,and Modifying Stored Procedures
lesson 3:Using Parameters and Error Messages
Review
Chapter 15 Implementing Triggers
lesson 1: Introducing Triggers
lesson 2: How Triggers Work
Appendices
Appendix A Questions and Answers
Appendix B Library Database CASe Study
Appendix C Database Schemas
Appendix D Performing Basic Queries
lesson 1:Retrieving Data
lesson 2:Modifying Data
Review
Glossary
Index
