Microsoft SQL Server 2008 step by step
by
Hotek, Mike.
Title
:
Microsoft SQL Server 2008 step by step
Author
:
Hotek, Mike.
ISBN
:
9780735626041
Personal Author
:
Hotek, Mike.
Publication Information
:
Redmond, Wash. : Microsoft, [2008], ©2009.
Physical Description
:
xxv, 505 pages : illustrations ; 23 cm + 1 CD-ROM (4 3/4 in.)
General Note
:
Includes index.
Contents
:
Overview of Microsoft SQL Server -- Installing and configuring SQL Server 2008 -- Using the tools in SQL Server 2008 -- Creating databases -- Designing tables -- Indexes -- Partitioning -- Data retrieval -- Advanced data retrieval -- Data manipulation -- Views -- Stored procedures -- Functions -- Triggers -- Database snapshots -- Service broker -- Full-text indexing -- Security -- Policy-based management -- Data recovery -- SQL server agent -- Dynamic management views -- High availability -- SQL server integration services -- SQL server reporting services -- SQL server analysis services.
Abstract
:
"Teach yourself how to design and create SQL Server 2008 databases - one step at a time. Work at your own pace through the book's practical, skill-building lessons and the hands-on practice files on CD. You'll begin by learning to install and configure SQL Server 2008, design a model database, and work with tables and indexes. Next, you'll learn techniques to manipulate, maintain, and retrieve data. Finally, you'll learn more-advanced techniques, such as using views, functions, and triggers. As you complete each lesson, you can hone your skills using the practice exercises on the companion CD. Plus, you can review and download code samples illustrating the author's own, professional techniques - direct from the companion Web site"--Publisher's description.
Title Subject
:
SQL server.
Subject Term
:
Client/server computing.
Relational databases.