Administering Microsoft Azure SQL Solutions : Hands-on Preparation and Practice for Exam DP-300 / by Geoff Hiten.

Format:

Book

Author/Creator:

Hiten, Geoff.

Series:

Certification Study Companion Series, 2731-877X

Language:

English

Subjects (All):

Database management--Examinations--Study guides.

Database management.

Microsoft Azure (Computing platform)--Examinations--Study guides.

Microsoft Azure (Computing platform).

SQL (Computer program language)--Examinations--Study guides.

SQL (Computer program language).

Physical Description:

1 online resource (317 pages)

Edition:

1st ed. 2025.

Place of Publication:

Berkeley, CA : Apress : Imprint: Apress, 2025.

Summary:

Ace the DP-300 Exam with this essential study companion, chock-full of insights and tips you cannot find online. This book will help you build a comprehensive understanding of Azure SQL systems and their role in supporting business solutions, and it will equip you with the mental models and technical knowledge needed to confidently answer exam questions. Structured to align with Microsoft’s published study guide, the book spans five major sections that correspond to the skills measured by the exam, covering topics vital to modern cloud operations and including HA/DR, security, compliance, performance, and scalability. You’ll also learn about the ways cloud operations have changed the focus of operating database systems from task execution to platform configuration—and how to configure your data platforms to meet this new reality. By the end of this book, you’ll be prepared to navigate exam scenarios with finesse, pass the exam with confidence, and advance in your career with a solid foundation of knowledge. What You Will Learn Maximize your ability to benefit from the online learning tools for Exam DP-300 Gain depth and context for Azure SQL technical solutions relevant to Exam DP-300 Boost your confidence in Azure SQL Database skills Extend your on-premises SQL Server skill set into the Azure SQL cloud Enhance your overall understanding of Azure SQL administration and operations Develop your Azure SQL skill set to increase your value as an employee or contractor Adopt a new mindset for cloud-based solutions versus on-premises solutions .

Contents:

1. About the DP-300 Exam, this book, and Azure

Part 1: Plan and Implement Azure SQL Data Platform Resources

2. Plan and Implement Azure SQL Database Solutions

3. Configure Resources for Scale and Performance

4. Plan and Implement a Migration Strategy

Part 2: Implement a Secure Environment

5. Configure Database Authentication and Authorization

6. Implement Security for Data at Rest and Data in Transit

7. Implement Compliance Controls for Sensitive Data

Part 3: Monitor, Configure, and Optimize Database Resources

8. Monitor Resource Activity and Performance

9. Monitor and Optimize Query Performance

10. Configure Database Solutions for Optimal Performance

Part 4: Configure and Manage Automation

11. Create and Manage SQL Agent Jobs

12. Automate Deployment of Database Resources

13. Create and Manage Database Tasks in Azure

Part 5: Plan and Configure a High Availability and Disaster Recovery (HA/DR) Environment

14. Recommend a HA/DR Strategy for Database Solutions

15. Plan and Perform Backup and Restore of a Database

16. Configure HA/DR for Database Solutions.

Notes:

Description based on publisher supplied metadata and other sources.

ISBN:

979-88-6881-585-0

OCLC:

1543045943