Contents 9
Acknowledgments 23
Introduction 25
Part I: Basic Concepts and Installation 37
Chapter 1 Relational Database Systems—An Introduction 39
Database Systems: An Overview 40
Relational Database Systems 43
Database Design 47
Syntax Conventions 53
Conclusion 54
Exercises 54
Chapter 2 Planning the Installation and Installing SQL Server 56
Planning the Installation 57
Installing SQL Server 62
Starting and Stopping an Instance of Database Engine 72
Dedicated Connection to an Instance of Database Engine 73
Conclusion 73
Chapter 3 SQL Server Management Studio 74
SQL Server Program Group and Books Online 75
Introduction to SQL Server Management Studio 76
Using Management Studio with Database Engine 81
Conclusion 98
Exercises 98
Part II: Transact-SQL Language 100
Chapter 4 SQL Components 102
SQL's Basic Objects 103
Data Types 106
Transact-SQL Functions 114
Scalar Operators 122
NULL Values 123
Conclusion 124
Exercises 124
Chapter 5 Data Definition Language 126
Creating Database Objects 127
Modifying Database Objects 148
Removing Database Objects 155
Conclusion 156
Exercises 157
Chapter 6 Queries 160
SELECT Statement: A Basic Form and the WHERE Clause 161
Subqueries 177
SELECT Statement: Other Clauses and Functions 182
Temporary Tables 203
Join Operator 204
Correlated Subqueries 218
Table Expressions 221
Conclusion 230
Exercises 230
Chapter 7 Modification of a Table's Contents 234
INSERT Statement 235
UPDATE Statement 240
DELETE Statement 243
The OUTPUT Clause 245
MERGE Statement 246
Conclusion 248
Exercises 248
Chapter 8 Stored Procedures and User-Defined Functions 250
Procedural Extensions 251
Stored Procedures 257
User-Defined Functions 268
Conclusion 277
Exercises 277
Chapter 9 System Catalog 278
Introduction to the System Catalog 279
General Interfaces 281
Proprietary Interfaces 287
Conclusion 290
Exercises 290
Chapter 10 Indices 292
Introduction 293
Transact-SQL and Indices 297
Guidelines for Creating and Using Indices 306
Indices on Computed Columns 308
Conclusion 310
Exercises 311
Chapter 11 Views 314
DDL Statements and Views 315
DML Statements and Views 321
Indexed Views 328
Conclusion 333
Exercises 334
Chapter 12 Security System of Database Engine 336
Authentication 338
Schemas 347
Database Security 350
Roles 353
Authorization 361
Tracking Changes 369
Data Security and Views 373
Conclusion 374
Exercises 375
Chapter 13 Concurrency Control 378
Concurrency Models 379
Transactions 380
Locking 386
Isolation Levels 394
Row Versioning 397
Conclusion 399
Exercises 400
Chapter 14 Triggers 402
Introduction 403
Application Areas for DML Triggers 406
DDL Triggers 413
Triggers and CLR 415
Conclusion 420
Exercises 420
Part III: SQL Server: System Administration 422
Chapter 15 System Environment of Database Engine 424
System Databases 425
Disk Storage 427
Utilities and the DBCC Command 434
Conclusion 439
Exercises 439
Chapter 16 Managing Instances and Maintaining Databases 440
Declarative Management Framework 441
Maintenance Plan Wizard 444
Conclusion 446
Exercises 446
Chapter 17 Backup and Recovery 448
Backup Methods 450
Performing Backup 452
Performing Database Recovery 461
High Availability 473
Conclusion 479
Exercises 480
Chapter 18 Automating System Administration Tasks 482
Running and Configuring SQL Server Agent 484
Creating Jobs and Operators 485
Alerts 492
Conclusion 498
Exercises 499
Chapter 19 Data Replication 500
Distributed Data 501
Replication—An Overview 503
Managing Replication 513
Conclusion 518
Exercises 518
Chapter 20 Query Optimizer 520
Phases of Query Processing 521
How Query Optimization Works 522
Tools for Editing the Optimizer Strategy 529
Optimization Hints 542
Conclusion 550
Chapter 21 Performance Tuning 552
Factors that Affect Performance 553
Monitoring Performance 561
Choosing the Right Tool 568
SQL Server 2008 Performance Tools 577
Conclusion 580
Exercises 580
Part IV: SQL Server and Business Intelligence 582
Chapter 22 Business Intelligence—An Introduction 584
Online Transaction Processing vs. Business Intelligence 585
Data Warehouses and Data Marts 587
Data Warehouse Design Using Dimensional Model 589
Cubes and Their Architectures 593
Data Access 597
Conclusion 598
Exercises 598
Chapter 23 Microsoft Analysis Services 600
BI Development Studio 601
Analysis Services and Cubes 606
Conclusion 612
Chapter 24 Business Intelligence and Transact-SQL 614
Introduction to SQL/OLAP 615
Window Construct 616
Extensions of GROUP BY 622
OLAP Query Functions 628
Nonstandard Analytic Functions 632
Conclusion 638
Exercises 638
Chapter 25 Microsoft Reporting Services 640
Introduction to Microsoft Reporting Services 641
Creating Reports 643
Processing and Managing Reports 653
Accessing and Delivering Reports 654
Conclusion 656
Exercises 657
Chapter 26 Optimizing Techniques for Business Intelligence 658
Data Partitioning 659
Star Schema Query Optimization 669
Conclusion 671
Part V: Beyond Relational Data 674
Chapter 27 Overview of XML 676
World Wide Web 677
XML-Related Languages 678
XML—Basic Concepts 678
Conclusion 685
Chapter 28 SQL Server and XML 686
Methods of Storing XML Documents in Relational Databases 687
Storing XML Documents in SQL Server 688
Retrieving Stored XML Documents and Fragments 696
Presenting Relational Data as XML Documents 697
SQL Server XQuery Methods 704
SQL Server 2008 and XML Enhancements 706
Conclusion 706
Chapter 29 Introduction to Spatial Data 708
Presenting Spatial Data 709
Spatial Data Types 710
Conclusion 716
Index 718
A 718
B 719
C 720
D 722
E 726
F 727
G 728
H 728
I 728
J 730
K 730
L 730
M 731
N 732
O 733
P 734
Q 735
R 736
S 737
T 741
U 743
V 743
W 744
X 744

