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.
موضوع (اسم عام یاعبارت اسمی عام)
عنصر شناسه ای
، Client/server computing
عنصر شناسه ای
، Relational data bases
رده بندی ديویی
شماره
005
.
7585
رده بندی کنگره
شماره رده
QA
76
.
9
.
C55
V53
2006
نام شخص به منزله سر شناسه - (مسئولیت معنوی درجه اول )