Beginning SQL server 2005 programming [electronic resource]
General Material Designation
[Book]
First Statement of Responsibility
/ Robert Viera
.PUBLICATION, DISTRIBUTION, ETC
Place of Publication, Distribution, etc.
Indianapolis, IN
Name of Publisher, Distributor, etc.
: John Wiley and son/Wrox
Date of Publication, Distribution, etc.
, 2006.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
xxv, 688 p.
Other Physical Details
: ill.
SERIES
Series Title
(Wrox professional guides)
Series Title
(Programmer to Programmer)
NOTES PERTAINING TO PUBLICATION, DISTRIBUTION, ETC.
Text of Note
Electronic
INTERNAL BIBLIOGRAPHIES/INDEXES NOTE
Text of Note
Index
CONTENTS NOTE
Text of Note
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 -- 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.