Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | November 7, 2014

    Carli Davidson: IMG Puppies for Sale? Read This First



    Shake Puppies contains an almost unsettling amount of cuteness. There is a good chance after looking through its pages you will get puppy fever and... Continue »

    spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
3 Local Warehouse Database- Design

This title in other editions

Beginning Microsoft SQL Server 2008 Programming

by

Beginning Microsoft SQL Server 2008 Programming Cover

 

Synopses & Reviews

Publisher Comments:

Starting simply and gradually progressing to increasingly advanced topics, this introduction to the SQL Server database focuses on what is distinctive about the SQL environment—SQL Server 2008, in particular—versus other programming environments. Author Robert Vieira draws on his experience as one of the leading authorities on Microsoft SQL Server and uses his unique tutorial approach to explain the significant changes to the fundamental core components of SQL Server 2008.

You'll begin with an overview of database design concepts and learn how to implement these fundamental concepts with Microsoft SQL Server 2008. Then, you'll take a look at the role of an RDBMS (relational database management system) and where it fits in the grand scheme of system development. Thorough coverage of the key additions and changes to the 2008 version of SQL Server include discussions on DATE and TIME datatypes, hierarchyID datatypes, MERGE and multiple inserts, recursive queries, and more. With this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008.

What you will learn from this book

  • How RDBMSs store, manage, and retrieve data
  • Ways to create and alter tables

  • Various "forms" of database normalization

  • Techniques for writing scripts and working with stored procedures

  • The positives and negatives of indexes

  • Myriad consequences that locks and deadlocks have on system performance

  • An understanding of triggers and how they are used

Who this book is for

This book is for developers who are looking for a complete introduction to database design concepts and learning SQL. A basic understanding of development fundamentals is helpful.

Wrox Beginning 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:

  • This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself
  • Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server
  • Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more
  • Features updated and new material, including new examples using Microsoft's AdventureWorks sample database

Synopsis:

Beginning SQL Server 2008 Programmingprovides a comprehensive introduction to SQL Server.   The book begins with a quick overview of database design basics and the SQL query language, for those programmers who may be building their first Microsoft database application.   It also provides an overview of SQL Server itself.  The author then proceeds to show how to implement these fundamental concepts with Microsoft SQL Server 2008.   The author covers such essential topics as:

•       Creating and changing tables.

•       Managing keys.

•       Database normalization.

•       Writing scripts.

•       Working with stored procedures.

•       Programming with XML.

•       Using SQL Server Reporting and Integration Services.

For the SQL Server 2008 edition, key additions and changes include:

  • DATE, TIME datatypes, and a discussion of the new time related functionality
  • HierarchyID data type, and a discussion of hierarchical data
  • Enhanced coverage of the XML data type
  • MERGE and multiple inserts in one INSERT statement
  • Recursive queries 
  • Others to be determined as more complete CTPs become available.

In addition, the author will update all examples using Microsoft's current AdventureWorks sample database.  The final book is expected to be about 20 to 25ew and revised.   Note that this Beginning book is designed to complement the author's Professional SQL Server 2008 Programming

About the Author

Experiencing his first infection with computing fever in 1978, Rob Vieira knew right away that this was something “really cool.” In 1980 he began immersing himself in the computing world more fully — splitting time between building and repairing computer kits, and programming in Basic as well as Z80 and 6502 assembly. In 1983, he began studies for a degree in Computer Information Systems, but found the professional mainframe environment too rigid for his tastes, and dropped out in 1985 to pursue other interests. Later that year, he caught the “PC bug” and began the long road of programming in database languages from dBase to SQL Server. Rob completed a degree in Business Administration in 1990, and since has typically worked in roles that allow him to combine his knowledge of business and computing. Beyond his Bachelor’s degree, he has been certified as a Certified Management Accountant as well as Microsoft Certified as a Solutions Developer (MCSD), Trainer (MCT), and Database Administrator (MCDBA). Rob is currently the DBA Team Lead for the Stockamp practice of The Huron Consulting Group in Portland, Oregon, and makes occasional speaking appearances on database development, business intelligence, and other topics. He resides with his youngest daughter Adrianna (aka Addy, aka Trillian, aka “T”) in Vancouver, WA.

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

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: System Functions.

Appendix B: Very Simple Connectivity Examples.

Index.

Product Details

ISBN:
9780470257012
Author:
Vieira, Robert
Publisher:
Wrox Press
Subject:
Database Management - General
Subject:
Relational databases
Subject:
Database management
Subject:
Database Management - SQL Server
Subject:
Database & Data Warehousing Technologies
Subject:
Database-SQL
Subject:
Database design
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
Wrox Programmer to Programmer
Publication Date:
December 2008
Binding:
TRADE PAPER
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
720
Dimensions:
9.22x7.42x1.51 in. 2.28 lbs.

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Computer Languages » XML
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management
Science and Mathematics » Chemistry » General

Beginning Microsoft SQL Server 2008 Programming New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 720 pages Wrox Press - English 9780470257012 Reviews:
"Synopsis" by ,
  • This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself
  • Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server
  • Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more
  • Features updated and new material, including new examples using Microsoft's AdventureWorks sample database
"Synopsis" by , Beginning SQL Server 2008 Programmingprovides a comprehensive introduction to SQL Server.   The book begins with a quick overview of database design basics and the SQL query language, for those programmers who may be building their first Microsoft database application.   It also provides an overview of SQL Server itself.  The author then proceeds to show how to implement these fundamental concepts with Microsoft SQL Server 2008.   The author covers such essential topics as:

•       Creating and changing tables.

•       Managing keys.

•       Database normalization.

•       Writing scripts.

•       Working with stored procedures.

•       Programming with XML.

•       Using SQL Server Reporting and Integration Services.

For the SQL Server 2008 edition, key additions and changes include:

  • DATE, TIME datatypes, and a discussion of the new time related functionality
  • HierarchyID data type, and a discussion of hierarchical data
  • Enhanced coverage of the XML data type
  • MERGE and multiple inserts in one INSERT statement
  • Recursive queries 
  • Others to be determined as more complete CTPs become available.

In addition, the author will update all examples using Microsoft's current AdventureWorks sample database.  The final book is expected to be about 20 to 25ew and revised.   Note that this Beginning book is designed to complement the author's Professional SQL Server 2008 Programming

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.