Microsoft SQL Server 2008 Step by Step

( 6 )

Overview

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...

See more details below
Paperback
$32.02
BN.com price
(Save 35%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (32) from $1.99   
  • New (16) from $14.67   
  • Used (16) from $1.99   
Microsoft SQL Server 2008 Step by Step

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780735626041
  • Publisher: Microsoft Press
  • Publication date: 11/5/2008
  • Pages: 544
  • Sales rank: 684,346
  • Product dimensions: 7.30 (w) x 8.90 (h) x 1.50 (d)

Meet 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.

Read More Show Less

Table of Contents

Acknowledgments; Introduction; Who This Book Is For; How This Book Is Organized; Finding Your Best Starting Point in This Book; Conventions and Features in This Book; System Requirements; Sample Databases; Practice Files; Find Additional Content Online; Support for This Book; Part I: Getting Started with Microsoft SQL Server 2008; Chapter 1: Overview of Microsoft SQL Server; 1.1 Database Engine; 1.2 Business Intelligence; 1.3 Chapter 1 Quick Reference; Chapter 2: Installing and Configuring SQL Server 2008; 2.1 Editions of SQL Server 2008; 2.2 Infrastructure Requirements; 2.3 Service Accounts; 2.4 Collation Sequences; 2.5 Authentication Modes; 2.6 SQL Server Instances; 2.7 Upgrading to SQL Server 2008; 2.8 Installing SQL Server 2008; 2.9 Chapter 2 Quick Reference; Chapter 3: Using the Tools in SQL Server 2008; 3.1 SQL Server Documentation; 3.2 Management Tools in SQL Server 2008; 3.3 Performance Management Tools; 3.4 Business Intelligence Tools; 3.5 Chapter 3 Quick Reference; Part II: Designing Databases; Chapter 4: Creating Databases; 4.1 SQL Server System Databases; 4.2 SQL Server Database Structure; 4.3 Creating a Database; 4.4 Moving Databases; 4.5 Chapter 4 Quick Reference; Chapter 5: Designing Tables; 5.1 Naming Objects; 5.2 Schemas; 5.3 Data Types; 5.4 Column Properties; 5.5 Creating Tables; 5.6 Computed Columns; 5.7 Sparse Columns; 5.8 Constraints; 5.9 Database Diagrams; 5.10 Chapter 5 Quick Reference; Chapter 6: Indexes; 6.1 Index Structure; 6.2 Clustered Indexes; 6.3 Nonclustered Indexes; 6.4 Included Columns; 6.5 Filtered Indexes; 6.6 Online Index Creation; 6.7 Index Management and Maintenance; 6.8 XML Indexes; 6.9 Spatial Indexes; 6.10 Chapter 6 Quick Reference; Chapter 7: Partitioning; 7.1 Partition Functions; 7.2 Partition Schemes; 7.3 Partitioning Tables and Indexes; 7.4 Managing Partitions; 7.5 Chapter 7 Quick Reference; Part III: Retrieving and Manipulating Data; Chapter 8: Data Retrieval; 8.1 General SELECT Statement; 8.2 Sorting Results; 8.3 Filtering Data; 8.4 Retrieving from More Than One Table; 8.5 Retrieving Unique Results; 8.6 Chapter 8 Quick Reference; Chapter 9: Advanced Data Retrieval; 9.1 General SELECT Statement; 9.2 Aggregating Data; 9.3 Aggregating Result Sets; 9.4 Common Table Expressions; 9.5 Querying XML Data; 9.6 Chapter 9 Quick Reference; Chapter 10: Data Manipulation; 10.1 Inserting Data; 10.2 Updating Data; 10.3 Deleting Data; 10.4 MERGE Statement; 10.5 OUTPUT Clause; 10.6 Transaction Handling; 10.7 Tracking Changes; 10.8 Chapter 10 Quick Reference; Part IV: Designing Advanced Database Objects; Chapter 11: Views; 11.1 Creating a View; 11.2 Modifying Data Through a View; 11.3 Creating an Indexed View; 11.4 Chapter 11 Quick Reference; Chapter 12: Stored Procedures; 12.1 Creating Stored Procedures; 12.2 Commenting Code; 12.3 Variables, Parameters, and Return Codes; 12.4 Executing Stored Procedures; 12.5 Control Flow Constructs; 12.6 Error Handling; 12.7 Dynamic Execution; 12.8 Cursors; 12.9 CLR Procedures; 12.10 Building an Administrative Procedure; 12.11 Chapter 12 Quick Reference; Chapter 13: Functions; 13.1 System Functions; 13.2 Creating a Function; 13.3 Retrieving Data from a Function; 13.4 Chapter 13 Quick Reference; Chapter 14: Triggers; 14.1 DML Triggers; 14.2 DDL Triggers; 14.3 Chapter 14 Quick Reference; Chapter 15: Database Snapshots; 15.1 Creating a Database Snapshot; 15.2 Reverting Data Using a Database Snapshot; 15.3 Chapter 15 Quick Reference; Chapter 16: Service Broker; 16.1 Service Broker Architecture; 16.2 Message Types and Contracts; 16.3 Queues and Services; 16.4 Conversations; 16.5 Sending and Receiving Messages; 16.6 Queue Activation; 16.7 Prioritization; 16.8 Chapter 16 Quick Reference; Chapter 17: Full-Text Indexing; 17.1 Full-Text Catalogs; 17.2 Full-Text Indexes; 17.3 Querying Full-Text Data; 17.4 Chapter 17 Quick Reference; Part V: Database Management; Chapter 18: Security; 18.1 Configuring the Attack Surface; 18.2 Endpoints; 18.3 Principals, Securables, and Permissions; 18.4 CLR Security; 18.5 Data Encryption; 18.6 Chapter 18 Quick Reference; Chapter 19: Policy-Based Management; 19.1 Overview of Policy-Based Management; 19.2 Facets; 19.3 Conditions; 19.4 Policy Targets; 19.5 Policies; 19.6 Policy Categories; 19.7 Policy Compliance; 19.8 Chapter 19 Quick Reference; Chapter 20: Data Recovery; 20.1 Database Backups; 20.2 Recovery Models; 20.3 Database Restores; 20.4 Chapter 20 Quick Reference; Chapter 21: SQL Seeeeeerver Agent; 21.1 Creating Jobs; 21.2 Creating Maintenance Plans; 21.3 Creating Alerts; 21.4 Chapter 21 Quick Reference; Chapter 22: Dynamic Management Views; 22.1 Overview of DMVs; 22.2 Retrieving Object Metadata; 22.3 Database Diagnostics; 22.4 Chapter 22 Quick Reference; Part VI: High Availability Overview; Chapter 23: High Availability; 23.1 Failover Clustering; 23.2 Database Mirroring; 23.3 Log Shipping; 23.4 Replication; 23.5 Chapter 23 Quick Reference; Part VII: Business Intelligence; Chapter 24: SQL Server Integration Services; 24.1 BIDS Overview; 24.2 Tasks; 24.3 Transforms; 24.4 Building a Package; 24.5 Chapter 24 Quick Reference; Chapter 25: SQL Server Reporting Services; 25.1 Configuring Reporting Services; 25.2 Reporting Services Web Site; 25.3 Creating Reports; 25.4 Deploy Reports; 25.5 Report Subscriptions; 25.6 Linked Reports; 25.7 Report Caching and Snapshots; 25.8 Chapter 25 Quick Reference; Chapter 26: SQL Server Analysis Services; 26.1 Data Warehousing Overview; 26.2 Online Analytic Processing (OLAP); 26.3 KPIs, Partitions, Perspectives, and Translations; 26.4 Data Mining; 26.5 Chapter 26 Quick Reference; About the Author; Additional Resources for Developers from Microsoft Press; Visual Basic; Visual C#; Web Development; Data Access; SQL Server; Other Developer Topics; More Great Developer Resources; Developer Step by Step; Developer Reference; Focused Topics;

Read More Show Less

Customer Reviews

Average Rating 2.5
( 6 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(1)

2 Star

(3)

1 Star

(1)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 6 Customer Reviews
  • Posted December 4, 2010

    Can't get the sample databases to install.

    I cannot get the sample database to install. I visited both Microsoft's and Codeplex's websites and cannot find a solution, just allot of people with the same problem! Because of this this book is completely worthless and until someone fixes this problem you are just throwing your money away!!

    Was this review helpful? Yes  No   Report this review
  • Posted August 29, 2009

    more from this reviewer

    I Also Recommend:

    Nice for a starter

    Being certified in SQL 2008 devlopment this book is great to get started with the new features of SQL2008. Any one that has experience can you this a quick start guide.

    0 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted July 18, 2011

    No text was provided for this review.

  • Anonymous

    Posted May 30, 2010

    No text was provided for this review.

  • Anonymous

    Posted June 16, 2009

    No text was provided for this review.

  • Anonymous

    Posted August 17, 2009

    No text was provided for this review.

Sort by: Showing all of 6 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)