lgli/D:\!Genesis\!!ForLG\!!!3\(McGraw - HillOsborne) Microsoft SQL Server 2008 a Beginners Guide.pdf

lgrsnf/D:\!Genesis\!!ForLG\!!!3\(McGraw - HillOsborne) Microsoft SQL Server 2008 a Beginners Guide.pdf

zlib/Computers/Programming/Dusan Ptkovc/Microsoft SQL Server 2008 a Beginner's Guide_651049.pdf

Microsoft SQL Server 2008: руководство для начинающих

Душан Петкович; [пер. с англ. А. Бондаря]

Dušan Petković

Petkovic, Dusan

Петкович, Душан

Dušan Petkovic

McGraw-Hill Professional Publishing

McGraw-Hill School Education Group

Irwin Professional Publishing

McGraw Hill LLC

БХВ-Петербург

Oracle Press

McGraw Hill LLC Professional Division, New York, 2008

United States, United States of America

New York, New York State, 2008

Microsoft SQL Server, 4, 2008

Санкт-Петербург, Russia, 2009

Санкт-Петербург, Russia, 2012

4th ed, New York, USA, 2008

torrents.ru tech collections 2009-11-14

lg206113

producers:
Adobe PDF Library 8.0

Includes index.

Указ.
На обл.: Научитесь быстро и легко использовать все возможности SQL Server 2008
Пер.: Petković, Dušan Microsoft SQL Server 2008 New York [etc.]: Mc Graw Hill, 2008 978-0-07-154638-6

РГБ

Russian State Library [rgb] MARC:
=001 004376092
=005 20091229105115.0
=008 090820s2009\\\\ru\\\\\\\\\\\\000\|\rus|d
=017 \\ $a 09-67766
=020 \\ $a 978-5-9775-0149-1
=040 \\ $a RuMoRKP $b rus $e rcr $d RuMoRGB
=041 1\ $a rus $h eng
=080 \\ $a 004.65
=084 \\ $a З973.233-018.2-5-05,0 $2 rubbk
=100 1\ $a Петкович, Душан
=245 00 $a Microsoft SQL Server 2008 : $b руководство для начинающих $c Душан Петкович ; [пер. с англ. А. Бондаря]
=260 \\ $a Санкт-Петербург $b БХВ-Петербург $c 2009
=300 \\ $a 730 с. $b ил., табл. $c 24 см
=500 \\ $a Указ.
=500 \\ $a На обл.: Научитесь быстро и легко использовать все возможности SQL Server 2008
=534 \\ $p Пер.: $a Petković, Dušan $t Microsoft SQL Server 2008 $c New York [etc.]: Mc Graw Hill, 2008 $z 978-0-07-154638-6
=650 \7 $a Вычислительная техника -- Вычислительные машины электронные цифровые -- Автоматическая обработка информации -- Программирование -- Базы данных -- Управление $2 rubbk
=650 \7 $2 nlr_sh $0 RU\NLR\AUTH\661507820 $a MICROSOFT SQL SERVER 2008, система управления базами данных
=852 \\ $a РГБ $b FB $j 3 09-31/215 $x 90

