注册 | 登录读书好,好读书,读好书!
读书网-DuShu.com
当前位置: 首页出版图书科学技术计算机/网络数据库SQL SeverMICROSOFT SQL SERVER 2005:应用技巧由入门到精通(英文版)

MICROSOFT SQL SERVER 2005:应用技巧由入门到精通(英文版)

MICROSOFT SQL SERVER 2005:应用技巧由入门到精通(英文版)

定 价:¥188.00

作 者: 美国扎实学习质量研究所 著
出版社: 世界图书出版公司
丛编项:
标 签: SQL

购买这本书可以去


ISBN: 9787506283335 出版时间: 2007-06-01 包装: 平装
开本: 16开 页数: 348 字数:  

内容简介

  本书为英文版。Take your database skills to the next level with this hands-on, step-by-step guide. Learn more-advanced skills to design, test, deploy, and maintain SQL Server databases:one step at a time. Ideal for developers who understand database essentials, this learn-by-doing tutorial offers practical guidance, code samples, and a collection of techniques to help you solve real-world business problems.Discover how to:Manage data access with server Iogins and user and server rolesImplement a disaster recovery strategyUse aggregate functions to compute totals and complex statistical valuesOptimize query performance by managing I0 statistics and designing indexesWork with remote data sources:including third-party databasesProvide remote access through the Internet or a middle-tier service interfaceManage transactions, implement error handlers, and define isolation levelsGo further and work with SQL Server Reporting Services and Notification Services

作者简介

暂缺《MICROSOFT SQL SERVER 2005:应用技巧由入门到精通(英文版)》作者简介

图书目录

Introduction
Acknowledgments
Part I HOW to Create a SQL Server Database to Store Your Application Data
1 Choosing Which Application Data to Store in Your Database
Where to Store Application Settings
Where to Store User Settings
Where to Store XML Documents
Using the XML Datatype
Using the File System with XML Data
Where to Store External Application Files.
Conclusion
Chapter 1 Quick Reference
2 Basic Database Security Principles
Designing Network Security to Secure Your Database System
   Granting Remote Access
   Securing External Access
  Managing Access to SQL Server Instances
   Selecting an Authentication Mode
   Connecting to a SQL Server Instance
  Managing Access to SQL Server Databases
   Granting Access to Databases
   Granting Database Permissions
   Managing Application Roles.
Managing Access to Schemas
Introducing Schemas
Managing Access to Tables and Columns
   Modifying Access to a Table.
   Providing Access to Columns Individually
Managing Access to Programmable Objects
   Managing Security for Stored Procedures
   Managing Security for User-Defined Functions
   Managing Security for Assemblies
   Managing Ownership Chains
   Managing the Execution Context
Conclusion
Chapter 2 Quick Reference
 3 Disaster Recovery Techniques to Protect Your Database
Using Full Database Backups.
The Simple Recovery Model
   Backup Devices
   Performing Full Database Backups
Using Differential Backups
   Performing Differential Backups
  Using Transaction Log Backups
   The Full Recovery Model
   Performing Transaction Log Backups
  Recovering a Database
   Retrieving Backup Information
   Restoring a Database Using SQL Server Management Studio
   Restoring a Database from a Simple Backup Strategy Using T-SQL
   Restoring a Database from a Full Backup Strategy Using T-SQL
   Restoring System Databases
  Scheduling Backups Using the SQL Maintenance Plan Wizard
  Conclusion
  Chapter 3 Quick Reference
 4 Transferring Your Database to Other Systems
  Using Backup and Restore to Transfer Your Data
   Full Backup Only
  Full Backup With Differential and Transaction Log Backups
Using Detach and Attach to Transfer your Data
Using Replicaton to Transfer your Data
Using SSIS to Transfer Your Data
Automationg and Scheduling the transfer of Your Data
Conclusion
Chapter 4 Quick Reference
……
Part II How to Query Data from SQL Server
Part III How to Modify Data in SQL Server
Index=

本目录推荐