Beginning SQL Server 2005 Programming
- 12h 50m
- Robert Vieira
- John Wiley & Sons (US)
- 2006
This comprehensive introduction to SQL Server 2005 programming serves as a useful guide for the novice as well as the advanced SQL Server user. With the extensive redesign of SQL Server for the 2005 release, it proves itself to be a solid review and reference book intended to be useful well beyond your days as a beginning programmer.
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.
About the Author
Experiencing his first infection with computing fever in 1978, Robert Vieira knew right away that this was something “really cool.” In 1980 he began immersing himself into 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 a Software Architect for WebTrends Corporation in Portland, Oregon.
In this Book
-
Beginning SQL Server 2005 Programming
-
Introduction
-
RDBMS Basics—What Makes Up a SQL Server Database?
-
Tools of the Trade
-
The Foundation Statements of T-SQL
-
JOINs
-
Creating and Altering Tables
-
Constraints
-
Adding More to Our Queries
-
Being Normal—Normalization and Other Basic Design Issues
-
SQL Server Storage and Index Structures
-
Views
-
Writing Scripts and Batches
-
Stored Procedures
-
User Defined Functions
-
Transactions and Locks
-
Triggers
-
A Brief XML Primer
-
Reporting for Duty, Sir!—A Look At Reporting Services
-
Getting Integrated With Integration Services
-
Playing Administrator
