MICROSOFT SQL SERVER 2008 A BEGINNER'S GUIDE 4/E

Name: MICROSOFT SQL SERVER 2008 A BEGINNER'S GUIDE 4/E
Brand: McGraw-Hill
Price: 65.69 EUR
Availability: OnlineOnly

Dusan Petkovic(Autor*in)

McGraw-Hill (Verlag)

1. Auflage

Erschienen am 9. Juli 2008

720 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-0-07-154639-3 (ISBN)

65,69 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Cover Page
Microsoft® SQL ServerT 2008 A Beginner's Guide
Copyright Page
Contents at a Glance
Contents
Acknowledgments
Introduction
Part I Basic Concepts and Installation
Chapter 1 Relational Database Systems-An Introduction
Database Systems: An Overview
Variety of User Interfaces
Physical Data Independence
Logical Data Independence
Query Optimization
Data Integrity
Concurrency Control
Backup and Recovery
Database Security
Relational Database Systems
Working with the Book's Sample Database
SQL: A Relational Database Language
Database Design
Normal Forms
Entity-Relationship Model
Syntax Conventions
Conclusion
Exercises
Chapter 2 Planning the Installation and Installing SQL Server
Planning the Installation
Purpose of the SQL Server System
Hardware and Network Requirements
SQL Server Editions
Installation Recommendations
Installing SQL Server
Before Starting the Setup Program
Starting the Setup Program and Installing Prerequisites
Installing SQL Server Components
Starting and Stopping an Instance of Database Engine
Dedicated Connection to an Instance of Database Engine
Conclusion
Chapter 3 SQL Server Management Studio
SQL Server Program Group and Books Online
Introduction to SQL Server Management Studio
Connecting to a Server
Registered Servers
Object Explorer
Organizing and Navigating Management Studio's Panes
Using Management Studio with Database Engine
Administering Database Servers
Managing Databases Using Object Explorer
Authoring Activities Using SQL Server Management Studio
Conclusion
Exercises
Part II Transact-SQL Language
Chapter 4 SQL Components
SQL's Basic Objects
Literal Values
Delimiters
Comments
Identifiers
Reserved Keywords
Data Types
Numeric Data Types
Character Data Types
Temporal Data Types
Miscellaneous Data Types
DECIMAL with VARDECIMAL Storage Format
Transact-SQL Functions
Aggregate Functions
Scalar Functions
Scalar Operators
Global Variables
NULL Values
Conclusion
Exercises
Chapter 5 Data Definition Language
Creating Database Objects
Creation of a Database
CREATE TABLE: A Basic Form
CREATE TABLE and Declarative Integrity Constraints
Referential Integrity
Creating Other Database Objects
Integrity Constraints and Domains
Modifying Database Objects
Altering a Database
Altering a Table
Removing Database Objects
Conclusion
Exercises
Chapter 6 Queries
SELECT Statement: A Basic Form and the WHERE Clause
WHERE Clause
Subqueries
Subqueries and Comparison Operators
Subqueries and the IN Operator
Subqueries and ANY and ALL Operators
SELECT Statement: Other Clauses and Functions
GROUP BY Clause
Aggregate Functions
HAVING Clause
ORDER BY Clause
SELECT Statement and IDENTITY Property
Set Operators
CASE Expressions
COMPUTE Clause
Temporary Tables
Join Operator
Two Syntax Forms to Implement Joins
Natural Join
Cartesian Product
Outer Join
Further Forms of Join Operations
Correlated Subqueries
Subqueries and the EXISTS Function
Should You Use Joins or Subqueries?
Table Expressions
Derived Tables
Common Table Expressions
Conclusion
Exercises
Chapter 7 Modification of a Table's Contents
INSERT Statement
Inserting a Single Row
Inserting Multiple Rows
Table Value Constructors and INSERT
UPDATE Statement
DELETE Statement
TRUNCATE TABLE Statement
The OUTPUT Clause
MERGE Statement
Conclusion
Exercises
Chapter 8 Stored Procedures and User-Defined Functions
Procedural Extensions
Block of Statements
IF Statement
WHILE Statement
Local Variables
Miscellaneous Procedural Statements
Handling Events with TRY and CATCH Statements
Stored Procedures
Creation and Execution of Stored Procedures
Stored Procedures and CLR
User-Defined Functions
Creation and Execution of User-Defined Functions
User-Defined Functions and CLR
Conclusion
Exercises
Chapter 9 System Catalog
Introduction to the System Catalog
General Interfaces
Catalog Views
Dynamic Management Views and Functions
Information Schema
Proprietary Interfaces
System Procedures
System Functions
Property Functions
Conclusion
Exercises
Chapter 10 Indices
Introduction
Clustered Indices
Nonclustered Indices
Transact-SQL and Indices
Creating Indices
Obtaining Index Fragmentation Information
Editing Index Information
Altering Indices
Removing and Renaming Indices
Guidelines for Creating and Using Indices
Indices and Conditions in the WHERE Clause
Indices and Join Operator
Covering Index
Indices on Computed Columns
Virtual Computed Columns
Persistent Computed Columns
Conclusion
Exercises
Chapter 11 Views
DDL Statements and Views
Creating a View
Altering and Removing Views
Editing Information Concerning Views
DML Statements and Views
View Retrieval
INSERT Statement and a View
UPDATE Statement and a View
DELETE Statement and a View
Indexed Views
Creating an Indexed View
Modifying the Structure of an Indexed View
Editing Information Concerning Indexed Views
Benefits of Indexed Views
Conclusion
Exercises
Chapter 12 Security System of Database Engine
Authentication
Implementing an Authentication Mode
Encrypting Data
Setting Up System Security Using DDL
Managing Logins Using Management Studio
Schemas
User-Schema Separation
DDL Schema-Related Statements
Database Security
Setting Up Database User Accounts 316 Default Database Schemas
Roles
Fixed Server Roles
Fixed Database Roles
Application Roles
User-Defined Database Roles
Authorization
GRANT Statement
DENY Statement
REVOKE Statement
Managing Permissions Using Management Studio
Tracking Changes
Data Security and Views
Conclusion
Exercises
Chapter 13 Concurrency Control
Concurrency Models
Transactions
Properties of Transactions
Transact-SQL Statements and Transactions
Transaction Log
Locking
Lock Modes
Lock Granularity
Lock Escalation
Affecting Locks
Displaying Lock Information
Deadlock
Isolation Levels
Concurrency Problems
Database Engine and Isolation Levels
Row Versioning
READ COMMITTED SNAPSHOT Isolation Level
SNAPSHOT Isolation Level
Conclusion
Exercises
Chapter 14 Triggers
Introduction
Creating a DML Trigger
Modifying a Trigger's Structure
Using Deleted and Inserted Tables
Application Areas for DML Triggers
AFTER Triggers
INSTEAD OF Triggers
First and Last Triggers
DDL Triggers
Database-Level Triggers
Server-Level Triggers
Triggers and CLR
Conclusion
Exercises
Part III SQL Server: System Administration
Chapter 15 System Environment of Database Engine
System Databases
master Database
model Database
tempdb Database
msdb Database
Disk Storage
Properties of Data Pages
Types of Data Pages
Parallel Processing of Tasks
Utilities and the DBCC Command
bcp Utility
sqlcmd Utility
DBCC Command
Conclusion
Exercises
Chapter 16 Managing Instances and Maintaining Databases
Declarative Management Framework
Key Terms
Using DMF
Maintenance Plan Wizard
Conclusion
Exercises
Chapter 17 Backup and Recovery
Backup Methods
Full Database Backup
Differential Backup
Transaction Log Backup
File or Filegroup Backup
Performing Backup
Backing Up Using Transact-SQL Statements
Backing Up Using Management Studio
Determining Which Databases to Back Up
Performing Database Recovery
Automatic Recovery
Manual Recovery
Recovery Models
High Availability
Using a Standby Server
Using RAID Technology
Failover Clustering
Database Mirroring
Log Shipping
Conclusion
Exercises
Chapter 18 Automating System Administration Tasks
Running and Configuring SQL Server Agent
Creating Jobs and Operators
Creating a Job and Its Steps
Creating a Job Schedule
Notifying Operators about the Job Status
Viewing the Job History Log
Alerts
Error Messages
SQL Server Agent Error Log
Windows Application Log
Defining Alerts to Handle Errors
Conclusion
Exercises
Chapter 19 Data Replication
Distributed Data
Methods for Distributing Data
Choosing a Data Distribution Method
Replication-An Overview
Publishers, Distributors, and Subscribers
Publications and Articles
Replication Types
Replication Models
Managing Replication
Configuring the Distribution and Publication Servers
Setting Up Publications
Configuring Subscription Servers
Conclusion
Exercises
Chapter 20 Query Optimizer
Phases of Query Processing
How Query Optimization Works
Query Analysis
Index Selection
Join Order Selection
Join Processing Techniques
Tools for Editing the Optimizer Strategy
SET Statement
Management Studio and Graphical Execution Plans
Examples of Execution Plans
Dynamic Management Views and Query Optimizer
Optimization Hints
Why to Use Optimization Hints
Types of Optimization Hints
Conclusion
Chapter 21 Performance Tuning
Factors that Affect Performance
Database Applications and Performance
Database Engine and Performance
System Resources and Performance
Monitoring Performance
Performance Monitor: An Overview
Monitoring the CPU
Monitoring Memory
Monitoring the Disk System
Monitoring the Network Interface
Choosing the Right Tool
SQL Server Profiler
Database Engine Tuning Advisor
SQL Server 2008 Performance Tools
Performance Data Collector
Resource Governor
Conclusion
Exercises
Part IV SQL Server and Business Intelligence
Chapter 22 Business Intelligence-An Introduction
Online Transaction Processing vs Business Intelligence
Online Transaction Processing
Business Intelligence Systems
Data Warehouses and Data Marts
Data Warehouse Design Using Dimensional Model
Cubes and Their Architectures
Aggregations
How Much to Aggregate?
Physical Storage of a Cube
Data Access
Conclusion
Exercises
Chapter 23 Microsoft Analysis Services
BI Development Studio
Creating a New Project
Creating a Data Source
Creating a Data Source View
Analysis Services and Cubes
Creating a Cube
Designing Storage Aggregation and Processing the Cube
Browsing a Cube
Conclusion
Chapter 24 Business Intelligence and Transact-SQL
Introduction to SQL/OLAP
Window Construct
Extensions of GROUP BY
CUBE Operator
ROLLUP Operator
GROUPING Function
Grouping SETS Operator
OLAP Query Functions
Ranking Functions
Statistical Aggregate Functions
Nonstandard Analytic Functions
TOP Clause
NTILE Function
PIVOT and UNPIVOT Operators
Conclusion
Exercises
Chapter 25 Microsoft Reporting Services
Introduction to Microsoft Reporting Services
Report Manager
Report Server
Report Catalog
Creating Reports
Creating Reports with the Report Server Project Wizard
Creating Parameterized Reports
Processing and Managing Reports
Accessing and Delivering Reports
On-Demand Reports
Report Subscription
Conclusion
Exercises
Chapter 26 Optimizing Techniques for Business Intelligence
Data Partitioning
Ways to Partition Your Data
Steps for Creating Partitioned Tables
Collocating Tables
SQL Server 2008 and Data Partitioning
Guidelines for Partitioning Tables and Indices
Star Schema Query Optimization
Conclusion
Part V Beyond Relational Data
Chapter 27 Overview of XML
World Wide Web
XML-Related Languages
XML-Basic Concepts
XML Attributes
XML Namespaces
Document Type Definitions
XML Schema
Conclusion
Chapter 28 SQL Server and XML
Methods of Storing XML Documents in Relational Databases
Storing XML Documents in SQL Server
Storing XML Documents Using the XML Data Type
Storing XML Documents Using Decomposition
Retrieving Stored XML Documents and Fragments
Presenting Relational Data as XML Documents
RAW Mode
AUTO Mode
EXPLICIT Mode
PATH Mode
Directives
SQL Server XQuery Methods
SQL Server 2008 and XML Enhancements
Conclusion
Chapter 29 Introduction to Spatial Data
Presenting Spatial Data
Geodetic Spatial Models
Flat Spatial Models
Spatial Data Types
GEOMETRY Data Type
Differences Between the GEOMETRY and GEOGRAPHY Data Types
Conclusion
Index

Systemvoraussetzungen

Als PDF speichern Als Link merken