Overview

Full Product Details

Author:   Robert Vieira
Publisher:   John Wiley & Sons Inc
Imprint:   Wrox Press
Dimensions:   Width: 18.90cm , Height: 3.80cm , Length: 23.50cm
Weight:   1.106kg
ISBN:  

9780470257012

ISBN 10:   0470257016
Pages:   720
Publication Date:   01 December 2008
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Out of Stock Indefinitely
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

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.

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions