×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Microsoft SQL Server 2012 A Beginners Guide 5E / Edition 5
     

Microsoft SQL Server 2012 A Beginners Guide 5E / Edition 5

by Dusan Petkovic
 

See All Formats & Editions

ISBN-10: 0071761608

ISBN-13: 9780071761604

Pub. Date: 03/02/2012

Publisher: McGraw-Hill Professional Publishing

Essential Microsoft SQL Server 2012 Skills Made Easy

Get up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system

Overview

Essential Microsoft SQL Server 2012 Skills Made Easy

Get up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial.

  • Install, configure, and customize SQL Server 2012
  • Create and modify database objects with Transact SQL statements
  • Write stored procedures and user-defined functions
  • Handle backup and recovery
  • Automate administrative tasks
  • Tune your database system for optimal performance, availability, and reliability
  • Implement security measures using authentication, encryption, and authorization
  • Work with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence tools
  • Store, display, and query XML documents
  • Manage spatial data
  • Query documents using MS Full-Text Search (FTS)

Product Details

ISBN-13:
9780071761604
Publisher:
McGraw-Hill Professional Publishing
Publication date:
03/02/2012
Pages:
832
Sales rank:
734,016
Product dimensions:
7.30(w) x 9.10(h) x 1.70(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 the Database Engine

Chapter 13. Concurrency Control

Chapter 14. Triggers

Part III: SQL Server: System Administration

Chapter 15. System Environment of the Database Engine

Chapter 16. Backup, Recovery, and System Availability

Chapter 17. Automating System Administration Tasks

Chapter 18. Data Replication

Chapter 19. Query Optimizer

Chapter 20. Performance Tuning

Part IV: SQL Server and Business Intelligence

Chapter 21. Business Intelligence: An Introduction

Chapter 22. SQL Server Analysis Services

Chapter 23. Business Intelligence and Transact-SQL

Chapter 24. SQL Server Reporting Services

Chapter 25. Optimizing Techniques for Relational Online Analytical Processing

Part V: Beyond Relational Data

Chapter 26. SQL Server and XML

Chapter 27. Spatial Data

Chapter 28. SQL Server Full-Text Search

Index

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews