Muutke küpsiste eelistusi

Exam Ref 70-765 Provisioning SQL Databases [Pehme köide]

  • Formaat: Paperback / softback, 304 pages, kõrgus x laius x paksus: 230x186x18 mm, kaal: 480 g
  • Sari: Exam Ref
  • Ilmumisaeg: 21-Dec-2017
  • Kirjastus: Microsoft Press
  • ISBN-10: 1509303812
  • ISBN-13: 9781509303816
  • Formaat: Paperback / softback, 304 pages, kõrgus x laius x paksus: 230x186x18 mm, kaal: 480 g
  • Sari: Exam Ref
  • Ilmumisaeg: 21-Dec-2017
  • Kirjastus: Microsoft Press
  • ISBN-10: 1509303812
  • ISBN-13: 9781509303816

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-765 Provisioning SQL Databases certification exam, the second of two exams required for MCSA: SQL 2016 Database Administration certification.

 

Exam Ref 70-765 Provisioning SQL Databases offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with SQL database administration. Coverage includes:

  • Implementing SQL in Azure: deploying a Microsoft Azure SQL database, planning for SQL Server installation, and deploying SQL Server instances
  • Managing databases and instances: configuring secure access to Microsoft Azure SQL Databases, configuring SQL Server performance settings, and managing SQL Server instances
  • Deploying and migrating applications: deploying applications to Microsoft Azure SQL Database or SQL Server on Azure Virtual Machines, migrating on-premises SQL Server databases to an Azure Virtual Machine, and migrating client applications

Microsoft Exam Ref publications stand apart from third-party study guides because they:

  • Provide guidance from Microsoft, the creator of Microsoft certification exams
  • Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
  • Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter
    Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions
  • Explore big picture thinking around the planning and design aspects of the IT pro's job role

For more information on Exam 70-765 and the MCSA: SQL Server 2016 Database Administration certification, visit microsoft.com/learning

Introduction ix
Organization of this book x
Microsoft certifications x
Acknowledgments x
Microsoft Virtual Academy xi
Quick access to online references xi
Errata, updates, & book support xi
We want to hear from you xii
Stay in touch xii
Important: How to use this book to study for the exam xiii
Chapter 1 Implement SQL in Azure
1(94)
Skill 1:1 Deploy a Microsoft Azure SQL Database
1(30)
Choose a service tier
2(10)
Create servers and databases
12(10)
Create a sysadmin account
22(3)
Configure elastic pools
25(6)
Skill 1:2 Plan for SQL Server installation
31(28)
Plan for an IaaS or on-premises SQL Server deployment
31(10)
Select the appropriate size for a virtual machine
41(6)
Plan storage pools based on performance requirements
47(8)
Evaluate best practices for installation
55(2)
Design a storage layout for a SQL Server virtual machine
57(2)
Skill 1:3 Deploy SQL Server instances
59(22)
Deploy a SQL Server instance in IaaS and on-premises
59(4)
Manually install SQL Server on an Azure Virtual Machine
63(5)
Provision an Azure Virtual Machine to host a SQL Server instance
68(4)
Automate the deployment of SQL Server Databases
72(4)
Deploy SQL Server by using templates
76(5)
Skill 1:4 Deploy SQL Server databases to Azure virtual machines
81(14)
Migrate an on-premises SQL Server Database to an Azure virtual machine
81(6)
Generate benchmark data for performance needs
87(2)
Perform performance tuning on Azure IaaS
89(2)
Support availability sets in Azure
91(1)
Thought experiment
92(1)
Thought experiment answers
92(1)
Chapter summary
93(2)
Chapter 2 Manage databases and instances
95(94)
Skill 2.1 Configure secure access to Microsoft Azure SQL databases
95(44)
Configure firewall rules
96(10)
Configure Always Encrypted for Azure SQL Database
106(21)
Configure Dynamic Data Masking
127(8)
Configure Transparent Data Encryption
135(4)
Skill 2.2 Configure SQL Server performance settings
139(32)
Configure database performance settings
140(14)
Configure max server memory
154(3)
Configure the database scope
157(6)
Configure operators and alerts
163(8)
Skill 2.3 Manage SQL Server instances
171(18)
Manage files and filegroups
171(6)
Create databases
177(4)
Manage system database files
181(2)
Configure TempDB
183(3)
Thought Experiment
186(1)
Thought experiment answers
187(1)
Chapter summary
187(2)
Chapter 3 Manage Storage
189(88)
Skill 3.1 Manage SQL Storage
189(52)
Manage SMB file shares
190(5)
Manage stretch databases
195(12)
Configure Azure storage
207(11)
Change service tiers
218(5)
Review wait statistics
223(4)
Manage storage pools
227(11)
Recover from failed storage
238(3)
Skill 3.2 Perform database maintenance
241(36)
Monitor DMVs
241(8)
Maintain indexes
249(9)
Automate maintenance tasks
258(5)
Update statistics
263(3)
Verify database integrity
266(3)
Recover from database corruption
269(4)
Thought experiment
273(1)
Thought experiment answers
273(1)
Chapter summary
274(3)
Index 277
Joseph DAntoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry & Associates and lives in Malvern, PA.

Scott Klein loves data. His passion for data brought him to Cloud and Devices where he continues to help developers and companies grok the benefits of cloud computing.