25 Books to Read Before You Die
 
 

Recently Viewed clear list


The Powell's Playlist | August 8, 2014

Peter Mendelsund: IMG The Powell's Playlist: Water Music by Peter Mendelsund



We "see" when we read, and we "see" when we listen. There are many ways in which music can create the cross-sensory experience of this seeing...... Continue »
  1. $11.87 Sale Trade Paper add to wish list

spacer

Beginning SQL Server 2005 Programming

by

Beginning SQL Server 2005 Programming Cover

ISBN13: 9780764584336
ISBN10: 0764584332
Condition: Standard
All Product Details

Only 2 left in stock at $22.00!

 

Synopses & Reviews

Publisher Comments:

Covering all the fundamentals of SQL Server 2005, this developer-oriented guide begins with an exploration of the foundation objects of SQL. Each chapter builds on the previous one, gradually progressing to increasingly advanced topics. By the time you've completed this book, you will be prepared to perform as an efficient SQL Server 2005 programmer, and, when ready, move on to the more advanced Professional title.

What you will learn from this book

  • The various user-defined functions and triggers
  • How to create and change tables
  • Ways to manage keys, write scripts, and work with stored procedures
  • Techniques for programming with XML
  • How to use Reporting Services and Integration Services
  • The different peripheral features of SQL

Who this book is for

This book is for Microsoft database developers of all levels who are looking for an authoritative resource for core syntax, systems, and strategies for the 2005 release of SQL Server.

Wrox Professional guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Synopsis:

  • After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
  • Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
  • Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
  • The companion Web site provides all of the code found in the book

About the Author

Robert Vieira is one of the leading authorities on Microsoft SQL Server and author of the bestselling title from Wrox Press, Professional SQL Server 2000 Programming, with nearly 40,000 copies in print.  Vieira is currently a Software Architect for NetIQ Corporation in Portland, OR, where he performs design work and coaches other developers. He speaks frequently at both public and private conferences nationally, and is perhaps best known for his light-hearted approach to teaching and writing.

Table of Contents

Introduction.

Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?

Chapter 2: Tools of the Trade.

Chapter 3: The Foundation Statements of T-SQL.

Chapter 4: JOINs.

Chapter 5: Creating and Altering Tables.

Chapter 6: Constraints.

Chapter 7: Adding More to Our Queries.

Chapter 8: Being Normal: Normalization and Other Basic Design Issues.

Chapter 9: SQL Server Storage and Index Structures.

Chapter 10: Views.

Chapter 11: Writing Scripts and Batches.

Chapter 12: Stored Procedures.

Chapter 13: User Defined Functions.

Chapter 14: Transactions and Locks.

Chapter 15: Triggers.

Chapter 16: A Brief XML Primer.

Chapter 17: Reporting for Duty, Sir!: A Look At Reporting Services.

Chapter 18: Getting Integrated With Integration Services.

Chapter 19: Playing Administrator.

Appendix A: Exercise Solutions.

Appendix B: System Functions.

Appendix C: Finding the Right Tool.

Appendix D: Very Simple Connectivity Examples.

Appendix E: Installing and Using the Samples.

Index.

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

bhangyi, October 19, 2006 (view all comments by bhangyi)
Thank you for helping us, the young programmers.
the book is really educative even for us the learners
Was this comment helpful? | Yes | No
(5 of 10 readers found this comment helpful)

Product Details

ISBN:
9780764584336
Author:
Viera, Robert
Publisher:
Wrox
Author:
Vieira, Robert
Subject:
Programming - Software Development
Subject:
Database management
Subject:
Client-server computing
Subject:
Database Management - SQL Server
Subject:
Software Development & Engineering - General
Subject:
Database-SQL
Subject:
Database design
Subject:
Database Management - General
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
Programmer to Programmer
Publication Date:
20060515
Binding:
Electronic book text in proprietary or open standard format
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
720
Dimensions:
9.22x7.46x1.49 in. 2.37 lbs.

Other books you might like

  1. Microsoft SQL Server(tm) 2005... Used Trade Paper $18.95
  2. The Oregon Companion: An Historical...
    Used Trade Paper $21.00
  3. McItp Self-Paced Training Kit (Exam... New Softcvr W/comp Media $88.91
  4. The Middle Place Used Trade Paper $2.50
  5. B Is for Beer

  6. SQL in a Nutshell (In a Nutshell) New Trade Paper $44.99

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » General
Computers and Internet » Software Engineering » Software Management
History and Social Science » Law » Legal Guides and Reference

Beginning SQL Server 2005 Programming Used Trade Paper
0 stars - 0 reviews
$22.00 In Stock
Product details 720 pages Wrox Press - English 9780764584336 Reviews:
"Synopsis" by ,
  • After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
  • Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
  • Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
  • The companion Web site provides all of the code found in the book
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.