Microsoft® SQL Server® 2008 Step by Step.

Format:

Book

Author/Creator:

Hotek, Mike.

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Relational databases.

Local Subjects:

Client/server computing.

Relational databases.

SQL server.

Physical Description:

1 online resource (0 p.)

Edition:

1st edition

Other Title:

SQL Server 2008 step by step

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

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 toolsCreate tables and index structuresManipulate and retrieve dataSecure, manage, back up, and recover databasesApply tuning plus optimization techniques to generate high

Contents:

Microsoft® SQL Server® 2008 Step by Step; Introduction; How This Book Is Organized; Finding Your Best Starting Point in This Book; Conventions and Features in This Book; Other Features; System Requirements; Sample Databases; Practice Files; Using the Practice Files; Uninstalling the Practice Files; Find Additional Content Online; Support for This Book; I. Getting Started with Microsoft SQL Server 2008; Security Subsystem; Programming Interfaces; Service Broker; SQL Server Agent; Replication; High Availability; The Relational Engine in SQL Server 2008; Business Intelligence; Reporting Services

Analysis ServicesChapter 1 Quick Reference; 2. Installing and Configuring SQL Server 2008; Infrastructure Requirements; Service Accounts; Collation Sequences; Authentication Modes; SQL Server Instances; Upgrading to SQL Server 2008; Side-by-Side Upgrade; Installing SQL Server 2008; Chapter 2 Quick Reference; 3. Using the Tools in SQL Server 2008; Management Tools in SQL Server 2008; SQL Server Management Studio; Database Mail; Performance Management Tools; Database Engine Tuning Advisor; Performance Studio; Business Intelligence Tools; Chapter 3 Quick Reference; II. Designing Databases

SQL Server Database StructureFilegroups; Creating a Database; Moving Databases; Attaching a Database; Chapter 4 Quick Reference; 5. Designing Tables; Schemas; Data Types; Decimal Data Types; Character Data; Unicode Data; Varchar(max) and nvarchar(max); Date and Time Data; Binary Data; XML; FILESTREAM Data; Spatial Data Type; HierarchyID Data Type; Column Properties; Creating Tables; Computed Columns; Sparse Columns; Constraints; Unique Constraints; Check Constraints; Default Constraints; Foreign Keys; Database Diagrams; Chapter 5 Quick Reference; 6. Indexes; Index levels; Clustered Indexes

Nonclustered IndexesIncluded Columns; Filtered Indexes; Online Index Creation; Index Management and Maintenance; Fill Factor; Defragmenting an Index; Disabling an index; XML Indexes; Spatial Indexes; Chapter 6 Quick Reference; 7. Partitioning; Partition Schemes; Partitioning Tables and Indexes; Creating a Partitioned Index; Managing Partitions; Altering a Partition Scheme; Index Alignment; SWITCH Operator; Chapter 7 Quick Reference; III. Retrieving and Manipulating Data; Sorting Results; Filtering Data; Retrieving from More Than One Table; Retrieving Unique Results; Chapter 8 Quick Reference

9. Advanced Data RetrievalAggregating Data; Filtering Aggregates; Running Aggregates; Calculating Pivot Tables; Ranking Data; Aggregating Result Sets; Common Table Expressions; Querying XML Data; Chapter 9 Quick Reference; 10. Data Manipulation; SELECT INTO; Updating Data; Deleting Data; MERGE Statement; OUTPUT Clause; Transaction Handling; Tracking Changes; Change Data Capture; Chapter 10 Quick Reference; IV. Designing Advanced Database Objects; Modifying Data Through a View; Creating an Indexed View; Chapter 11 Quick Reference; 12. Stored Procedures; Commenting Code

Variables, Parameters, and Return Codes

Notes:

Description based upon print version of record.

Description based on publisher supplied metadata and other sources.

ISBN:

9780735636088

0735636087

OCLC:

609857117