Administering Microsoft Azure SQL Solutions
Apress (Verlag)
979-8-8688-1584-3 (ISBN)
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
Who This Book Is For
Anyone planning to take the DP-300: Administering Microsoft Azure SQL Solutions exam, and those who wish to understand Azure SQL and how to successfully migrate and manage SQL solutions using all Azure SQL Technologies
Geoff Hiten began his SQL journey with Microsoft SQL Server version 4.2 for Windows NT in 1993 and hasn’t had the good sense to find an easier way to earn a living. Prior to that, he worked on dBase and other ISAM data systems. Geoff is a graduate of the University of Alabama (also in 1993), He has worked for many different organizations, managing their SQL Infrastructure. He built his first production SQL Cluster in 2002 using Microsoft SQL Server 2000. In 2005, in recognition of his SQL community leadership and involvement, Geoff was invited to become a Microsoft SQL (later Data Platform) MVP. That recognition lasted until 2018 when he joined Microsoft. In 2007, Geoff got tired of filling out new W-4 forms when finding new SQL problems and started working as a consultant. He now advises Microsoft customers on how to understand and adopt Azure SQL technologies as a Senior Data & AI Technical Specialist.
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.
| Erscheinungsdatum | 13.06.2025 |
|---|---|
| Reihe/Serie | Certification Study Companion Series |
| Zusatzinfo | 141 Illustrations, color; 2 Illustrations, black and white |
| Verlagsort | Berkley |
| Sprache | englisch |
| Maße | 178 x 254 mm |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| Informatik ► Weitere Themen ► Zertifizierung | |
| Schlagworte | authentication and authorization • Azure SQL • backup and recovery • Database Performance • Data Engineerng • Data Security • Disaster Recovery • DP-300 • High Availability • Microsoft Azure • query optimization • Regulatory Compliance • resource optimization • SQL Agent • SQL Server |
| ISBN-13 | 979-8-8688-1584-3 / 9798868815843 |
| Zustand | Neuware |
| Informationen gemäß Produktsicherheitsverordnung (GPSR) | |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
