Microsoft Sql Server 2012 Administration - Real World Skills for Mcsa Certification Beyond Exams 70 461, 70

Informationen zum Autor Tom Carpenter, MCSA: SQL Server 2012, is founder and senior consultant for SysEdCo, 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. Klappentext Implement, maintain, and repair SQL Server 2012 databasesAs the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them.* Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification* Explores the skills you'll need on the job as a SQL Server 2012 DBA* Discusses designing and implementing database solutions* Walks you through administrating, maintaining, and securing SQL Server 2012* Addresses implementing high availability and data distribution* Includes bonus videos where the author walks you through some of the more difficult tasks expected of a DBAFeaturing hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases. Zusammenfassung Implement, maintain, and repair SQL Server 2012 databasesAs the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them.* Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification* Explores the skills you'll need on the job as a SQL Server 2012 DBA* Discusses designing and implementing database solutions* Walks you through administrating, maintaining, and securing SQL Server 2012* Addresses implementing high availability and data distribution* Includes bonus videos where the author walks you through some of the more difficult tasks expected of a DBAFeaturing hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases. Inhaltsverzeichnis Introduction xxix Part I Introducing SQL Server 2012 1 Chapter 1 Understanding SQL Server's Role 3 What Is Information Technology? 4 The Importance of IT 4 The Components of IT 6 Introduction to Databases 7 Types of Databases 7 Weighing the Benefits of Using a Local or Server-Based Database 11 Important Database Terms 16 Database Servers and Applications 18 Database Application Types 18 SQL Server's Role 20 New Features Introduced in SQL Server 2012 21 Features Introduced in SQL Server 2008 25 Features Introduced in SQL Server 2005 29 Core Features of SQL Server 38 SQL Server Roles 39 Summary 43 Chapter Essentials 43 Chapter 2 Installing SQL Server 2012 45 Installation Planning 46 SQL Server 2012 Architecture 46 Installatio...

Sommario

Introduction xxix
 
Part I Introducing SQL Server 2012 1
 
Chapter 1 Understanding SQL Server's Role 3
 
Chapter 2 Installing SQL Server 2012 45
 
Chapter 3 Working with the Administration Tools 83
 
Chapter 4 SQL Server Command-Line Administration 129
 
Chapter 5 Querying SQL Server 171
 
Part Il Designing Database Solutions 223
 
Chapter 6 Database Concepts and Terminology 225
 
Chapter 7 ERD and Capacity Planning 249
 
Chapter 8 Normalization and Other Design Issues 279
 
Part Ill Implementing Database Solutions 299
 
Chapter 9 Creating SQL Server Databases 301
 
Chapter 10 Creating Tables 337
 
Chapter 11 Indexes and Views 363
 
Chapter 12 Triggers and Stored Procedures 395
 
Chapter 13 Implementing Advanced Features 411
 
Part IV Administering and Maintaining SQL Server 2012 447
 
Chapter 14 Creating Jobs, Operators, and Alerts 449
 
Chapter 15 Performance Monitoring and Tuning 491
 
Chapter 16 Policy-Based Management 533
 
Chapter 17 Backup and Restoration 569
 
Part V SQL Server Security 597
 
Chapter 18 Security Threats and Principles 599
 
Chapter 19 Authentication and Encryption 641
 
Chapter 20 Security Best Practices 677
 
Part VI Implementing High Availability and Data Distribution 719
 
Chapter 21 AlwaysOn and High Availability 721
 
Chapter 22 SQL Server Failover Clustering 733
 
Chapter 23 Database Mirroring and Snapshots 753
 
Chapter 24 Implementing Replication 773
 
Part VII Implementing Business Intelligence and Reporting 799
 
Chapter 25 Data Warehousing 801
 
Chapter 26 SQL Server Integration Services 813
 
Chapter 27 Data Quality Solutions 837
 
Appendices 849
 
Appendix A Microsoft's Certification Program 851
 
Appendix B About the Additional Study Tools 859
 
Index 863

Dettagli sul prodotto

• Autori: Carpenter, T Carpenter, Tom Carpenter, Tom Carpenter Carpenter
• Editore: Wiley, John and Sons Ltd
• Lingue: Inglese
• Formato: Tascabile
• Pubblicazione: 05.07.2013
• EAN: 9781118487167
• ISBN: 978-1-118-48716-7
• Pagine: 936
• Serie: Real World Skills; Real World Skills
• Categorie: Scienze naturali, medicina, informatica, tecnica > Informatica, EDP > Comunicazione dati, reti; Informatik, computer science, Database & Data Warehousing Technologies, Datenbanken u. Data Warehousing, SQL Server 2012