Microsoft SQL SERVER 2005数据库基础 由入门到精通 英文【2025|PDF|Epub|mobi|kindle电子书版本百度云盘下载】

Microsoft SQL SERVER 2005数据库基础 由入门到精通 英文PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

Part Ⅰ Introduction to Database Development with Microsoft SQL Server 20053

1 Introducing Database Development with Microsoft SQL Server 20053

The Process of Storing and Managing Data3

Introducing Database Systems4

Understanding the Requirements of a Database System5

Defining the Architecture of a Database Application7

Using a Monolithic Application with Data Embedded in the Application Code7

Using a Monolithic Application with Data Stored in an External File8

Using a Database Application with Data Managed by a Database Server9

Using an Application with a Generic Data Access Layer9

Using an Application with Separated Presentation, Business, and Data Access Layers10

Using a Complex Application with Multiple Options for Each Layer12

Conclusion13

2 Installing and Setting Up Your Microsoft SQL Server 2005 Development Environment15

Using a Virtual PC15

Operating System Requirements for Development of SQL Server Database Applications15

Recommended Productivity Tools16

Using Performance Monitor16

Using Network Monitor16

Using Upgrade Advisor17

Recommended Development Tools17

Microsoft SQL Server 2005 Editions18

Microsoft SQL Server Express Edition18

Microsoft SQL Server Workgroup Edition18

Microsoft SQL Server Standard Edition18

Microsoft SQL Server Enterprise Edition18

Installing SQL Server 200519

Using the Surface Area Configuration Tool27

Conclusion29

Chapter 2 Quick Reference29

3 Reviewing Microsoft SQL Server 2005 Management Tools31

Introduction31

Using SQL Server Books Online31

Using SQL Server Configuration Manager32

Using the SQL Server 2005 Services Node33

Using the SQL Server 2005 Network Configuration Node34

Using the SQL Native Client Configuration Node37

Using SQL Server Surface Area Configuration39

Using Surface Area Configuration For Services And Connections40

Using Surface Area Configuration For Features41

Sac Utility41

Using SQL Server Management Studio42

Administering Servers with SQL Server Management Studio42

Using Object Explorer in SQL Server Management Studio47

Writing Scripts in SQL Server Management Studio53

Writing Solutions and Projects in SQL Server Management Studio56

Using SQL Server Management Studio Templates57

Using SQL Server Profiler59

Using the SQL Server Profiler Tool and Creating a Trace59

When Should You Use SQL Server Profiler?62

Accessing Event Types62

Running SQL Server Profiler and Performance Monitor Together63

Viewing Deadlocks in SQL Server Profiler64

Using Database Engine Tuning Advisor65

Analyzing Database Engine Tuning Advisor65

Working with Database Engine Tuning Advisor65

Managing Database Engine Tuning Advisor Sessions68

Using SQLCmd68

Working with the SQLCmd Utility69

Executing Script Files69

Conclusion70

Chapter 3 Quick Reference70

Part Ⅱ How to Create a Microsoft SQL Server 2005 Database73

4 Gathering and Understanding Business Requirements before Creating Database Objects73

Understanding Business Processes and User Interaction Requirements73

Defining the Business Problem74

Capturing Requirements74

Writing Requirements76

Understanding Business Data and Its Lifetime76

Architecture and Operational Requirements77

Availability77

Predicting the Volume of Information to Store and Manage and Predicting Database Utilization83

Using Transaction Cost Analysis83

Conclusion90

Chapter 4 Quick Reference90

Designing a Database to Solve Business Needs91

Designing a Database Conceptually91

Validating Business Requirements through Conceptual Models92

Approving the Model98

Designing a Database Logically to Leverage the Relational Engine98

Creating Columns to Capture Object Attributes99

Validating the Data108

Physically Creating a Database111

Selecting an Appropriate Storage Design for a Database111

Creating a Database112

Designing Database Schemas to Logically Group Database Objects114

Creating Tables to Implement a Design115

Conclusion117

Chapter 5 Quick Reference117

Part Ⅲ How to Query Data from Microsoft SQL Server 2005121

6 Reading Microsoft SQL Server 2005 Data from Client Applications121

Introducing Microsoft Data Access Components121

Avoiding Deprecated MDAC Components121

Outlining the MDAC Architecture122

Understanding Open Database Connectivity (ODBC)123

Understanding OLE DB and ADO126

Understanding ADO.NET129

Introducing the .NET SQL Server Data Provider131

