Muutke küpsiste eelistusi

MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431) 3rd edition [Raamat]

  • Formaat: Book, 640 pages, kõrgus x laius x paksus: 229x183x33 mm, kaal: 1071 g, 200 Illustrations
  • Ilmumisaeg: 16-Jul-2007
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0072263210
  • ISBN-13: 9780072263213
Teised raamatud teemal:
  • Raamat
  • Hind: 56,30 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431) 3rd editionSuurem pilt
  • Formaat: Book, 640 pages, kõrgus x laius x paksus: 229x183x33 mm, kaal: 1071 g, 200 Illustrations
  • Ilmumisaeg: 16-Jul-2007
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0072263210
  • ISBN-13: 9780072263213
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780072263213.html
Märksõnad:
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.



The Best Fully Integrated Study System Available With hundreds of practice questions and hands-on exercises, MCTS SQL Server 2005 Implementation & Maintenance Study Guide covers what you need to know--and shows you how to prepare--for this challenging exam.





100% complete coverage of all official objectives for Exam 70-431

Exam Readiness Checklist at the front of the book--you're ready for the exam when all objectives on the list are checked off

Inside the Exam sections in every chapter highlight key exam topics covered

Simulated exam questions match the format, tone, topics, and difficulty of the real exam



Covers all the exam topics, including:

Installing and Configuring SQL Server 2005 * Creating Databases and Database Objects * SQL Server Security * Creating Views, Partitions, and Linked Servers * Transact-SQL Programming * Working with Constraints, Triggers, and Stored Procedures * Backup and Restore of SQL Server with SQL Agent Jobs * Data Redundancy and Availability * Using the Service Broker * XML Data Support * SQL Server Performance Monitoring and Tuning * Troubleshooting Server and Database Errors

CD-ROM includes:





Complete MasterExam practice testing engine, featuring: One full practice exam; Detailed answers with explanations; Score Report performance assessment tool

Video training clips from the author

Electronic book for studying on the go



With free online registration:





One-hour LearnKey video training session

