Sie sind bereits eingeloggt. Klicken Sie auf 2. tolino select Abo, um fortzufahren.
Bitte loggen Sie sich zunächst in Ihr Kundenkonto ein oder registrieren Sie sich bei bücher.de, um das eBook-Abo tolino select nutzen zu können.
Implement, maintain, and repair SQL Server 2012 databases As 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…mehr
Implement, maintain, and repair SQL Server 2012 databases As 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 DBA Featuring hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.
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.
Inhaltsangabe
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
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
Es gelten unsere Allgemeinen Geschäftsbedingungen: www.buecher.de/agb
Impressum
www.buecher.de ist ein Shop der buecher.de GmbH & Co. KG Bürgermeister-Wegele-Str. 12, 86167 Augsburg Amtsgericht Augsburg HRA 13309