MICROSOFT SQL SERVER 2008 A BEGINNER'S GUIDE 4/E / Edition 4 by Dusan Petkovic | 9780071546386 | Paperback | Barnes & Noble
MICROSOFT SQL SERVER 2008 A BEGINNER'S GUIDE 4/E / Edition 4

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

by Dusan Petkovic
     
 

ISBN-10: 0071546383

ISBN-13: 9780071546386

Pub. Date: 07/09/2008

Publisher: McGraw-Hill Professional Publishing

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

Overview

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.

  • 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)

Product Details

ISBN-13:
9780071546386
Publisher:
McGraw-Hill Professional Publishing
Publication date:
07/09/2008
Pages:
709
Product dimensions:
7.20(w) x 9.00(h) x 1.60(d)

Related Subjects

Table of Contents

Part I: Basic Concepts and Installation

Chapter 1. Relational Database Systems--An Introduction

Chapter 2. Planning the Installation and Installing SQL Server

Chapter 3. SQL Server Management Studio

Part II: Transact-SQL Language

Chapter 4. SQL Components

Chapter 5. Data Definition Language

Chapter 6. Queries

Chapter 7. Modification of a Table's Contents

Chapter 8. Stored Procedures and User-Defined Functions

Chapter 9. System Catalog

Chapter 10. Indices

Chapter 11. Views

Chapter 12. Security System of Database Engine

Chapter 13. Concurrency Control

Chapter 14. Triggers

Part III: SQL Server: System Administration

Chapter 15. System Environment of Database Engine

Chapter 16. Managing Instances and Maintaining Databases

Chapter 17. Backup and Recovery

Chapter 18. Automating System Administration Tasks

Chapter 19. Data Replication

Chapter 20. Query Optimizer

Chapter 21. Performance Tuning

Part IV: SQL Server and Business Intelligence

Chapter 22. Business Intelligence--An Introduction

Chapter 23. Microsoft Analysis Services

Chapter 24. Business Intelligence and Transact-SQL

Chapter 25. Microsoft Reporting Services

Chapter 26. Optimizing Techniques for Business Intelligence

Part IV: Beyond Relational Data

Chapter 27. Overview of XML

Chapter 28. SQL Server and XML

Chapter 29. Introduction to Spatial Data

Index

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >