本書是《微軟指定MCDBA教材（影印版）》叢書中的一本，講述如何使用SQL Server 7.0設(shè)計和實現(xiàn)企業(yè)數(shù)據(jù)庫解決方案，包括邏輯模型開發(fā)、性能設(shè)計、物理數(shù)據(jù)庫配置、Transact-SQL語句、數(shù)據(jù)庫完整性、監(jiān)視和優(yōu)化、故障診斷和排除等。本書還為您準(zhǔn)備MCP 70-029考試（面向微軟認(rèn)證數(shù)據(jù)庫管理員、微軟認(rèn)證系統(tǒng)工程師或微軟認(rèn)證解決方案開發(fā)人員）提供了指導(dǎo)。本書由微軟公司專家編寫，技術(shù)深入，權(quán)威性強，可作為信息系統(tǒng)專業(yè)人員和MCP考試應(yīng)試者的參考書。
作者簡介
暫缺《Microsoft SQL Server 7.0數(shù)據(jù)庫實現(xiàn)（影印版）》作者簡介
圖書目錄
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
鄂公網(wǎng)安備 42010302001612號 