Microsoft SQL Server 2005 Implementation and Maintenance 70-431 (Microsoft Official Academic Course Series) (PCK PAP/CD)

  • ポイントキャンペーン

Microsoft SQL Server 2005 Implementation and Maintenance 70-431 (Microsoft Official Academic Course Series) (PCK PAP/CD)

  • ただいまウェブストアではご注文を受け付けておりません。 ⇒古書を探す
  • 製本 Paperback:紙装版/ペーパーバック版
  • 言語 ENG,ENG
  • 商品コード 9780470874912
  • DDC分類 005

Table of Contents

    Lesson 1 Introduction                          1  (10)
Lesson Skill Matrix 1 (1)
Key Terms 1 (1)
Preparing for the Microsoft SQL Server 1 (4)
2005: Implementation and Maintenance
Course
Starting Your Adventure 1 (1)
Preparing for This Course 2 (1)
Creating a Practice Environment for 3 (2)
Independent Study
Skill Summary 5 (1)
Knowledge Assessment 5 (5)
Case Scenarios 10 (1)
Lesson 2 Installing Microsoft SQL Server 11 (13)
2005
Lesson Skill Matrix 11 (1)
Key Terms 11 (1)
Installing SQL Server 2005 11 (9)
Examining Your Environment 12 (2)
Preparing to Install 14 (3)
Upgrading from a Previous Edition 17 (1)
Installing SQL Server 2005 17 (2)
Troubleshooting the Installation 19 (1)
Skill Summary 20 (1)
Knowledge Assessment 20 (3)
Case Scenarios 23 (1)
Lesson 3 Navigating SQL Server 2005 24 (7)
Lesson Skill Matrix 24 (1)
Key Terms 24 (1)
Using SQL Server Tools 24 (5)
Understanding SQL Server Tools 24 (1)
Introducing SQL Server Management 25 (2)
Studio (SSMS)
Introducing Books Online 27 (1)
Introducing SQL Server Configuration 27 (1)
Manager
Introducing SQL Server Surface Area 27 (1)
Configuration
Introducing Nongraphical Support Tools 28 (1)
Skill Summary 29 (1)
Knowledge Assessment 29 (1)
Case Scenarios 30 (1)
Lesson 4 Datatypes 31 (16)
Lesson Skill Matrix 31 (1)
Key Terms 31 (1)
Introducing Datatypes 31 (12)
Introducing Built-in Datatypes 31 (4)
Formatting and Converting Data 35 (2)
Introducing Alias Datatypes 37 (1)
Creating CLR User-Defined Types 38 (1)
Understanding How SQL Server Organizes 39 (4)
Data in Rows
Skill Summary 43 (1)
Knowledge Assessment 43 (3)
Case Scenarios 46 (1)
Lesson 5 Databases 47 (14)
Lesson Skill Matrix 47 (1)
Key Terms 47 (1)
Using Databases 47 (9)
Using SQL Server 2005 47 (1)
Planning Your Database 48 (3)
Creating Data Storage Structures 51 (1)
Creating and Configuring Databases 52 (4)
Skill Summary 56 (1)
Knowledge Assessment 57 (3)
Case Scenarios 60 (1)
Lesson 6 Tables 61 (8)
Lesson Skill Matrix 61 (1)
Key Terms 61 (1)
Using Tables 61 (4)
Creating Tables 61 (3)
Partitioning Tables 64 (1)
Skill Summary 65 (1)
Knowledge Assessment 66 (2)
Case Scenarios 68 (1)
Lesson 7 Performing Indexing and Full-Text 69 (18)
Searching
Lesson Skill Matrix 69 (1)
Key Terms 69 (1)
Using Indexes 70 (12)
Understanding Index Architecture 70 (7)
Partitioned Indexes 77 (1)
Creating Indexes 78 (2)
Using Full-Text Searching 80 (2)
Skill Summary 82 (1)
Knowledge Assessment 83 (3)
Case Scenarios 86 (1)
Lesson 8 Views 87 (11)
Lesson Skill Matrix 87 (1)
Key Terms 87 (1)
Using Views 87 (6)
Understanding Views 87 (1)
Modifying Data through a View 88 (2)
Working with Indexed Views 90 (2)
Making a Partitioned View 92 (1)
Skill Summary 93 (1)
Knowledge Assessment 93 (4)
Case Scenarios 97 (1)
Lesson 9 Constraints 98 (6)
Lesson Skill Matrix 98 (1)
Key Terms 98 (1)
Restricting the Data 98 (4)
Introducing Constraints 98 (3)
Introducing Primary and Foreign Keys 101(1)
Skill Summary 102(1)
Knowledge Assessment 102(1)
Case Scenarios 103(1)
Lesson 10 Stored Procedures 104(10)
Lesson Skill Matrix 104(1)
Key Terms 104(1)
Using Stored Procedures 104(7)
Introducing Stored Procedures 104(5)
Introducing CLR Procedures 109(1)
Reviewing Development Guidance 110(1)
Processing Stored Procedures 111(1)
Skill Summary 111(1)
Knowledge Assessment 112(1)
Case Scenarios 112(2)
Lesson 11 Triggers 114(11)
Lesson Skill Matrix 114(1)
Key Terms 114(1)
Using Triggers 114(6)
Introducing Triggers 114(1)
Understanding DML Triggers 115(2)
Understanding DDL Triggers 117(1)
Understanding Trigger Recursion and 118(1)
Nesting
Understanding Disabling Triggers 119(1)
Understanding Event Notifications 119(1)
Skill Summary 120(1)
Knowledge Assessment 120(4)
Case Scenarios 124(1)
Lesson 12 Functions 125(14)
Lesson Skill Matrix 125(1)
Key Terms 125(1)
Introducing Functions 125(12)
Understanding Functions 125(1)
Using Built-in Functions 126(6)
Creating Functions 132(2)
Introducing CLR Functions 134(1)
Understanding Deterministic and 135(1)
Nondeterministic Functions
Using Schema Building 136(1)
Skill Summary 137(1)
Knowledge Assessment 137(1)
Case Scenarios 138(1)
Lesson 13 Transactions and Locks 139(19)
Lesson Skill Matrix 139(1)
Key Terms 139(1)
Using Transactions 140(15)
Understanding Transactions 140(4)
Understanding Locks 144(5)
Using Data Manipulation Language Queries 149(2)
Introducing Error Handling 151(3)
Using Two Additional SQL Server Features 154(1)
Skill Summary 155(1)
Knowledge Assessment 155(2)
Case Scenarios 157(1)
Lesson 14 Moving Data 158(11)
Lesson Skill Matrix 158(1)
Key Terms 158(1)
Moving Data 158(8)
Understanding the Tools Available 159(1)
Importing Data Using Bulk Insert 159(1)
Importing Data Using the bcp Utility 160(1)
Using SSIS 161(3)
Copying Databases 164(1)
Bulk-Inserting XML Data 165(1)
Supporting the Bulk-Logged Recovery 166(1)
Model
Skill Summary 166(1)
Knowledge Assessment 167(1)
Case Scenarios 168(1)
Lesson 15 XML Data 169(20)
Lesson Skill Matrix 169(1)
Key Terms 169(1)
Introducing XML Data 169(3)
Using XML 170(1)
Understanding XML Data 171(1)
Case Study: Working with the XML Datatype 172(8)
to Ease a Relational Model and Optimize
Database Performance
Working with XML Schema 173(1)
Storing Typed XML Data 173(2)
Querying XML Data 175(3)
Decomposing XML Data 178(1)
Creating XML Triggers 179(1)
Case Study: Implementing XML in SQL 2005 180(1)
Skill Summary 181(1)
Knowledge Assessment 181(7)
Case Scenarios 188(1)
Lesson 16 Permissions 189(30)
Lesson Skill Matrix 189(1)
Key Terms 189(1)
Guarding Your Data 190(21)
Understanding Security Modes 190(1)
Understanding SQL Server Logins 191(3)
Understanding the Items Common to All 194(3)
Logins
Understanding SQL Server's Security 197(4)
Architecture
Understanding Database Roles 201(3)
Understanding Permission States 204(2)
Introducing Ownership Chains 206(1)
Introducing Linked Server Security 207(1)
Introducing Encryption 208(1)
Creating a Security Plan 209(2)
Skill Summary 211(1)
Knowledge Assessment 212(6)
Case Scenarios 218(1)
Lesson 17 Backing Up and Restoring 219(23)
Lesson Skill Matrix 219(1)
Key Terms 219(1)
Maintaining Data Integrity 219(17)
Enforcing Organizational Security 220(1)
Policies
Implementing the First Layer of Defense 221(1)
Understanding How Backups Work 221(8)
Restoring Databases 229(5)
Devising a Backup Strategy 234(2)
Skill Summary 236(1)
Knowledge Assessment 237(4)
Case Scenarios 241(1)
Lesson 18 Maintaining and Automating SQL 242(27)
Server
Lesson Skill Matrix 242(1)
Key Terms 242(1)
Automating Administrative Activities 243(19)
Maintaining Indexes 243(3)
Maintaining Databases 246(2)
Understanding Automation Basics 248(1)
Configuring Database Mail 249(2)
Creating Operators 251(1)
Creating Jobs 252(2)
Creating Alerts 254(6)
Using the Maintenance Plan Wizard 260(2)
Case Study: Automating Tasks 262(1)
Skill Summary 262(2)
Knowledge Assessment 264(4)
Case Scenarios 268(1)
Lesson 19 Monitoring and Optimizing SLQ 269(20)
Server
Lesson Skill Matrix 269(1)
Key Terms 270(1)
Monitoring and Optimizing Activities 270(12)
Using System Monitor 270(3)
Monitoring with SQL Profiler 273(3)
Using the Database Engine Tuning Advisor 276(2)
Troubleshooting SQL Server 278(3)
Using the Dedicated Administrator 281(1)
Connection
Case Study: Monitoring Counters 282(1)
Skill Summary 283(1)
Knowledge Assessment 284(4)
Case Scenarios 288(1)
Lesson 20 High-Availability Methods 289(27)
Lesson Skill Matrix 289(1)
Key Terms 289(1)
Choosing the Redundancy Features You Need 290(20)
Implementing Database Mirroring 291(1)
Understanding Database Mirroring 291(13)
Concepts
Implementing Log Shipping 304(2)
Managing Database Snapshots 306(4)
Case Study: Using Other High-Availability 310(1)
Methods
Skill Summary 311(1)
Knowledge Assessment 311(4)
Case Scenarios 315(1)
Lesson 21 Service Broker 316(17)
Lesson Skill Matrix 316(1)
Key Terms 316(1)
Understanding the SQL Server Service 316(12)
Broker Architecture
Working with Service Broker 317(4)
Using Service Broker 321(7)
Case Study: Implementing a Broker 328(1)
Architecture
Skill Summary 328(1)
Knowledge Assessment 329(3)
Case Scenarios 332(1)
Lesson 22 Endpoints 333(8)
Lesson Skill Matrix 333(1)
Key Terms 333(1)
Introducing HTTP Endpoints 333(5)
Configuring HTTP Endpoints 334(3)
Securing HTTP Endpoints 337(1)
Skill Summary 338(1)
Knowledge Assessment 338(2)
Case Scenarios 340(1)
Lesson 23 Replication 341
Lesson Skill Matrix 341(1)
Key Terms 341(1)
Introducing Replication 341(22)
Understanding Replication Factors and 344(3)
Distribution Types
Understanding Replication Internals 347(1)
Understanding Merge Replication 348(2)
Understanding Snapshot Replication 350(1)
Understanding Transactional Replication 351(2)
Understanding Replication Models 353(3)
Replicating over the Internet and to 356(1)
Heterogeneous Database Servers
Installing and Using Replication 357(4)
Managing Replication 361(2)
Case Study: Deciding on a Replication 363(1)
Model and Type
Skill Summary 364(2)
Knowledge Assessment 366(4)
Case Scenarios 370
Appendix A 1 (1)
Appendix B 1 (370)
Glossary 371(4)
Index 375
1 Introducing the Course 1 (3)
Exercise 1.1 Checking for Background 1 (3)
(Prerequisite) Knowledge
2 Installing SQL Server 2005 4 (12)
Exercise 2.1 Installing SQL Server 2005 4 (8)
Manually
Exercise 2.2 Installing a Second Instance 12 (4)
3 Navigating SQL Server 16 (3)
Exercise 3.1 Locating Information by 16 (3)
Using SQL Server 2005 Utilities
4 Working with Datatypes 19 (2)
Exercise 4.1 Creating a Datatype by Using 19 (2)
SSMS Object Explorer
5 Working with Databases 21 (5)
Exercise 5.1 Creating a Database 21 (3)
Exercise 5.2 Selecting and Setting a 24 (2)
Recovery Model
6 Working with Tables 26 (6)
Exercise 6.1 Designing and Creating Tables 26 (6)
7 Working with Indexes 32 (9)
Exercise 7.1 Designing and Creating a 32 (2)
Clustered Index
Exercise 7.2 Designing and Creating a 34 (2)
Nonclustered Index
Exercise 7.3 Designing and Creating a 36 (5)
Full-Text Index
8 Working with Views 41 (3)
Exercise 8.1 Designing and Creating a View 41 (3)
9 Working with Constraints 44 (3)
Exercise 9.1 Designing and Creating a 44 (3)
Constraint
10 Working with Stored Procedures 47 (2)
Exercise 10.1 Designing and Creating a 47 (2)
Stored Procedure
11 Working with Triggers 49 (11)
Exercise 11.1 Designing and Creating an 49 (3)
Insert Trigger
Exercise 11.2 Designing and Creating a 52 (2)
Delete Trigger
Exercise 11.3 Designing and Creating an 54 (2)
Update Trigger
Exercise 11.4 Designing and Creating an 56 (4)
Instead Of Trigger
12 Working with Functions 60 (3)
Exercise 12.1 Designing and Creating a 60 (3)
User-Defined Function
13 Working with Transactions and Locks 63 (3)
Exercise 13.1 Identifying and Rectifying 63 (3)
the Cause of a Block
14 Moving Data 66 (7)
Exercise 14.1 Using the Copy Database 66 (7)
Wizard
15 Working with XML Data 73 (8)
Exercise 15.1 Using the XML Datatype 73 (8)
16 Setting Permissions 81 (25)
Exercise 16.1 Creating a Windows Login 81 (3)
Exercise 16.2 Creating a Standard Login 84 (2)
Exercise 16.3 Assigning Logins to Fixed 86 (2)
Server Roles
Exercise 16.4 Creating a Database User 88 (2)
Mapping
Exercise 16.5 Assigning User Mappings to 90 (3)
Fixed Database Roles
Exercise 16.6 Creating a Custom Database 93 (3)
Role
Exercise 16.7 Creating an Application Role 96 (3)
Exercise 16.8 Assigning Permissions 99 (3)
Exercise 16.9 Configuring Encrypted 102(4)
Connections
17 Backing Up and Restoring Data 106(22)
Exercise 17.1 Creating a Backup Device 106(2)
Exercise 17.2 Performing a Full Backup 108(3)
Exercise 17.3 Performing a Differential 111(2)
Backup
Exercise 17.4 Performing a Transaction 113(2)
Log Backup
Exercise 17.5 Performing a Filegroup 115(5)
Backup
Exercise 17.6 Restoring a Database 120(4)
Exercise 17.7 Performing a Point-in-Time 124(4)
Restore
18 Automating Maintenance 128(31)
Exercise 18.1 Configuring Database Mail 128(5)
Exercise 18.2 Creating an Operator 133(3)
Exercise 18.3 Creating a Job 136(4)
Exercise 18.4 Creating an Alert 140(2)
Exercise 18.5 Creating a Database 142(10)
Maintenance Plan
Exercise 18.6 Creating a SQL Server 152(4)
Performance Alert
Exercise 18.7 Creating a WMI Alert 156(3)
19 Monitoring and Optimizing 159(17)
Exercise 19.1 Using Windows System Monitor 159(3)
Exercise 19.2 Creating an Alert in 162(2)
Windows System Monitor
Exercise 19.3 Running a Trace in Profiler 164(3)
Exercise 19.4 Creating a Workload in 167(2)
Profiler
Exercise 19.5 Using the Database Engine 169(4)
Tuning Advisor
Exercise 19.6 Using the Dedicated 173(3)
Administrator Connection
20 Working with High-Availability Methods 176(20)
Exercise 20.1 Implementing Database 176(7)
Mirroring
Exercise 20.2 Implementing Log Shipping 183(6)
Exercise 20.3 Creating a Database Snapshot 189(4)
Exercise 20.4 Reverting from a Database 193(3)
Snapshot
21 Working with Service Broker 196(6)
Exercise 21.1 Creating a Service Broker 196(6)
Object
22 Working with Endpoints 202(3)
Exercise 22.1 Working with Endpoints 202(3)
23 Working with Replication 205
Exercise 23.1 Choosing a Replication Type 205(3)
Exercise 23.2 Designing a Replication 208(2)
Topology
Exercise 23.3 Configuring Replication 210(4)
Exercise 23.4 Creating a Transactional 214(6)
Publication
Exercise 23.5 Subscribing to a 220(5)
Transactional Publication
Exercise 23.6 Creating a Snapshot 225(7)
Publication
Exercise 23.7 Subscribing to a Snapshot 232(5)
Publication
Exercise 23.8 Creating a Merge Publication 237(7)
Exercise 23.9 Subscribing to a Merge 244(6)
Publication
Exercise 23.10 Resolving Merge Conflicts 250(3)
Exercise 23.11 Monitoring Replication 253