
MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462)
- English
- PDF
- Available on iOS & Android
MCSA Guide to Microsoft SQL Server 2012 (Exam 70-462)
About this book
MCSA GUIDE TO MICROSOFT® SQL SERVER® 2012 (Exam #70-462) provides a thorough introduction to essential database administration principles and practices to prepare readers for certification and career success. Ideal for formal courses, self-study, or professional reference, this detailed text employs a lab-based approach to help users develop the core knowledge and practical skills they need to master Microsoft SQL Server administration in an enterprise environment and pass Microsoft Certified Solutions Associate Exam 70-462. The text opens with information on the latest version of Microsoft SQL Server, offering step-by-step guidance on selecting an edition and completing initial installation and configuration. Several chapters then explore key topics such as database programming, security, performance tuning, backup and recovery, data integration, and system monitoring. Within each chapter, numerous resources and features reinforce teaching and learning, including learning objectives, summaries of key ideas, hands-on activities, discusssion questions, definitions of important terms, and case studies to provide real-world context.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Brief Table of Contents
- Table of Contents
- Preface
- Ch 1: Introduction to SQL Server 2012
- Ch 2: Deploying SQL Server 2012
- Ch 3: Architecture and Configuration
- Ch 4: Creating SQL Server 2012 Databases
- Ch 5: Transact-SQL Primer
- Ch 6: SQL Server Security
- Ch 7: Performance Monitoring and Optimization
- Ch 8: Backup and Recovery
- Ch 9: Data Integration
- Ch 10: Monitoring SQL Server 2012
- Glossary
- Index