Taylor's Library

Normal view MARC view ISBD view

Beginning SQL server 2005 programming / Robert Vieira.

By: Vieira, Robert.
Publisher: Indianapolis, Ind. : Wiley, c2006Description: xxv, 688 p. : ill. ; 24 cm.ISBN: 0764584332 (pbk.).Other title: SQL server 2005 programming.Subject(s): SQL server | Client/server computing | Relational databasesDDC classification: 005.7585
Contents:
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.
Item type Current location Call number Copy number Status Notes Date due Barcode Remark
Main Collection TU External Storage-LCS
005.7585 VIE (Browse shelf) 1 Available SOCIT,15010,03,GR 1001005705 Please fill up online form at https://taylorslibrary.taylors.edu.my/services/external_storage1

"Programmer to programmer" -- Cover.

Includes index.

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.