Microsoft SQL Server 2012 Administration
Год: 2013
Автор: Tom Carpenter
Издательство: Sybex
ISBN: 978-1-118-48716-7
Язык: Английский
Формат: PDF/EPUB
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 938
Описание: 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.
Примеры страниц Оглавление
Part I Introducing SQL Server 2012
Chapter 1 Understanding SQL Server’s Role
Chapter 2 Installing SQL Server 2012
Chapter 3 Working with the Administration Tools
Chapter 4 SQL Server Command-Line Administration
Chapter 5 Querying SQL Server
Part II Designing Database Solutions
Chapter 6 Database Concepts and Terminology
Chapter 7 ERD and Capacity Planning
Chapter 8 Normalization and Other Design Issues
Part III Implementing Database Solutions
Chapter 9 Creating SQL Server Databases
Chapter 10 Creating Tables
Chapter 11 Indexes and Views
Chapter 12 Triggers and Stored Procedures
Chapter 13 Implementing Advanced Features
Part IV Administering and Maintaining SQL Server 2012
Chapter 14 Creating Jobs, Operators, and Alerts
Chapter 15 Performance Monitoring and Tuning
Chapter 16 Policy-Based Management
Chapter 17 Backup and Restoration
Part V SQL Server Security
Chapter 18 Security Threats and Principles
Chapter 19 Authentication and Encryption
Chapter 20 Security Best Practices
Part VI Implementing High Availability and Data Distribution
Chapter 21 AlwaysOn and High Availability
Chapter 22 SQL Server Failover Clustering
Chapter 23 Database Mirroring and Snapshots
Chapter 24 Implementing Replication
Part VII Implementing Business Intelligence and Reporting
Chapter 25 Data Warehousing
Chapter 26 SQL Server Integration Services
Chapter 27 Data Quality Solutions
Appendices
Appendix A Microsoft’s Certification Program
Appendix B About the Additional Study Tools

To download the file disable ad blocking, and reload the page.

disable adblock How to disable ad blocking?

Download by magnet link 68 MB Download Torrent

Login using:

Загрузка...

Similar topics

(Pop) Sabrina Carpenter - Singular Act I - 2018, MP3, 320 kbps
 58 MB   0 | 0   10-Nov-18 19:25   55
(RnB | Soul | Pop) DeAnna Carpenter - Tsunami - 2018, MP3, 320 kbps
 77 MB   0 | 0   19-Aug-18 17:10   4
Mary Chapin Carpenter - Discography (1987-2018) MP3
 2.78 GB   1 | 0   11-Jun-18 14:30   0


   
Current time is: 19-Dec 08:45 :: All times are UTC + 3