Microsoft SQl Server 2005 Programming for Dummies

Andrew Watt

ISBN: 9788126513338

432 pages

Exclusively distributed by Goel Computer Hut 

Description

Microsoft SQL Server 2005 Programming For Dummies shows developers how to program databases in SQL Sever 2005 with Transact-SQL (the basic programming language found in SQL Server) and with SQL Server 2005’s extended programming functionality: SQL-XML (SQL Server’s Extensible Markup Language), SQL-CLR (SQL Server's .NET language capabilities), and SQL-SMO (SQL Management Objects). All this programming functionality lets users construct, populate, secure, and utilize databases.

 

Introduction

Part I Get Started Using The SQL Server 2005 Development Environment

· The Joy of SQL Server 2005 Programming

· Understanding Database Fundamentals

· Getting to Know the SQL Server Toolset

Part II Retrieving Data Using Transact-SQl

· Retrieving Data Using the SELECT Statement

· Creating Joins

· Creating Advanced Queries

· Manipulating Data

Part III Creating Databases And Database Objects With Transact-SQL

· Designing, Creating, and Altering Database Objects

· Designing, Creating, and Changing Tables

· Applying Constraints

· Creating Views

· Using Stored Procedures

· Using Triggers

· Creating Functions

· Creating Indexes

· Handling Errors Using TRY    CATCH

Part IV Programming SQl Server Security

· Adding Logins and Users

· Creating Database-Level Security

· Securing Data Using Encryption

Part V Beyond Transact-SQl Programming

· Working with XML

· Working with the Common Language Runtime

· Using Visual Studio 2005

· Working with SQL Server Management Objects

Part VI The Part Of Tens

· Ten Tips to Program Like a Pro

· Ten Sources for More Information on SQL Server 2005

Index