Muutke küpsiste eelistusi

MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) [Raamat]

3.00/5 (4 hinnangut Goodreads-ist)
  • Formaat: Book, 752 pages, kõrgus x laius x paksus: 229x196x46 mm, kaal: 1497 g, 256 Illustrations
  • Sari: All-in-One
  • Ilmumisaeg: 16-Nov-2007
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071496092
  • ISBN-13: 9780071496094
Teised raamatud teemal:
MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444)Suurem pilt
  • Formaat: Book, 752 pages, kõrgus x laius x paksus: 229x196x46 mm, kaal: 1497 g, 256 Illustrations
  • Sari: All-in-One
  • Ilmumisaeg: 16-Nov-2007
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071496092
  • ISBN-13: 9780071496094
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780071496094.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.











All-in-One is All You NeedGet complete coverage of all three Microsoft Certified IT Professional database administration exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.

Get full details on all exam topics including how to:





Install and configure SQL Server 2005

Use Transact-SQL

Manage server infrastructure design

Optimize databases

Secure databases and servers

Ensure high availability

Implement backup and recovery strategies

Maximize the built-in administration tools

Use Business Intelligence tools, including SSIS and SSRS

Manage concurrency



The CD-ROM features:





Six full practice exams--two for each exam: 70-431, 70-443, and 70-444

Scripts from the step-by-step exercises in the book

Video training clips from the author