Using the SqlConnection Class131

Using the SqlCommand Class132

Using the SqlDataReader Class133

Using the SqlDataAdapter Class133

Using the TableAdapter Class136

Introducing SQL Native Client138

Using the XML Datatype139

Using Multiple Active Result Sets (MARS)139

Using Query Notification140

Conclusion142

Chapter 6 Quick Reference142

7 Selecting the Data You Need143

Selecting Data from a Single Table143

Using AND and OR Operators145

Comparing NULL Values146

Using the CASE Statement147

Using Search Arguments148

Selecting Data from Multiple Tables149

Using Aliases150

Using the INNER JOIN Syntax151

Using More than Two Tables151

Using LEFT JOIN152

Using RIGHT JOIN154

Using FULL JOIN155

Reading Single Values155

Using System-Supplied Scalar Functions156

Designing and Using Scalar UDFs163

Designing and Using Stored Procedures to Retrieve Scalar Values164

Reading Relational and XML Data165

Viewing XML Results in SQL Server Management Studio166

Converting Relational Data to XML Format167

Converting XML Data to Relational Format172

Querying XML and Relational Data Using XQuery174

Sorting Data176

Conclusion178

Chapter 7 Quick Reference178

8 Creating Views to Encapsulate Queries179

Selecting Data from a Single View179

Creating a View179

Modifying a View Definition183

Updating Data through a View184

Partitioned Views185

Mixing Data from Views and Tables186

Working with Views within Client Applications186

Conclusion188

Chapter 8 Quick Reference188

9 Retrieving Data Using Programmable Objects191

Introduction191

Working through a Simple Problem192

Understanding Scalar UDFs194

Retrieving Result Sets197

Updating Data203

Common Language Runtime UDFs and Procedures207

Working with Statistical Calculations208

Working with CLR Stored Procedures216

Conclusion217

Chapter 9 Quick Reference218

Part Ⅳ How to Modify Data in Microsoft SQL Server 2005221

10 Inserting Data in Microsoft SQL Server 2005221

Using the INSERT Statement221

Creating an INSERT Sentence with SQL Server Management Studio221

Using Special Values for Row Insertion223

Using Other Forms of the INSERT Statement224

Inserting Data through Views225

Using the WITH Clause226

Using INSTEAD OF INSERT Triggers on Views227

Importing Data into SQL Server 2005228

Using the BCP Utility228

Using the BULK INSERT Command230

Using Integration Services to Insert Data231

Creating Your Own Package236

Encapsulating Insert Operations in Stored Procedures241

Triggering Actions Automatically when Inserting Data243

Dealing with Errors when Inserting Data245

Managing the Error247

Inserting Data from ADO.NET249

Conclusion250

Chapter 10 Quick Reference250

11 Deleting Data from Microsoft SQL Server 2005253

Using the DELETE Statement253

Creating a DELETE Sentence with SQL Server Management Studio253

Defining the WHERE Condition254

Using Relationships to Perform Deletions255

Deleting Data through Views256

Using INSTEAD OF DELETE Triggers on Views257

Encapsulating Delete Operations in Stored Procedures258

Implementing Pessimistic Concurrency for Delete Operations259

Implementing Optimistic Concurrency for Delete Operations261

Triggering Actions Automatically when Deleting Data265

Dealing with Errors266

Data Does Not Exist266

Data to Be Deleted Is Related to Other Tables267

Other Errors268

Deleting Data from ADONET268

Managing Errors during the Delete Process270

Conclusion271

Chapter 11 Quick Reference272

12 Updating Data from Microsoft SQL Server 2005273

Using the UPDATE Statement273

Creating an UPDATE Sentence with SQL Server Management Studio273

Defining the WHERE Condition274

Assigning New Values to Columns274

Using Arithmetic to Update Information275

Changing the Content of a Large(MAX)Column276

Changing the Content of a Large(BLOB)Column276

Updating Data through Views276

Using INSTEAD OF UPDATE Triggers on Views277

Encapsulating Update Operations in Stored Procedures279

Implementing Pessimistic and Optimistic Concurrency for Update Operations281

Triggering Actions Automatically when Updating Data282

Dealing with Errors283

Assigned Value Is Higher than the Field Datatype Limit284

Column Value Violates Referential Integrity284

Updating Data from ADONET284

Using Datasets and Table Adapters285

Using Stored Procedures with Table Adapters289

Conclusion296

Chapter 12 Quick Reference296

Index297