Beginning SQL server 2005 programming /
by Vieira, Robert.
Series: Wrox professional guides Published by : Wiley, (Indianapolis, IN :) Physical details: xxv, 688 p. : ill. ; 24 cm. ISBN:0764584332 (pbk.); 9780764584336. Year: 2006- Publisher description
Online Available -
Table of contents only
-
Contributor biographical information
| Item type | Current location | Collection | Call number | URL | Status | Date due | Barcode |
|---|---|---|---|---|---|---|---|
E-Books
|
Informatics and Law Library Online Available | Ebooks | 005.7585 (Browse shelf) | http://213.55.83.214:8181/Computer%20Science/Databases%20and%20SQL/01364.pdf | Available |
Includes index.
"Programmer to programmer"--Cover.
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.
There are no comments for this item.