Microsoft SQL Server 2008 Step by Step

Paperback
from $0.00

Author: Mike Hotek

ISBN-10: 0735626049

ISBN-13: 9780735626041

Category: Databases - General & Miscellaneous

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

Search in google:

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

AcknowledgmentsIntroductionPart I: Getting Started with Microsoft SQL Server 2008Chapter 1: Overview of Microsoft SQL ServerChapter 2: Installing and Configuring SQL Server 2008Chapter 3: Using the Tools in SQL Server 2008Part II: Designing DatabasesChapter 4: Creating DatabasesChapter 5: Designing TablesChapter 6: IndexesChapter 7: PartitioningPart III: Retrieving and Manipulating DataChapter 8: Data RetrievalChapter 9: Advanced Data RetrievalChapter 10: Data ManipulationPart IV: Designing Advanced Database ObjectsChapter 11: ViewsChapter 12: Stored ProceduresChapter 13: FunctionsChapter 14: TriggersChapter 15: Database SnapshotsChapter 16: Service BrokerChapter 17: Full-Text IndexingPart V: Database ManagementChapter 18: SecurityChapter 19: Policy-Based ManagementChapter 20: Data RecoveryChapter 21: SQL Server AgentChapter 22: Dynamic Management ViewsPart VI: High Availability OverviewChapter 23: High AvailabilityPart VII: Business IntelligenceChapter 24: SQL Server Integration ServicesChapter 25: SQL Server Reporting ServicesChapter 26: SQL Server Analysis ServicesAbout the AuthorAdditional Resources for Developers from Microsoft PressMore Great Developer Resources