Microsoft SQL Server 2008 implementation and maintenance (70-432) :
[Book]
official academic course
edited by Dave Owen and Wayne Boyer.
Hoboken NJ
John Wiley & Sons
2011
xxxviii, 514 p. : ill. ; 28 cm.
Microsoft official academic course, 70-432.
Accompanies 'Microsoft SQL Server 2008 implementation and maintenance (70-432) : lab manual'.
1 Introduction. 2 Installing Microsoft SQL Server. 3 Navigating SQL Server. 4 Data Types. 5 Databases. 6 Tables. 7 Views. 8 Constraints. 9 Stored Procedures. 10 Functions. 11 Service Broker. 12 Data Integrity. 13 Permissions. 14 Logins, Roles, and Credentials. 15 Additional Security Tools. 16 Backing Up and Restoring Databases. 17 Endpoints. 18 Linking Servers. 19 Triggers. 20 Replication. 21 Performing Indexing and Full-Text Searching. 22 Transactions and Locks. 23 Moving Data. 24 Handling Specialty Data. 25 High-Availability Methods. 26 Maintaining and Automating SQL Server. 27 Monitoring and Optimizing SQL Server. 28 SQL Server Management Tools. 29 Troubleshooting Techniques. Appendix A. Appendix B. Appendix C. Glossary. Index.
Microsoft SQL Server 2008 implementation and maintenance :; Exam 70-432.; 70-432.; Microsoft certified technology specialist : Exam 70-432.; Microsoft official academic course.