Bonus downloadable MasterExam practice test
About the Contributors v
Preface xvii
Acknowledgments xxi
Introduction xxiii
Installing SQL Server 2005
1(48)
Verify Prerequisites
2(13)
SQL Server 2005 Editions
2(6)
Hardware Requirements
8(3)
Operating System Requirements
11(1)
Database-Imposed Requirements
12(3)
Create an Instance
15(13)
Default and Named Instances
15(3)
Installing a Default Instance
18(7)
Exercise 1-1: Installing a Default Instance of SQL Server 2005
25(3)
Installing a Named Instance
28(1)
Upgrade from an Earlier Version of SQL Server
28(10)
Upgrading from SQL Server 6.5
29(1)
Upgrading from SQL Server 7.0 or 2000
30(1)
Upgrade Types
30(6)
Two-Minute Drill
36(2)
Q&A Self Test
38(11)
Lab Question
43(1)
Self Test Answers
44(3)
Lab Answer
47(2)
Configuring SQL Server 2005
49(56)
Configure SQL Server 2005 Instances and Databases
50(33)
Using SQL Server Configuration Manager
51(10)
Exercise 2-1: Creating an Alias
61(1)
Using SSMS
62(4)
Configuring Server Properties with SSMS
66(8)
Using the sqlcmd Command Line Utility
74(2)
Working with the System and Sample Databases
76(2)
Exercise 2-2: Installing the Sample Databases
78(4)
Adding and Removing Components and Features
82(1)
Configure the SQL Server Database Mail Subsystem for an Instance
83(6)
Changes Since SQL Mail
83(1)
Configuring Database Mail
84(1)
Exercise 2-3: Configuring the MSDB Database as a Mailhost
85(1)
Exercise 2-4: Configuring SQL Server Agent to Use the Mail Profile
86(1)
Exercise 2-5: Creating Operators That Use Database Mail
87(2)
Implement an HTTP Endpoint
89(7)
Creating an HTTP Endpoint
90(2)
Securing an HTTP Endpoint
92(2)
Two-Minute Drill
94(2)
Q&A Self Test
96(9)
Lab Question
100(1)
Self Test Answers
101(2)
Lab Answer
103(2)
Creating Databases and Database Objects
105(44)
Configure Log Files and Data Files
106(7)
Creating Databases
106(6)
Exercise 3-1: Creating a Database in SSMS
112(1)
Implement a Table
113(10)
Understanding Tables and Data Types
114(6)
Creating Tables in SSMS and T-SQL
120(2)
Exercise 3-2: Creating Tables in T-SQL
122(1)
Implement Indexes
123(7)
Understanding and Implementing Indexes
123(7)
Implement a Full-Text Search
130(9)
Understanding and Implementing Full-Text Search
130(7)
Two-Minute Drill
137(2)
Q&A Self Test
139(10)
Lab Question
144(1)
Self Test Answers
145(2)
Lab Answer
147(2)
SQL Server Security
149(42)
SQL Server Security Overview
150(2)
Configure Server Security Principals
152(13)
Creating and Managing Principals and Roles
152(3)
Exercise 4-1: Creating a SQL Login
155(3)
Exercise 4-2: Creating Windows Logins
158(7)
Configure Database Securables
165(10)
Managing Permissions to Database Securables
166(4)
Exercise 4-3: Permission Management in SQL Server Management Studio
170(5)
Configure Encryption
175(7)
Understanding Encryption in SQL Server 2005
175(1)
Implementing Encryption in SQL Server 2005
176(1)
Exercise 4-4: Encrypting Data in a Database
177(3)
Two-Minute Drill
180(2)
Q&A Self Test
182(9)
Lab Question
186(1)
Self Test Answers
187(1)
Lab Answer
188(3)
Creating Views, Partitions, and Linked Servers
191(34)
Implement a View
192(13)
Types of Views
193(2)
Creating a View
195(2)
Creating an Indexed View
197(2)
Creating an Updatable View
199(1)
Assigning Permissions for a View
200(1)
Exercise 5-1: Creating Views in SSMS and with T-SQL
200(4)
Querying a View
204(1)
Implement Partitions
205(6)
Partition Functions
207(1)
Creating Partition Schemes and Partitioned Tables and Indexes
208(3)
Configure Linked Servers
211(8)
Determining the External Data Source
212(1)
Identifying the Characteristics of the Data Source
212(1)
Identifying the Security Model of the Data Source
213(1)
Creating a Linked Server
214(3)
Two-Minute Drill
217(2)
Q&A Self Test
219(6)
Lab Question
222(1)
Self Test Answers
223(1)
Lab Answer
224(1)
Transact-SQL Programming
225(78)
SQL Overview
226(4)
SQL Statement Types
230(1)
SQL Coding Suggestions
231(10)
Retrieve Data to Support Ad Hoc and Recurring Queries
241(22)
Querying SQL Server
241(22)
Manipulate Relational Data
263(10)
Creating, Updating, and Deleting Data
263(6)
Managing Transactions and Handling Errors
269(4)
Manage Databases by Using Transact-SQL
273(20)
Managing Database Objects
273(7)
New T-SQL Features in SQL Server 2005
280(11)
Two-Minute Drill
291(2)
Q&A Self Test
293(10)
Lab Question
298(1)
Self Test Answers
299(2)
Lab Answer
301(2)
Working with Constraints, Triggers, and Stored Procedures
303(34)
Implement Constraints
304(8)
Data Integrity
304(2)
Constraints
306(3)
Creating Constraints
309(3)
Implement Triggers
312(6)
Understanding Triggers
312(4)
Creating DML Triggers
316(1)
Creating DDL Triggers
317(1)
Trigger Execution Order
318(1)
Create User-Defined Types
318(5)
More Data Integrity
319(1)
Creating T-SQL (Alias) User-Defined Types
319(2)
Creating CLR User-Defined Types
321(2)
Implement Stored Procedures
323(2)
Store Procedures Unveiled
323(1)
Creating a Stored Procedure
324(1)
Securing Stored Procedures
325(1)
Implement Functions
325(6)
Function Types
325(1)
Creating Functions
326(3)
Two-Minute Drill
329(2)
Q&A Self Test
331(6)
Lab Question
334(1)
Self Test Answers
335(1)
Lab Answer
336(1)
Backup and Restore of SQL Server with SQL Agent Jobs
337(40)
Back Up a Database
338(13)
Creating a Backup Plan
338(2)
Choosing a Recovery Model
340(2)
Using the Different Backup Types
342(3)
Exercise 8-1: Performing a Full Backup
345(2)
Working with Backup Devices and Files
347(3)
Performing Filegroup Backups
350(1)
Backing Up System Databases
350(1)
Restore a Database
351(3)
Choosing a Restore Method
351(1)
Restoring to a Point in Time
352(1)
Restoring to the Point of Failure
353(1)
Restoring System Databases
353(1)
Implement and Maintain SQL Server Agent Jobs
354(12)
Understanding Jobs
354(1)
Creating Operators
355(1)
Exercise 8-2: Creating an Operator
355(1)
Implementing Jobs
356(4)
Maintaining and Managing Jobs
360(1)
Database Maintenance Plans
360(2)
Exercise 8-3: Creating a Database Maintenance Plan
362(3)
Using Alerts
365(1)
Move a Database Between Servers
366(5)
Moving Databases
366(3)
Two-Minute Drill
369(2)
Q&A Self Test
371(6)
Lab Question
374(1)
Self Test Answers
375(1)
Lab Answer
376(1)
Data Redundancy and Availability
377(44)
Data Availability
378(3)
Implement Database Mirroring
381(7)
Database Mirroring Components
381(2)
Understanding Operating Modes
383(1)
Planning for Role Switching
384(1)
Implementing Database Mirroring
385(3)
Implement Log Shipping
388(5)
Inside the Log Shipping Process
389(2)
Configuring Log Shipping and Monitoring
391(2)
Manage Database Snapshots
393(3)
Database Snapshot Functionality
393(1)
Implementing a Snapshot
394(1)
Querying a Snapshot
395(1)
Reverting to a Snapshot
395(1)
Manage Replication
396(7)
Replication Roles and Concepts
396(1)
Replication Types
396(3)
Replication Models
399(1)
Configuring a Publisher and Distributor
399(3)
Configuring a Subscriber
402(1)
Monitoring Replication
402(1)
Replication Performance
402(1)
Replication Recovery
403(1)
Import and Export Data from a File
403(12)
Using BCP
404(2)
Bulk Insert Commands
406(1)
Openrowset
407(1)
Using Integration Services
407(6)
Two-Minute Drill
413(2)
Q&A Self Test
415(6)
Lab Question
418(1)
Self Test Answers
419(1)
Lab Answer
420(1)
Using the Service Broker
421(22)
Implement Service Broker Components
422(15)
Understanding Service Broker
423(5)
Creating Service Broker Objects
428(4)
Sending Messages
432(1)
Exercise 10-1: Implementing a Service Broker Solution
432(4)
Two-Minute Drill
436(1)
Q&A Self Test
437(6)
Lab Question
439(1)
Self Test Answers
440(1)
Lab Answer
441(2)
XML Data Support
443(26)
XML: The Jet Tour
444(3)
XML in SQL Server: An Overview
447(1)
Manage XML Data
447(19)
XML Data Types
447(3)
Inserting XML Data
450(1)
Retrieving XML Data
451(6)
Modifying XML Data
457(2)
Creating an XML Index
459(1)
Using Schemas to Meet Consumers' Structure Needs
460(5)
Two-Minute Drill
465(1)
Q&A Self Test
466(3)
Lab Question
467(1)
Self Test Answers
468(1)
Lab Answer
468(1)
SQL Server Performance Monitoring and Tuning
469(36)
Some Introductory Thoughts
470(2)
Windows Server Performance Tools
472(1)
Using the Task Manager
472(3)
Configure System Monitor
475(9)
Adding the System Monitor as a Snap-In
475(1)
Exercise 12-1: Correlating Performance Logs with SQL Profile Traces
475(1)
Using the Performance Console
476(1)
Monitoring Live Counters
476(2)
Creating a Counter Log
478(3)
Creating a Trace Log
481(1)
Configuring Alerts
481(1)
SQL Server Performance Tools
482(2)
Gather Performance and Optimization Data by Using SQL Profiler
484(7)
Create and Save a New Trace
484(2)
Exercise 12-2: Creating and Saving a SQL Profiler Trace
486(1)
Modify Trace Properties
487(1)
Correlate Trace Data with Performance Logs
488(1)
Exercise 12-3: Correlating Performance Logs with SQL Profile Traces
488(3)
Gather Performance and Optimization Data by Using the Database Engine Tuning Advisor
491(5)
Building a Workload File with Profiler
492(1)
Running the Advisor
492(3)
Saving the Recommended Indexes
495(1)
Gather Performance and Optimization Data by Using DMVs
496(4)
Two-Minute Drill
498(2)
Q&A Self Test
500(5)
Lab Question
502(1)
Self Test Answers
503(1)
Lab Answer
504(1)
Troubleshooting Server and Database Errors
505(30)
REACT: A Troubleshooting Methodology
506(3)
Monitor and Resolve Blocks and Deadlocks
509(7)
Understanding Concurrency
509(1)
SQL Server Locks
509(2)
Blocks and Deadlocks
511(3)
Exercise 13-1: Forcing a Deadlock Situation
514(2)
Resolving Deadlocks
516(1)
Diagnose and Resolve Database Server Errors
516(8)
Using the Dedicated Administrator Connection
516(3)
Reading the SQL Server Error Logs
519(1)
Using the Event Viewer
520(4)
Monitor SQL Server Agent Job History
524(6)
Finding and Resolving Job Errors
524(5)
Two-Minute Drill
529(1)
Q&A Self Test
530(5)
Lab Question
532(1)
Self Test Answers
533(1)
Lab Answer
534(1)
A. About the CD
535(4)
System Requirements
536(1)
LearnKey Online Training
536(1)
Installing and Running MasterExam and MasterSim
536(1)
MasterExam
537(1)
MasterSim
537(1)
Electronic Book
537(1)
CertCam
537(1)
Help
538(1)
Removing Installation(s)
538(1)
Technical Support
538(1)
LearnKey Technical Support
538(1)
B. Tables
539(14)
New Features
540(1)
System Requirements
541(1)
Supported Operating Systems
541(1)
Authentication Modes
541(1)
Data Types
542(2)
Full-Text, Clustered, and Non-Clustered Indexes
544(1)
Fixed Server and Database Roles
545(1)
Securables and Scope Levels
546(1)
Object Permissions
547(1)
Constraints
548(1)
Backup and Restore
549(1)
High Availability
549(1)
Performance Optimization and Troubleshooting
550(3)
C. SQL Server 2005 Implementation Case Studies
553(14)
Case Study #1: School Student Tracking Database
554(5)
Case Study #2: Online Store
559(3)
Case Study #3: Existing SQL Server 2005 System
562(5)
Glossary 567(14)
Index 581
Tom Carpenter is a technical experts expert. He teaches in-depth courses on Microsoft technologies, wireless networking and security, and professional development skills such as project management, team leadership and communication skills for technology professionals. Tom holds a CWNA, CSWP and Wireless# certification with the CWNP program and is also a Microsoft Certified Partner. He is married to his lovely wife, Tracy, and lives with her and their four children, Faith, Rachel, Thomas and Sarah in Ohio.