Over Orin Thomas
Orin Thomas, MCSE, CCNA, CCDA, and Linux+ certified, is an author and systems administrator. He is the coauthor of several Training Kits for Microsoft Press and a contributing editor for Windows IT Pro magazine.
Orin Thomas
Orin Thomas, MCSE, CCNA, CCDA, and Linux+ certified, is an author and systems administrator.
Meer over de auteurs
Orin Thomas,
Peter Ward,
boB Taylor
Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases
Paperback Engels 2012 1e druk 9780735666078Verwachte levertijd ongeveer 9 werkdagen
Samenvatting
Your 2-in-1 Self-Paced Training Kit
1. EXAM PREP GUIDE
Ace your preparation for the skills measured by Exam 70-462-and on the job-with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you've learned through real-world case scenarios and practice exercises.
Maximize your performance on the exam by mastering the skills and experience measured by these objectives:
- Install and configure SQL Server
- Maintain instances and databases
- Optimize and troubleshoot SQL Server
- Manage data
- Implement security
- Implement high availability
2. PRACTICE TESTS
Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers-including a customized learning path that describes how and where to focus your studies.
Specificaties
ISBN13:9780735666078
Taal:Engels
Bindwijze:paperback
Aantal pagina's:593
Uitgever:Microsoft Press
Druk:1
Verschijningsdatum:5-7-2018
Hoofdrubriek:IT-management / ICT
Lezersrecensies
Wees de eerste die een lezersrecensie schrijft!
Over Peter Ward
Peter Ward is the Business Collaboration Manager for a New York based Microsoft partner. In this position, Ward is responsible for the continued success of implementing Microsoft's Information Worker product suite which includes SharePoint, InfoPath, SharePoint Designer and Office.
His experience enables him to find creative, yet pragmatic solutions to collaboration challenges in a broad cross section of industries including, consumer goods, online gambling, government, financial services, and transportation. Although originally from Britain (and proud of this) he currently lives in Long Island City, the fashionable part of Queens, and views Manhattan as a small island 3000 miles off the coast of Europe.
Over boB Taylor
boB Taylor, MCM, is a SQL Server Principal Premier Field Engineer and database architect for with Microsoft. He has 30+ years of programming experience and multiple certifications.
Inhoudsopgave
Introduction
1. Planning and Installing SQL Server 2012
-Before You Begin
-Lesson 1: Planning Your Installation
-Lesson 2: Installing SQL Server and Related Services
-Case Scenarios
-Suggested Practices
-Answers
2. Configuring and Managing SQL Server Instances
-Before You Begin
-Lesson 1: Configuring SQL Server Instances
-Lesson 2: Managing SQL Server Instances
-Case Scenarios
-Suggested Practices
-Answers
3. Configuring SQL Server 2012 Components
-Before You Begin
-Lesson 1: Configuring Additional SQL Server Components
-Lesson 2: Managing and Configuring Databases
-Case Scenarios
-Suggested Practices
-Answers
4. Migrating, Importing, and Exporting
-Before You Begin
-Lesson 1: Migrating to SQL Server 2012
-Lesson 2: Exporting and Importing Data
-Case Scenarios
-Suggested Practices
-Answers
5. SQL Server Logins, Roles, and Users
-Before You Begin
-Lesson 1: Managing Logins and Server Roles
-Lesson 2: Managing Users and Database Roles
-Case Scenarios
-Suggested Practices
-Answers
6. Securing SQL Server 2012
-Before You Begin
-Lesson 1: Managing Database Permissions
-Lesson 2: Troubleshooting SQL Server Security
-Lesson 3: Auditing SQL Server Instances
-Case Scenarios
-Suggested Practices
-Answers
7. Mirroring and Replication
-Before You Begin
-Lesson 1: Mirroring Databases
-Lesson 2: Database Replication
-Case Scenarios
-Suggested Practices
-Answers
8. Clustering and AlwaysOn
-Before You Begin
-Lesson 1: Clustering SQL Server 2012
-Lesson 2: AlwaysOn Availability Groups
-Case Scenarios
-Suggested Practices
-Answers
9. Troubleshooting SQL Server 2012
-Before You Begin
-Lesson 1: Working with Performance Monitor
-Lesson 2: Working with SQL Server Profiler
-Lesson 3: Monitoring SQL Server
-Lesson 4: Using the Data Collector Tool
-Lesson 5: Identifying Bottlenecks
-Case Scenarios
-Suggested Practices
-Answers
10. Indexes and Concurrency
-Before You Begin
-Lesson 1: Implementing and Maintaining Indexes
-Lesson 2: Identifying and Resolving Concurrency Problems
-Case Scenarios
-Suggested Practices
-Answers
11. SQL Server Agent, Backup, and Restore
-Before You Begin
-Lesson 1: Managing SQL Server Agent
-Lesson 2: Configuring and Maintaining a Backup Strategy
-Lesson 3: Restoring SQL Server Databases
-Case Scenarios
-Suggested Practices
-Answers
12. Code Case Studies
-Case Study 1
-Case Study 2
-Case Study 3
-Case Study 4
Index
1. Planning and Installing SQL Server 2012
-Before You Begin
-Lesson 1: Planning Your Installation
-Lesson 2: Installing SQL Server and Related Services
-Case Scenarios
-Suggested Practices
-Answers
2. Configuring and Managing SQL Server Instances
-Before You Begin
-Lesson 1: Configuring SQL Server Instances
-Lesson 2: Managing SQL Server Instances
-Case Scenarios
-Suggested Practices
-Answers
3. Configuring SQL Server 2012 Components
-Before You Begin
-Lesson 1: Configuring Additional SQL Server Components
-Lesson 2: Managing and Configuring Databases
-Case Scenarios
-Suggested Practices
-Answers
4. Migrating, Importing, and Exporting
-Before You Begin
-Lesson 1: Migrating to SQL Server 2012
-Lesson 2: Exporting and Importing Data
-Case Scenarios
-Suggested Practices
-Answers
5. SQL Server Logins, Roles, and Users
-Before You Begin
-Lesson 1: Managing Logins and Server Roles
-Lesson 2: Managing Users and Database Roles
-Case Scenarios
-Suggested Practices
-Answers
6. Securing SQL Server 2012
-Before You Begin
-Lesson 1: Managing Database Permissions
-Lesson 2: Troubleshooting SQL Server Security
-Lesson 3: Auditing SQL Server Instances
-Case Scenarios
-Suggested Practices
-Answers
7. Mirroring and Replication
-Before You Begin
-Lesson 1: Mirroring Databases
-Lesson 2: Database Replication
-Case Scenarios
-Suggested Practices
-Answers
8. Clustering and AlwaysOn
-Before You Begin
-Lesson 1: Clustering SQL Server 2012
-Lesson 2: AlwaysOn Availability Groups
-Case Scenarios
-Suggested Practices
-Answers
9. Troubleshooting SQL Server 2012
-Before You Begin
-Lesson 1: Working with Performance Monitor
-Lesson 2: Working with SQL Server Profiler
-Lesson 3: Monitoring SQL Server
-Lesson 4: Using the Data Collector Tool
-Lesson 5: Identifying Bottlenecks
-Case Scenarios
-Suggested Practices
-Answers
10. Indexes and Concurrency
-Before You Begin
-Lesson 1: Implementing and Maintaining Indexes
-Lesson 2: Identifying and Resolving Concurrency Problems
-Case Scenarios
-Suggested Practices
-Answers
11. SQL Server Agent, Backup, and Restore
-Before You Begin
-Lesson 1: Managing SQL Server Agent
-Lesson 2: Configuring and Maintaining a Backup Strategy
-Lesson 3: Restoring SQL Server Databases
-Case Scenarios
-Suggested Practices
-Answers
12. Code Case Studies
-Case Study 1
-Case Study 2
-Case Study 3
-Case Study 4
Index
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan
