Muutke küpsiste eelistusi

MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) [Raamat]

3.20/5 (10 hinnangut Goodreads-ist)
  • Formaat: Book, 944 pages, kõrgus x laius x paksus: 239x193x56 mm, kaal: 1697 g, 256 Illustrations
  • Sari: All-in-One
  • Ilmumisaeg: 16-Apr-2008
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071546693
  • ISBN-13: 9780071546690
Teised raamatud teemal:
MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442)Suurem pilt
  • Formaat: Book, 944 pages, kõrgus x laius x paksus: 239x193x56 mm, kaal: 1697 g, 256 Illustrations
  • Sari: All-in-One
  • Ilmumisaeg: 16-Apr-2008
  • Kirjastus: Osborne/McGraw-Hill
  • ISBN-10: 0071546693
  • ISBN-13: 9780071546690
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780071546690.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 Need

Get complete coverage of all three Microsoft Certified IT Professional database developer 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

Manage database design

Use Transact-SQL and XML

Work with functions, triggers, and CLR integration

Optimize, monitor, and secure databases

Create stored procedures

Handle disaster recovery

Work with Service Broker, Web Services, and MARS

Use SQL Server Reporting Services and Notification Services

Manage locks, deadlocks, and cursors

Transfer data using Replication and SQL Server Integration Services



The CD-ROM features:





