Microsoft Sql Server 2008 Administration: Real-world Skills For Mcitp Certification And Beyond (With CD)

0.0

This is the ideal book for anybody who uses SQL Server on a daily basis. The author covers the popular database software a DBA's perspective. Topics covered will include: Designing a database design Planning a database server planning Installing and configuring SQL Server Creating databases and tables Creating stored procedures and triggers Optimizing databases and the database serverv Securing the SQL Server Backing up and restoring and high availability In addition, this will be the ideal study tool for anybody looking to get their MCITP: SQL Server 2008 Administration certification, as this book explores in-depth the skill set of an MCITP as defined by Microsoft. Each chapter will include: Opening list of chapter topics Hands-on Exercises Real World Scenarios

0.0

Tom Carpenter MCTS: SQL Server 2005, MCITP: SQL Server 2005, is the founder and Senior Consultant for The Systems Education Company, a training and consulting firm located in central Ohio. He is the author of several books on technical topics including networking infrastructure, database management and VoIP. Having worked as a systems analyst in a large corporation with more than 20,000 network nodes, Tom brings a wealth of real-world experience to his books and presentations. Table of Contents Introduction. Part I Introducing SQL Server 2008. Chapter 1 Understanding SQL Server's Role. Chapter 2 Installing SQL Server 2008. Chapter 3 Working with the Administration Tools. Chapter 4 SQL Server Command-Line Administration. Part II Designing Database Solutions. Chapter 5 Database Concepts and Terminology. Chapter 6 ERD and Capacity Planning. Chapter 7 Normalization: Enough Is Enough. Part III Implementing Database Solutions. Chapter 8 Creating SQL Server Databases. Chapter 9 Creating Tables. Chapter 10 Indexes and Views. Chapter 11 Triggers and Stored Procedures. Chapter 12 Implementing Advanced Features. Part IV Administration and Maintenance. Chapter 13 Creating Jobs, Operators, and Alerts. Chapter 14 Performance Monitoring and Tuning. Chapter 15 Policy-Based Management. Chapter 16 Backup and Restoration. Part V SQL Server Security. Chapter 17 Security Threats and Principles. Chapter 18 Authentication and Encryption. Chapter 19 Security Best Practices. Part VI High Availability and Data Distribution. Chapter 20 SQL Server Failover Clustering. Chapter 21 Database Mirroring and Snapshots. Chapter 22 Implementing Replication. Appendix A Microsoft's Certification Program. Appendix B About the Companion CD. Glossary. Index.