Complete electronic book
Acknowledgments xv
Introduction xvii
Installing and Configuring SQL Server 2005
1(42)
SQL Server Editions
2(4)
Operating Systems and Supported Benefits
3(1)
Instances
4(2)
Installing SQL Server 2005
6(7)
Prerequisites
6(1)
Downloading
7(5)
Upgrading
12(1)
Configuring SQL Server 2005
13(9)
Service Accounts
13(1)
Services
14(3)
SQL Server Surface Area Configuration Tool
17(3)
SQL Server Configuration Manager
20(2)
Collations
22(1)
Connecting to SQL Server 2005
22(4)
SQL Server Management Studio (SSMS)
22(2)
SQLCmd
24(1)
Dedicated Administrator Connection (DAC)
24(2)
Examining the Installation
26(4)
System Databases
30(1)
Troubleshooting the Installation or Operation
30(3)
Operating System Logs
30(2)
SQL Logs
32(1)
Books Online
33(10)
Additional Study
36(1)
Summary of What You Need to Know
37(1)
Questions
37(4)
Answers
41(2)
SQL Server 2005 Database Basics
43(36)
Tables
43(12)
Data Types
44(8)
Creating Tables
52(3)
Views
55(5)
Creating Views
55(3)
Updating Data in a View
58(1)
VIEW Options
58(2)
Data Quality
60(1)
Creating a Database
61(2)
Schemas and Naming Conventions
63(3)
Four-Part Naming
64(1)
Naming Conventions
65(1)
Database Control
66(13)
Change Management
66(2)
Documentation
68(4)
Additional Study
72(1)
Summary ofWhat You Need to Know
73(1)
Questions
74(3)
Answers
77(2)
Database Design
79(44)
Data Integrity
79(9)
Primary Key
80(1)
Foreign Key
81(5)
Exploring Relationships in AdventureWorks
86(2)
Normalization and Normal Forms
88(4)
1st Normal Form (INF)
88(1)
2nd Normal Form (2NF)
89(1)
3rd Normal Form (3NF)
90(1)
Denormalization
91(1)
Constraints
92(7)
Overview
92(1)
Default Definitions
92(2)
Check
94(4)
Unique
98(1)
Partitioning Tables
99(7)
Horizontal Partitioning
99(2)
Partition Schemes
101(5)
Database Design Exercise
106(17)
The Scenario
106(1)
The Solution
107(8)
Additional Study
115(1)
Summary of What You Need to Know
115(1)
Questions
116(4)
Answers
120(3)
Transact-SQL Primer
123(58)
General Rules to Know
123(5)
ANSI Standard
124(1)
Delimiting Identifiers
124(1)
Case Sensitive and Case Insensitive
124(4)
Select
128(21)
Columns
128(2)
Where
130(5)
Order By
135(1)
Collate
135(2)
Group By and Having
137(2)
Joins
139(10)
Other DML Statements
149(7)
Update
149(1)
Insert
150(2)
Delete
152(4)
Transactions
156(8)
Overview
156(1)
Commit
157(1)
Rollback
158(3)
Error Catching
161(3)
XML
164(6)
XML Overview
164(1)
FORXML
164(1)
Typed vs. Untyped XML
165(1)
XML Schema Collection
166(2)
Storing XML Data
168(1)
Methods
169(1)
Hints
170(11)
Query Hints
171(1)
Query Plan Guides
172(1)
Additional Study
173(1)
Summary of What You Need to Know
174(1)
Questions
175(4)
Answers
179(2)
Advanced Database Objects
181(50)
Functions
181(7)
Overview of Functions
182(1)
Built-in Functions
182(3)
User-Defined Functions
185(3)
Stored Procedures
188(14)
System Stored Procedures
189(2)
Extended Stored Procedures
191(1)
Creating Stored Procedures
191(7)
SQL Injection Attacks
198(3)
Recompiling
201(1)
Triggers
202(19)
Overview of Triggers
202(1)
DML Triggers
202(9)
Instead Of
211(4)
DDL Triggers
215(4)
Disabling Triggers
219(1)
Recursive and Nested Triggers
220(1)
Common Language Runtime (CLR) Integration
221(10)
Execution Context
222(1)
Additional Study
223(1)
Summary of What You Need to Know
224(1)
Questions
224(4)
Answers
228(3)
Server Infrastructure Design
231(44)
Server Resources
231(11)
Memory
232(2)
CPU
234(1)
Disk
235(7)
NIC
242(1)
System Monitor
242(12)
Measuring Counters in System Monitor
244(10)
Server Design Considerations
254(3)
Remote Administration
255(1)
WSUS
255(1)
Steps to Implement WSUS
256(1)
Linked Servers
257(18)
Creating a Linked Server
258(3)
Configuring Logins for a Linked Server
261(4)
OPENQUERY
265(1)
OPENDATASOURCE and OPENROWSET
265(1)
Additional Study
266(1)
Summary of What You Need to Know
267(1)
Questions
267(4)
Answers
271(4)
Optimizing Databases
275(46)
Indexes
275(3)
Clustered
276(1)
Nonclustered
277(1)
Full-Text Indexes
278(1)
XML Indexes
278(1)
Index Design
278(11)
When and Why to Create an Index
278(5)
Analyzing Queries
283(1)
Leaf and Nonleaf Level
283(1)
Fill Factor
284(2)
Calculating Size
286(1)
tempdb
287(2)
Creating an Indexed View
289(1)
Statistics
289(7)
Statistics in SQL Server
290(4)
Viewing and Updating Statistics
294(2)
Full-Text Index
296(2)
Full-Text Catalogs and Full-Text Indexes
297(1)
Database Engine Tuning Advisor (DTA)
298(5)
Setup and Configuration
299(4)
Index Maintenance
303(5)
Dynamic Management Views and Functions
303(1)
Fragmentation
304(2)
System Monitor Counters
306(1)
DBCC
307(1)
Filegroups
308(13)
Filegroup Possibilities
309(4)
Additional Study
313(1)
Summary of What You Need to Know
313(1)
Questions
314(3)
Answers
317(4)
Database Security
321(44)
Security Principals
321(18)
Database Users
330(2)
Database Roles
332(6)
Application Roles
338(1)
Schemas
338(1)
Database Securables
339(10)
Permissions
339(10)
Encryption
349(16)
Keys and Algorithms
350(1)
Encrypting Data
351(7)
Additional Study
358(1)
Summary of What You Need to Know
358(1)
Questions
359(3)
Answers
362(3)
Server Security
365(50)
Server Security Basics
365(18)
Authentication Modes
365(2)
sa Account
367(1)
Creating Logins
368(9)
Server Roles
377(6)
Working in a Domain
383(18)
Groups
383(5)
SQL Server in a Domain
388(1)
Active Directory and Group Policy
389(12)
Network Security
401(3)
Communicating Securely
402(2)
Security Strategy
404(11)
Services
404(1)
Auditing
405(1)
Cost-Benefit Analysis
405(1)
Physical Security
406(1)
Antivirus Software
407(1)
Additional Study
408(1)
Summary of What You Need to Know
408(1)
Questions
409(4)
Answers
413(2)
High-Availability Strategies
415(58)
Log Shipping
415(14)
Benefits and Requirements
417(11)
Procedures for Changing Roles
428(1)
Database Snapshots
429(4)
Purpose and Benefits
430(1)
Creating and Using a Database Snapshot
430(1)
Managing Snapshots
431(1)
Recovering Data from e Snapshot
432(1)
Database Mirroring
433(10)
Requirements
434(1)
Benefits
434(1)
Witness Server
434(3)
Implement Database Mirroring
437(6)
Replication
443(15)
Publisher Metaphor
443(2)
Replication Methods
445(10)
Replication Monitor
455(3)
Clustering
458(3)
How Many Nodes?
459(2)
Cost vs. Benefits
461(1)
High-Availability Comparisons
461(12)
Additional Study
463(2)
Summary of What You Need to Know
465
Questions
464(5)
Answers
469(4)
Data Recovery Strategies
473(50)
Detach and Attach
473(3)
Transaction Log
476(5)
Checkpoints
477(3)
Restoring from the Transaction Log
480(1)
Recovery Models
481(4)
Full Recovery Model
482(1)
Bulk-Logged Recovery Model
482(1)
Simple Recovery Model
483(1)
Recovery Model Summary
484(1)
Setting the Recovery Model
484(1)
Database Backups
485(6)
Backup Types
486(5)
Backup Devices
491(11)
Backup and Restore Arguments
496(1)
Before the Backup
497(5)
Restores
502(8)
Restore's First Step
502(1)
Restoring with NORECOVERY and RECOVERY
503(1)
Restore Strategies
503(2)
Restoring to a Point in Time (STOPAT)
505(3)
Verifying Backups
508(1)
Restoring Files and Filegroups
509(1)
Minimizing Restores
509(1)
Protecting System Databases and Scripts
510(13)
Rebuilding the Master
510(3)
Protecting Scripts
513(1)
Additional Study
514(1)
Summary of What You Need to Know
515(1)
Questions
516(4)
Answers
520(3)
Data Access
523(40)
Service Broker
523(15)
Service Broker Object Types
524(1)
Service Broker Applications
524(6)
Event Notifications
530(1)
Implementing Event Notifications
531(7)
Web Services and HTTP Endpoints
538(6)
HTTP Endpoints
539(5)
Bulk Imports and Exports
544(19)
The bcp Utility
544(4)
BULK INSERT Statement
548(1)
OPENROWSET and OPENDATASOURCE
548(3)
Import/Export Wizard
551(4)
Additional Study
555(1)
Summary of What You Need to Know
556(1)
Questions
556(4)
Answers
560(3)
Database Administrator Tools
563(50)
SQL Server Agent
563(23)
SQL Server Agent Service
564(6)
SQL Server Agent Properties
570(1)
Creating Operators, Alerts, and Jobs
570(12)
SQL Server Agent Mail
582(4)
Maintenance Plans
586(5)
SQL Server Profiler
591(8)
Templates
592(7)
SQL Trace
599(1)
Dynamic Management Views and Functions
599(14)
Dashboard Reports
603(3)
Additional Study
606(1)
Summary of What You Need to Know
607(1)
Questions
607(4)
Answers
611(2)
Business Intelligence
613(38)
Business Intelligence (BI) Basics
613(2)
OLAP
614(1)
ETL
615(1)
SQL Server Integration Services (SSIS)
615(17)
Requirements
616(1)
Transformations
616(1)
Business Intelligence Development Studio (BIDS)
617(1)
Packages
618(10)
Deploying Packages
628(2)
Monitoring SSIS
630(2)
SQL Server Reporting Services (SSRS)
632(19)
Reporting Services Database
632(1)
Requirements
633(1)
Creating Reports
634(12)
Additional Study
646(1)
Summary of What You Need to Know
647(1)
Questions
647(2)
Answers
649(2)
Managing Concurrency
651(28)
Locks and Deadlocks
651(19)
What Are Locks?
652(2)
What Are Deadlocks?
654(1)
Preventing Locks and Deadlocks
654(1)
Troubleshooting Locks and Deadlocks
655(11)
Profiler and System Monitor
666(4)
Transaction Isolation Levels
670(9)
Concurrency Effects
671(1)
Picking a Transaction Isolation Level
671(3)
Additional Study
674(1)
Summary of What You Need to Know
674(1)
Questions
675(2)
Answers
677(2)
Appendix A About the CD
679(4)
System Requirements
679(1)
LearnKey Online Training
679(1)
Installing and Running MasterExam and MasterSim
680(1)
About MasterExam
680(1)
About MasterSim
680(1)
Electronic Book
680(1)
CertCam
680(1)
Help
681(1)
Removing Installation(s)
681(1)
Technical Support
681(2)
LearnKey Technical Support
681(2)
Appendix B Exam 70-431: What You Need to Know to Pass
683(6)
Introduction
683(1)
Pick a Date
683(1)
What You Can Expect
684(1)
What's Expected of You
685(4)
Chapters Covering 70-431 Topics
685(4)
Appendix C Inside the Design Test
689(10)
The Design Test
689(10)
Design Test Success Tips
689(3)
Scenario Topics
692(1)
Sample Scenario Questions
692(2)
Sample Scenario: MCITPSuccess Corporation
694(2)
Sample Scenario Answers
696(3)
Appendix D Exam 70-443:WhatYou Need to Know to Pass
699(4)
Introduction
699(1)
What You Can Expect
700(1)
What's Expected of You
700(3)
Chapters Covering 70-443 Topics
700(3)
Appendix E Exam 70-444:WhatYou Need to Know to Pass
703(4)
Introduction
703(1)
What You Can Expect
703(1)
What's Expected of You
704(3)
Chapters Covering 70-444 Topics
704(3)
Appendix F SQL Database Design Object Summary
707(8)
Glossary 715(14)
Index 729


Darril Gibson, MCITP, MCDBA, MCSE, is a professional trainer specializing in Microsoft Technologies. He has created several video training courses for Keystone learning.