25 Books to Read Before You Die
 
 

Recently Viewed clear list


Original Essays | August 20, 2014

Julie Schumacher: IMG Dear Professor Fitger



Saint Paul, August 2014 Dear Professor Fitger, I've been asked to say a few words about you for Powells.com. Having dreamed you up with a ball-point... Continue »
  1. $16.07 Sale Hardcover add to wish list

    Dear Committee Members

    Julie Schumacher 9780385538138

spacer
Qualifying orders ship free.
$14.95
List price: $49.99
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Hawthorne Database- SQL

Microsoft SQL Server 2008 Step by Step with CDROM (Step by Step)

by

Microsoft SQL Server 2008 Step by Step with CDROM (Step by Step) Cover

ISBN13: 9780735626041
ISBN10: 0735626049
Condition: Standard
All Product Details

Only 1 left in stock at $14.95!

 

Synopses & Reviews

Publisher Comments:

Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems.

Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply tuning plus optimization techniques to generate high-performing database applications Optimize availability through clustering, database mirroring, and log shipping Tap business intelligence tools—Reporting, Analysis, and Integration Services

CD features: Practice exercises and code samples Fully searchable eBook

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

Book News Annotation:

This book/CD-ROM package offers a step-by-step tutorial of the SQL Server 2008 data platform and the set of features available within Microsoft SQL Server. The book begins with relational databases, continues with management capabilities, and ends with a set of powerful analysis platforms which comprise the core of the Microsoft business intelligence platform. It covers installation and configuration of each component, and walks through each of the client tools that ship with SQL Server, explaining how each tool works to develop and manage a database environment. The book's final section covers the three business intelligence technologies: SQL Server integration, reporting, and analysis services. Bonus articles are provided on a companion web site. The accompanying CD-ROM contains AdventureWorks sample databases, code samples, and practice files for exercises. The book is intended for IT professionals who are either new to SQL Server or new to SQL Server 2008. Hotek is an SQL Server consultant. Annotation ©2009 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems.

Discover how to:

  • Install and work with core components and tools
  • Create tables and index structures
  • Manipulate and retrieve data
  • Secure, manage, back up, and recover databases
  • Apply tuning plus optimization techniques to generate high-performing database applications
  • Optimize availability through clustering, database mirroring, and log shipping
  • Tap business intelligence tools—Reporting, Analysis, and Integration Services


CD features:

  • Practice exercises and code samples
  • Fully searchable eBook


For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

About the Author

Mike Hotek is a SQL Server expert with three decades' experience as a consultant and solution developer. He has written several books, including Microsoft SQL Server 2008 Step by Step.

Table of Contents

AcknowledgmentsIntroductionPart I: Getting Started with Microsoft SQL Server 2008
  • Chapter 1: Overview of Microsoft SQL Server
  • Chapter 2: Installing and Configuring SQL Server 2008
  • Chapter 3: Using the Tools in SQL Server 2008
Part II: Designing Databases
  • Chapter 4: Creating Databases
  • Chapter 5: Designing Tables
  • Chapter 6: Indexes
  • Chapter 7: Partitioning
Part III: Retrieving and Manipulating Data
  • Chapter 8: Data Retrieval
  • Chapter 9: Advanced Data Retrieval
  • Chapter 10: Data Manipulation
Part IV: Designing Advanced Database Objects
  • Chapter 11: Views
  • Chapter 12: Stored Procedures
  • Chapter 13: Functions
  • Chapter 14: Triggers
  • Chapter 15: Database Snapshots
  • Chapter 16: Service Broker
  • Chapter 17: Full-Text Indexing
Part V: Database Management
  • Chapter 18: Security
  • Chapter 19: Policy-Based Management
  • Chapter 20: Data Recovery
  • Chapter 21: SQL Server Agent
  • Chapter 22: Dynamic Management Views
Part VI: High Availability Overview
  • Chapter 23: High Availability
Part VII: Business Intelligence
  • Chapter 24: SQL Server Integration Services
  • Chapter 25: SQL Server Reporting Services
  • Chapter 26: SQL Server Analysis Services
About the AuthorAdditional Resources for Developers from Microsoft PressMore Great Developer Resources

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

yasser88, November 22, 2008 (view all comments by yasser88)
SQL Server 2008 is the future
Was this comment helpful? | Yes | No

Product Details

ISBN:
9780735626041
Author:
Hotek, Mike
Publisher:
Microsoft Press
Subject:
General
Subject:
Database Management - General
Subject:
Client-server computing
Subject:
Relational databases
Subject:
Database design
Copyright:
Edition Description:
Trade Paper
Series:
Step by Step Developer
Publication Date:
20081231
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
544
Dimensions:
9 x 7.3 x 1.4 in 2.35 lb

Other books you might like

  1. Murach's SQL Server 2008 for... Used Trade Paper $26.00
  2. Teach Yourself Transact SQL 21 Days... New Trade Paper $40.50
  3. Pro C# 2010 and the .Net 4 Platform,... New Trade Paper $59.99
  4. C# in Depth New Trade Paper $49.99
  5. C# 4.0 in a Nutshell (In a Nutshell) New Trade Paper $49.99

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Microsoft SQL Server 2008 Step by Step with CDROM (Step by Step) Used Trade Paper
0 stars - 0 reviews
$14.95 In Stock
Product details 544 pages Microsoft Press - English 9780735626041 Reviews:
"Synopsis" by , Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems.

Discover how to:

  • Install and work with core components and tools
  • Create tables and index structures
  • Manipulate and retrieve data
  • Secure, manage, back up, and recover databases
  • Apply tuning plus optimization techniques to generate high-performing database applications
  • Optimize availability through clustering, database mirroring, and log shipping
  • Tap business intelligence tools—Reporting, Analysis, and Integration Services


CD features:

  • Practice exercises and code samples
  • Fully searchable eBook


For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.