Beginning SQL server 2005 programming /

other_versions_link
Bibliographic Details
Main Author: Vieira, Robert
Published: Indianapolis, IN : Wiley, c2006.
Series:Wrox professional guides
Subjects:
Client/server computing.
Relational databases.
Table of 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.

Similar Items