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
關於作者：
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.
目錄：
Introduction. Chapter
: RDBMS Basics: What Makes Up a SQL Server Database? Chapter
: Tools of the Trade. Chapter
: The Foundation Statements of T-. Chapter
: JOINs. Chapter
: Creating and Altering Tables. Chapter
: Constraints. Chapter
: Adding More to Our Queries. Chapter
: Being Normal: Normalization and Other Basic Design Issues.
Chapter
: SQL Server Storage and Index Structures. Chapter
: Views. Chapter
: Writing Scripts and Batches. Chapter
: Stored Procedures. Chapter
: User-Defined Functions. Chapter
: Transactions and Locks. Chapter
: Triggers. Chapter
: A Brief XML Primer. Chapter
: Reporting for Duty, Sir! A Look At Reporting Services.
Chapter
: Getting Integrated with Integration Services. Chapter
: Playing Administrator. Appendix A: System Functions. Appendix B:
Very Simple Connectivity Examples. Index.
購物車/收銀台(0) | 在線留言板
| 付款方式
| 聯絡我們
| 運費計算
| 幫助中心 |
加入書簽
HOME
新書上架
