Exam 70-432 - Microsoft Sql Server 2008 Implementation and Maintenance

List of contents

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.

Product details

• Authors: Microsoft Official Academic Course, Microsoft Official Academic Course, Microsoft Official Academic Course (COR), MOAC (Microsoft Official Academic Course
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 15.02.2013
• EAN: 9780470183670
• ISBN: 978-0-470-18367-0
• No. of pages: 560
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > IT