Microsoft Sql Server 2008 A Beginner's Guide 4/E

by Petkovic

• ISBN13: 9780071546386
• ISBN10: 0071546383
• Edition: 4th
• Format: Paperback
• Copyright: 2008-07-30
• Publisher: McGraw-Hill Education

Summary

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)

Author Biography

Dusan Petkovic is a computer science professorat the Polytechnic in Rosenheim, Germany. He is the bestselling author of the previous editions of this book and has written numerous articles for SQL Server Magazine.

Table of Contents

Basic Concepts and Installation

Relational Database Systems--An Introduction

Planning the Installation and Installing SQL Server

SQL Server Management Studio

Transact-SQL Language

SQL Components

Data Definition Language

Queries

Modification of a Table's Contents

Stored Procedures and User-Defined Functions

System Catalog

Indices

Views

Security System of Database Engine

Concurrency Control

Triggers

SQL Server: System Administration

System Environment of Database Engine

Managing Instances and Maintaining Databases

Backup and Recovery

Automating System Administration Tasks

Data Replication

Query Optimizer

Performance Tuning

SQL Server and Business Intelligence

Business Intelligence--An Introduction

Microsoft Analysis Services

Business Intelligence and Transact-SQL

Microsoft Reporting Services

Optimizing Techniques for Business Intelligence

Beyond Relational Data

Overview of XML

SQL Server and XML

Introduction to Spatial Data

Index

Table of Contents provided by Publisher. All Rights Reserved.