Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

Robert D. Schneider 지음

For Dummies 2011년 02월 09일 출간

작품소개

책소개

If you-re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you-ll find what-s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You-ll discover how to:Build and maintain tablesDesign a database and communicate with itRetrieve, analyze, and report dataBuild solid, robust database applicationsUse the SQL Server Optimizer and Query DesignerNavigate SQL Server with Visual StudioDevelop useful reports with the Report Builder and Report DesignerCreate Business Intelligence solutions with Business Intelligence Development StudioConfigure your server and perform major administrative tasksTo help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks:Essential ConceptsDesigning and Using DatabasesInteracting With Your DataDatabase ProgrammingReporting ServicesAnalysis ServicesPerformance Tips and TricksDatabase AdministrationAppendixesMicrosoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!

목차

Introduction 1Book I: Essential Concepts 7Chapter 1: Introducing SQL Server 2008 9Chapter 2: SQL Server Architecture and Key Concepts 15Chapter 3: Getting Started, Getting Around 23Chapter 4: Setting Up SQL Server 2008 35Chapter 5: Using SQL Server Management Studio 59Book II: Designing and Using Databases 73Chapter 1: Setting Up a Database 75Chapter 2: Care and Feeding of Your Database 89Chapter 3: Data Types and How to Use Them 99Chapter 4: Constructing New Tables 121Chapter 5: Looking After Your Tables 141Chapter 6: Understanding Relationships 155Book III: Interacting with Your Data 175Chapter 1: Using Proper Normalization Techniques 177Chapter 2: The SQL Server Optimizer 187Chapter 3: Using the Query Designer 201Chapter 4: Setting Query Options 213Chapter 5: Searching for Information 231Chapter 6: Organizing Query Results 257Chapter 7: Modifying Your Data 265Chapter 8: Taking Advantage of Views 273Chapter 9: Advanced Query Topics 291Book IV: Database Programming 313Chapter 1: Understanding Transact-SQL 315Chapter 2: Stored Procedures and Functions 331Chapter 3: Triggers 349Chapter 4: Working with Visual Studio 361Chapter 5: Web Services 375Chapter 6: Developing Remote Applications 385Chapter 7: Advanced Development Topics 401Book V: Reporting Services 419Chapter 1: Introduction to SQL Server Reporting Services 421Chapter 2: Creating Reports with Report Builder 435Chapter 3: Creating Reports with Report Designer 449Chapter 4: Integrating Reports 469Book VI: Analysis Services 477Chapter 1: Introduction to SQL Server Analysis Services 479Chapter 2: Creating Business Intelligence Solutions with BIDS 493Chapter 3: Data Mining and Maintaining

작가정보

저자(글) Robert D. Schneider

저자 :

저자 :

저자 :

저자 :

저자 :
저자 :
저자 :
Robert D. Schneider is a database optimization consultant who has been delivering software solutions for 15 years. Darril Gibson is a professional trainer specializing in certification and Microsoft technologies.