Указ.
Пер.: Petković, Dušan Microsoft SQL Server 2008 New York [etc.]: Mc Graw Hill, 2008 978-0-07-154638-6

Russian State Library [rgb] MARC:
=001 005404456
=005 20120329125115.0
=008 090820s2012\\\\ru\\\\\\\\\\\\000\u\rus|d
=017 \\ $a 12-17151
=020 \\ $a 978-5-9775-0149-1
=040 \\ $a RuMoRGB $b rus $e rcr
=041 1\ $a rus $h eng
=080 \\ $a 004.65
=084 \\ $a З973.233-018.2-5-05,0 $2 rubbk
=100 1\ $a Петкович, Душан
=245 00 $a Microsoft SQL Server 2008 $h [Текст] : $b руководство для начинающих $c Душан Петкович ; [пер. с англ. А. Бондаря]
=260 \\ $a Санкт-Петербург $b БХВ-Петербург $c 2012
=300 \\ $a XXI, 730 с. $b ил., табл. $c 24 см
=500 \\ $a Указ.
=534 \\ $p Пер.: $a Petković, Dušan $t Microsoft SQL Server 2008 $c New York [etc.]: Mc Graw Hill, 2008 $z 978-0-07-154638-6
=650 \7 $a Вычислительная техника -- Вычислительные машины электронные цифровые -- Автоматическая обработка информации -- Программирование -- Базы данных -- Управление $2 rubbk
=650 \7 $2 nlr_sh $0 RU\NLR\AUTH\661507820 $a MICROSOFT SQL SERVER 2008, система управления базами данных
=852 \\ $a РГБ $b FB $j 3 12-10/7 $x 90

<p><p><b>get Started On Microsoft Sql Server 2008 In No Time</b><p>learn To Use All Of The Powerful Features Available In Sql Server 2008 Quickly And Easily. <b>microsoft Sql Server 2008&#58; A Beginner&#39;s Guide</b> Explains The Fundamentals Of Each Topic Alongside Examples And Tutorials That Walk You Through Real-world Database Tasks. Install Sql Server 2008, Construct High-performance Databases, Use Powerful Transact-sql Statements, Create Stored Procedures And Triggers, And Execute Simple And Complex Database Queries. Performance Tuning, Database Engine Security, Business Intelligence, And Xml Are Also Covered. <p><ul><li>set Up, Configure, And Maintain Sql Server 2008</li><li>build And Manage Database Objects Using Transact-sql Statements </li><li>create Stored Procedures And User-defined Functions</li><li>optimize Database Performance, Availability, And Reliability</li><li>implement Solid Security Using Authentication, Encryption, And Authorization </li><li>automate Tasks Using Sql Server Agent</li><li>create Reliable Data Backups And Perform Flawless System Restores</li><li>use All-new Sql Server 2008 Business Intelligence, Development, And Administration Tools</li><li>learn In Detail The Sql Server Xml Technology (sqlxml)</li></ul></p>

Get Started on Microsoft SQL Server 2008 in No TimeLearn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered.Set up, configure, and maintain SQL Server 2008; Build and manage database objects using Transact-SQL statements; Create stored procedures and user-defined functions; Optimize database performance, availability, and reliability; Implement solid security using authentication, encryption, and authorization; Automate tasks using SQL Server Agent; Create reliable data backups and perform flawless system restores; Use all-new SQL Server 2008 Business Intelligence, development, and administration tools; Learn in detail the SQL Server XML technology (SQLXML).

Publisher's 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.
Get Started on Microsoft SQL Server 2008 in No Time Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered.

Showing how to use all of the powerful features available in SQL Server 2008 quickly and easily; this guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. -- Edited summary from book

2010-02-18