Acknowledgments | p. xix |
Introduction | p. xxi |
SQL Server: Basic Concepts | |
Database Systems and SQL Server | p. 3 |
Database Systems: An Overview | p. 6 |
Relational Database Systems | p. 9 |
SQL: A Relational Database Language | p. 12 |
Database Design | p. 14 |
Conclusion | p. 20 |
Overview of Microsoft SQL Server | p. 20 |
Exercises | p. 21 |
SQL Server Management Studio | p. 23 |
The SQL Server Program Group and Books Online | p. 24 |
Introduction to SQL Server Management Studio | p. 25 |
Conclusion | p. 44 |
Exercises | p. 44 |
Transact-SQL Language | |
SQL Components | p. 49 |
SQL's Ba...sic Objects | p. 50 |
Data Types | p. 53 |
Predicates | p. 59 |
Aggregate Functions | p. 60 |
Scalar Functions | p. 60 |
Scalar Operators | p. 67 |
Null Values | p. 69 |
Conclusion | p. 70 |
Exercises | p. 71 |
Data Definition Language | p. 73 |
Creating Database Objects | p. 74 |
Modifying Database Objects | p. 98 |
Removing Database Objects | p. 105 |
Conclusion | p. 106 |
Exercises | p. 106 |
Simple Queries | p. 111 |
Select Statement: A Basic Form | p. 112 |
Where Clause | p. 114 |
Simple Subqueries | p. 131 |
Group by Clause | p. 139 |
Aggregate Functions | p. 141 |
Having Clause | p. 149 |
Order by Clause | p. 150 |
Select Statement and Identity Property | p. 152 |
Set Operators | p. 154 |
Case Expressions | p. 159 |
Compute Clause | p. 161 |
Temporary Tables | p. 164 |
Computed Columns | p. 165 |
Conclusion | p. 166 |
Exercises | p. 166 |
Complex Queries | p. 169 |
Join Operator | p. 170 |
Correlated Subqueries | p. 187 |
Should You Use Join or Subqueries? | p. 193 |
Common Table Expressions | p. 195 |
Conclusion | p. 202 |
Exercises | p. 203 |
Modification of a Table's Contents | p. 205 |
Insert Statement | p. 206 |
Update Statement | p. 210 |
Delete Statement | p. 213 |
Conclusion | p. 215 |
Exercises | p. 216 |
Stored Procedures and User-Defined Functions | p. 217 |
SQL Extensions | p. 218 |
Stored Procedures | p. 225 |
User-Defined Functions | p. 237 |
Conclusion | p. 243 |
Exercises | p. 243 |
Indices and Query Optimization | p. 245 |
Indices | p. 246 |
General Criteria to Improve Efficiency | p. 260 |
Query Optimizer | p. 265 |
The DBCC Command and Indices | p. 278 |
Conclusion | p. 280 |
Exercises | p. 280 |
Views | p. 283 |
DDL Statements and Views | p. 284 |
DML Statements and Views | p. 291 |
Indexed Views | p. 298 |
Conclusion | p. 305 |
Exercises | p. 305 |
System Catalog | p. 307 |
System Tables | p. 308 |
Catalog Views | p. 311 |
Querying Catalog Views | p. 313 |
Other Ways to Access System Information | p. 315 |
Conclusion | p. 323 |
Exercises | p. 324 |
SQL Server Security | p. 325 |
Authentication | p. 326 |
Schema | p. 332 |
Database Security | p. 336 |
Roles | p. 340 |
Authorization | p. 351 |
Views and Data Access | p. 359 |
Stored Procedures and Data Access | p. 360 |
Conclusion | p. 361 |
Exercises | p. 362 |
Triggers | p. 365 |
Introduction | p. 366 |
How Triggers Work | p. 366 |
Triggers and CLR | p. 376 |
The OUTPUT Clause | p. 381 |
Modifying Trigger's Structure | p. 383 |
Conclusion | p. 383 |
Exercises | p. 384 |
Transactions | p. 385 |
Introduction | p. 386 |
Transact-SQL Statements and Transactions | p. 387 |
Locking | p. 391 |
Isolation Levels | p. 397 |
Deadlock | p. 401 |
Conclusion | p. 402 |
Exercises | p. 402 |
SQL Server System Environment | p. 405 |
Disk Storage | p. 406 |
System Databases | p. 410 |
Utilities | p. 411 |
Instances of SQL Server | p. 416 |
Unicode | p. 418 |
SQL Server Architecture | p. 419 |
Conclusion | p. 423 |
Exercises | p. 423 |
SQL Server: System Administration | |
Overview of System Administration | p. 427 |
Administration Tools | p. 428 |
System Administrator | p. 431 |
Conclusion | p. 432 |
Planning the Installation and Installing SQL Server | p. 433 |
Planning the Installation | p. 434 |
Installing SQL Server | p. 437 |
Configuring SQL Server After Installation | p. 445 |
Starting and Stopping an Instance of SQL Server | p. 446 |
Conclusion | p. 448 |
Managing Databases and Database Files | p. 449 |
Managing Filegroups | p. 450 |
Managing Databases | p. 452 |
Managing Transaction Logs | p. 458 |
Conclusion | p. 459 |
Exercises | p. 459 |
Managing Security | p. 461 |
Introduction | p. 462 |
Database Security Permissions | p. 465 |
Managing Permissions | p. 468 |
Conclusion | p. 471 |
Exercises | p. 471 |
Backup and Recovery | p. 473 |
Introduction | p. 474 |
Backup | p. 475 |
Performing Backup | p. 478 |
Recovery | p. 491 |
Conclusion | p. 504 |
Exercises | p. 504 |
Automating System Administration Tasks | p. 507 |
Introduction | p. 508 |
SQL Server Agent | p. 509 |
Creating Jobs and Operators | p. 510 |
Alerts | p. 517 |
Conclusion | p. 524 |
Exercises | p. 525 |
Performance and Tuning | p. 527 |
Introduction | p. 528 |
Factors that Affect Performance | p. 529 |
Monitoring Tools | p. 538 |
Choose the Right Tool | p. 548 |
Data Partitioning | p. 557 |
Introduction | p. 558 |
Steps for Creating Partitioned Tables | p. 559 |
Guidelines for Partitioning Tables and Indices | p. 566 |
Conclusion | p. 566 |
Data Replication | p. 569 |
Distributed Data | p. 570 |
SQL Server Replication-An Overview | p. 572 |
Managing Replication | p. 580 |
Conclusion | p. 584 |
Exercises | p. 585 |
Microsoft Analysis Services | |
Data Warehousing: An Introduction | p. 589 |
Online Transaction Processing vs. Data Warehousing | p. 590 |
Data Warehouses and Data Marts | p. 592 |
Data Warehouse Design | p. 595 |
Cubes and Storage Modes | p. 598 |
Aggregation | p. 600 |
Data Access | p. 602 |
Conclusion | p. 603 |
Exercises | p. 603 |
Microsoft Analysis Services | p. 605 |
BI Development Studio | p. 607 |
Analysis Services and Cubes | p. 612 |
Conclusion | p. 619 |
Business Intelligence and SQL | p. 621 |
OLAP Extensions in Transact-SQL | p. 622 |
Conclusion | p. 637 |
Microsoft Reporting Services | p. 639 |
Introduction | p. 640 |
Creating Reports | p. 642 |
Processing and Managing Reports | p. 652 |
Accessing and Delivering Reports | p. 653 |
Conclusion | p. 656 |
Exercises | p. 656 |
XML Support | |
Overview of XML | p. 659 |
World Wide Web | p. 660 |
XML and Related Languages | p. 661 |
Document Type Definitions | p. 665 |
Conclusion | p. 668 |
SQL Server 2005 and XML | p. 669 |
Storing XML in Relational Databases | p. 670 |
The XML Data Type | p. 671 |
Constructing XML Documents Using the For XML Clause | p. 678 |
XML Query Languages | p. 685 |
Conclusion | p. 686 |
Index | p. 687 |
Table of Contents provided by Ingram. All Rights Reserved. |