Six full practice exams-two for each exam: 70-431, 70-441, & 70-442 Scripts from the step-by-step exercises in the book Video training clips from the author Complete electronic book
Acknowledgments xiii
Introduction xv
Installing and Configuring SQL Server 2005
1(46)
SQL Server Editions
2(4)
Operating Systems and Supported Benefits
3(1)
Instances
4(2)
Installing SQL Server 2005
6(10)
Prerequisites
6(1)
Downloading
7(9)
Upgrading
16(1)
Configuring SQL Server 2005
16(11)
Service Accounts
17(2)
Services
19(3)
The SQL Server Surface Area Configuration Tool
22(3)
SQL Server Configuration Manager
25(2)
Collations
27(1)
Connecting to SQL Server 2005
27(5)
SQL Server Management Studio (SSMS)
27(1)
SQLCmd
28(1)
Dedicated Administrator Connection (DAC)
29(3)
Examining the Installation
32(3)
System Databases
35(1)
Troubleshooting the Installation or Operation
35(4)
Operating System Logs
36(1)
SQL Logs
37(2)
Books Online
39(8)
Additional Study
41(1)
Summary of What You Need to Know
42(1)
Questions
42(2)
Answers
44(3)
SQL Server 2005 Database Basics
47(44)
Tables
47(19)
Data Types
48(3)
New Large Value Data Types
51(1)
User-Defined Data Types
52(3)
Creating Tables
55(4)
Nulls and Defaults
59(3)
Computed Columns
62(4)
Views
66(6)
Creating Views
66(4)
Updating Data in a View
70(1)
View Options
70(2)
Creating a Database
72(7)
Locating the Files
72(2)
Database Options
74(5)
Schemas and Naming Conventions
79(12)
Four-Part Naming
79(2)
Naming Conventions
81(1)
Additional Study
82(1)
Summary of What You Need to Know
83(1)
Questions
83(4)
Answers
87(4)
Database Design
91(50)
Data Integrity
91(14)
Primary Keys
93(1)
Foreign Keys
94(7)
Table Relationships
101(3)
Exploring Relationships in AdventureWorks
104(1)
Normalization and Normal Forms
105(6)
1st Normal Form (1NF)
106(1)
2nd Normal Form (2NF)
107(1)
3rd Normal Form (3NF)
108(1)
Denormalization
109(1)
Generalization
110(1)
Check Constraints
111(6)
Unique
116(1)
Partitioning Tables
117(8)
Horizontal Partitioning
117(2)
Federations of Servers and Federated Databases
119(1)
Partition Schemes
119(6)
Database Design Exercise
125(16)
The Scenario
125(1)
The Solution
125(8)
Additional Study
133(1)
Summary of What You Need to Know
133(1)
Questions
134(4)
Answers
138(3)
Transact-SQL
141(64)
General Rules to Know
141(5)
The ANSI Standard
142(1)
Delimiting Identifiers
142(1)
Case Sensitive and Case Insensitive
143(3)
Select
146(28)
The Column List
146(2)
Where
148(8)
Order By
156(2)
Group by and Having
158(4)
Joins
162(12)
Other DML Statements
174(7)
Update
174(1)
Insert
175(2)
Delete
177(4)
Advanced Query Techniques
181(24)
Common Table Expressions (CTEs)
181(4)
Except and Intersect
185(1)
Pivot and Unpivot
186(2)
Ranking
188(4)
Additional Study
192(1)
Summary of What You Need to Know
193(1)
Questions
194(8)
Answers
202(3)
XML
205(38)
XML Overview
205(4)
XML Data
207(1)
Well-formed XML
208(1)
Storing XML Data
209(6)
The XML Data Type
210(1)
Typed vs. Untyped XML
210(1)
XML Schema Collection
211(4)
Retrieving XML Data
215(28)
FOR XML
215(5)
XML Methods
220(4)
XQuery
224(3)
Using OPENXML to Shred XML Data
227(1)
XMLReader and XMLWriter
228(1)
XML Indexes
228(6)
Additional Study
234(1)
Summary of What You Need to Know
235(1)
Questions
235(5)
Answers
240(3)
Advanced Database Objects
243(60)
Functions
243(15)
An Overview of the Functions
244(1)
Built-in Functions
244(10)
User-Defined Functions
254(4)
Triggers
258(29)
An Overview of Triggers
258(1)
DML Triggers
259(12)
Instead Of
271(6)
DDL Triggers
277(7)
Disabling Triggers
284(2)
Recursive and Nested Triggers
286(1)
Common Language Runtime (CLR) Integration
287(16)
Execution Context
288(5)
Additional Study
293(1)
Summary of What You Need to Know
294(1)
Questions
294(6)
Answers
300(3)
Optimizing Databases
303(58)
Indexes
303(5)
Clustered
305(1)
Nonclustered
306(2)
Full-Text Indexes
308(1)
XML Indexes
308(1)
Index Design
308(15)
When and Why to Create an Index
308(7)
Analyzing Queries
315(1)
The Leaf and Nonleaf Levels
316(1)
Fill Factors
316(3)
Calculating Size
319(1)
tempdb
320(2)
Creating an Indexed View
322(1)
Statistics
323(10)
Statistics in SQL Server
323(4)
Viewing and Updating Statistics
327(6)
Full-Text Indexes
333(2)
Full-Text Catalogs and Full-Text Indexes
333(2)
Database Engine Tuning Advisor (DTA)
335(5)
Setup and Configuration
336(4)
Index Maintenance
340(6)
Dynamic Management Views and Functions
340(1)
Fragmentation
341(3)
System Monitor Counters
344(1)
DBCC
344(2)
Filegroups
346(15)
Filegroup Possibilities
346(4)
Additional Study
350(1)
Summary of What You Need to Know
351(1)
Questions
351(6)
Answers
357(4)
Security
361(64)
Server Security Basics
362(15)
Authentication Modes
362(2)
The sa Account
364(1)
Creating Logins
365(6)
Server Roles
371(2)
Groups
373(4)
Security Principals
377(20)
Database Users
384(2)
Database Roles
386(5)
Application Roles
391(1)
Schemas
392(5)
Database Securables
397(11)
Permissions
397(6)
Ownership Chaining
403(5)
Designing the Security Strategy
408(1)
Services
408(1)
Auditing
409(1)
Encryption
409(16)
Keys and Algorithms
410(2)
Encrypting Data
412(6)
Additional Study
418(1)
Summary of What You Need to Know
419(1)
Questions
419(4)
Answers
423(2)
Stored Procedures
425(74)
An Overview of Stored Procedures
425(6)
Used for Optimization
426(1)
Security
427(1)
Adds Modularity
428(1)
Limitations
428(1)
Types of Stored Procedures
428(3)
Transactions
431(21)
An Overview of Transactions
432(1)
Commit Transaction
432(3)
Rollback Transaction
435(10)
Error Catching
445(7)
Distributed Transactions
452(1)
User-Defined Stored Procedures
452(14)
Creating Stored Procedures
453(11)
Recompiling Stored Procedures
464(2)
Security
466(12)
Permissions and Access
466(7)
SQL Injection Attacks
473(5)
CLR-Integrated Stored Procedures
478(21)
Additional Study
484(1)
Summary of What You Need to Know
484(1)
Questions
485(9)
Answers
494(5)
Disaster Recovery
499(74)
A Disaster Recovery Overview
499(1)
The Transaction Log
500(6)
Checkpoints
501(4)
Restoring from the Transaction Log
505(1)
Recovery Models
506(4)
The Full Recovery Model
506(1)
The Bulk-Logged Recovery Model
507(1)
The Simple Recovery Model
507(1)
Recovery Model Summary
508(1)
Setting the Recovery Model
509(1)
Database Backups
510(17)
Backup Types
510(6)
Backup Devices
516(2)
Mirrors and Sets
518(3)
Backup and Restore Commands
521(1)
Before the Backup
522(5)
Restores
527(11)
Restore's First Step
527(1)
Restoring with Norecovery and Recovery
528(1)
Restore Strategies
529(2)
Restoring to a Point in Time (STOPAT)
531(3)
Verifying Backups
534(1)
Restoring Files and Filegroups
535(1)
Minimizing Restores
535(1)
Detach and Attach
536(2)
Protecting System Databases
538(3)
Rebuilding the Master
538(3)
Log Shipping
541(12)
Benefits and Requirements
542(9)
Procedures for Changing Roles
551(2)
Database Snapshots
553(4)
Purpose and Benefits
553(1)
Creating and Using a Database Snapshot
554(1)
Managing Snapshots
555(1)
Recovering Data from a Snapshot
555(2)
Database Mirroring
557(9)
Requirements
557(1)
Benefits
558(1)
The Witness Server
558(3)
Implement Database Mirroring
561(5)
High-Availability Comparisons
566(7)
Additional Study
568(1)
Summary of What You Need to Know
569(1)
Questions
569(2)
Answers
571(2)
DataAccess
573(44)
Service Broker
573(15)
Service Broker Object Types
574(1)
Service Broker Applications
575(7)
Event Notifications
582(1)
Implementing Event Notifications
583(5)
Web Services and HTTP Endpoints
588(7)
HTTP Endpoints
590(5)
Linked Servers
595(9)
Creating a Linked Server
596(2)
Configuring Logins for a Linked Server
598(4)
Openquery
602(1)
Opendatasource and Openrowset
602(2)
Data Access Methods
604(13)
Multiple Active Result Sets (MARS)
604(2)
DataSets and DataReaders
606(2)
Additional Study
608(1)
Summary of What You Need to Know
609(1)
Questions
609(5)
Answers
614(3)
Support Services
617(48)
SQL Server Reporting Services (SSRS)
617(28)
Reporting Services Databases
618(1)
Requirements
619(3)
Report Models
622(3)
Report Manager
625(10)
Creating and Modifying Reports in BIDS
635(9)
Report Formats
644(1)
SSRS Server Placement
645(1)
Notification Services
645(12)
Notification Application
647(10)
Notification Services vs. SQL Server Agent
657(1)
Analysis Services
657(8)
Additional Study
659(1)
Summary of What You Need to Know
659(1)
Questions
660(2)
Answers
662(3)
Maintenance Tools
665(74)
System Monitor
665(15)
Measuring Counters in System Monitor
666(14)
SQL Server Agent
680(24)
SQL Server Agent Service
680(7)
SQL Server Agent Properties
687(1)
Creating Operators, Alerts, and Jobs
687(14)
SQL Server Agent Mail
701(3)
Maintenance Plans
704(7)
SQL Server Profiler
711(11)
Templates
711(7)
SQL Trace
718(4)
Dynamic Management Views and Functions
722(17)
Dashboard Reports
727(3)
Additional Study
730(1)
Summary of What You Need to Know
730(1)
Questions
731(4)
Answers
735(4)
Locks and Cursors
739(44)
Locks and Deadlocks
740(19)
What Are Locks?
740(2)
What Are Deadlocks?
742(1)
Preventing Locks and Deadlocks
743(1)
Troubleshooting Locks and Deadlocks
743(11)
Profiler and System Monitor
754(5)
Transaction Isolation Levels
759(4)
Concurrency Effects
760(1)
Picking a Transaction Isolation Level
760(3)
Hints
763(5)
Table Hints
764(1)
Query Plan Guides
765(3)
Cursors
768(15)
Building a Cursor
770(1)
Cursor Performance
770(4)
Additional Study
774(1)
Summary of What You Need to Know
775(1)
Questions
775(5)
Answers
780(3)
Transferring Data
783(50)
Replication
783(14)
The Publisher Metaphor
784(2)
Replication Methods
786(8)
Replication Monitor
794(3)
SQL Server Integration Services (SSIS)
797(20)
ETL
798(1)
Requirements
799(1)
Business Intelligence Development Studio (BIDS)
800(1)
Packages
801(10)
Deploying Packages
811(2)
Optimizing an SSIS Solution
813(4)
Bulk Imports and Exports
817(16)
The bcp Utility
818(4)
Blilk Insert Statement
822(1)
Openrowset and Opendatasource
822(3)
The Import/Export Wizard
825(1)
Additional Study
826(1)
Summary of What You Need to Know
827(1)
Questions
827(4)
Answers
831(2)
Appendix A About the CD
833(4)
System Requirements
833(1)
Installing and Running MasterExam
833(1)
About MasterExam
833(1)
Electronic Book
834(1)
CertCam
834(1)
Help
834(1)
Removing Installation(s)
835(1)
Technical Support
835(2)
LearnKey Technical Support
835(2)
Appendix B Exam 70-431: What You Need to Know to Pass
837(6)
Introduction
837(1)
Picking a Date
837(1)
What You Can Expect
838(1)
What's Expected of You
839(4)
Chapters Covering 70-431 Topics
839(4)
Appendix C Inside the Design Exam
843(8)
The Design Exam
843(8)
Design Exam Success Tips
843(3)
Scenario Topics
846(1)
Sample Scenario Questions
846(1)
Sample Scenario: MCITPSuccess Corporation
847(2)
Sample Scenario Answers
849(1)
Final Notes
850(1)
Appendix D Exam 70-441: What You Need to Know to Pass
851(4)
Introduction
851(1)
What You Can Expect
851(1)
What's Expected of You
852(3)
Chapters Covering 70-441 Topics
852(3)
Appendix E Exam 70-442: What You Need to Know to Pass
855(12)
Introduction
855(1)
What You Can Expect
855(1)
What's Expected of You
856(11)
Chapters Covering 70-442 Topics
856(3)
Appendix F SQL Database Design Object Summary
859(8)
Glossary 867(16)
Index 883
Darril Gibson, MCT, MCDBA, MCSD, MCITP, is a professional trainer specializing in Microsoft technologies. He is the author of MCITP SQL Server 2005 Database Administration All-in-One Exam Guide.