وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

DP-300 Exam Preparation: Introduction

سرفصل های دوره

1. DP-300 Exam Preparation Introduction
  • Learning Path Introduction

  • 2. Implementing Azure SQL Databases
  • 1. Course Introduction
  • 2. Overview
  • 3. High Availability and Disaster Recovery Concepts
  • 4. Hyperscale
  • 5. Combining On-Premises with the Cloud
  • 6. Always On Availability Groups
  • 7. Failover in the Cloud
  • 8. Database Backups
  • 9. Course Summary

  • 3. Azure SQL and SQL Server Database Monitoring
  • 1. Course Introduction
  • 2. Baseline
  • 3. What to Capture
  • 4. Intelligent Performance
  • 5. Intelligent Insights
  • 6. Consuming Insights
  • 7. DEMO- Streaming Intelligent Insights to Azure SQL Analytics
  • 8. SQL Server Management Studio Reports
  • 9. Wait Statistics
  • 10. Common Wait Types
  • 11. Index & Statistics Maintenance
  • 12. Monitor Storage
  • 13. Alerts
  • 14. DEMO- Disk Space Alert
  • 15. DEMO- Database Mail
  • 16. Course Summary

  • 4. Azure SQL and SQL Server Database Task Automation
  • 1. Course Introduction
  • 2. Database Maintenance
  • 3. Data Maintenance and Recurring Data
  • 4. Maintenance Plans
  • 5. DEMO Maintenance Wizard
  • 6. New Maintenance Plan
  • 7. SQL Agent Jobs
  • 8. DEMO Importing Data
  • 9. Automation Across Servers
  • 10. DEMO SQL Multi-Server Administration
  • 11. SQL Server Policy Management
  • 12. DEMO Policy Management
  • 13. Recovery Services Vault
  • 14. DEMO Recovery Services Vault
  • 15. Microsoft Azure Backup Service
  • 16. Azure Automation Service
  • 17. DEMO Azure Automation Service
  • 18. Elastic Jobs
  • 19. DEMO Elastic Jobs
  • 20. Automated Tuning
  • 21. Automated Patching
  • 22. Course Summary

  • 5. Azure Database Performance Tuning
  • 1. Introduction
  • 2. Overview
  • 3. Storage Performance
  • 4. Disk Performance
  • 5. Disk Caching
  • 6. Disk Striping
  • 7. File Performance
  • 8. Instant File Initialization
  • 9. Temporary Disk and TempDB
  • 10. Virtual Machine Size
  • 11. Managing an Instances Resources
  • 12. SQL Server System Accounts
  • 13. Database Configuration
  • 14. Intelligent Query Processing
  • 15. Azure SQL Serverless
  • 16. Summary

  • 6. Azure SQL and SQL Server Query Performance Tuning
  • 1. Course Introduction
  • 2. Overview
  • 3. Query Processing
  • 4. Query Plans
  • 5. Query the Query Store
  • 6. DEMO Hint at an Index
  • 7. Index Types
  • 8. Table Designs
  • 9. Columnstore Index
  • 10. Storage
  • 11. Compression
  • 12. Course Summary

  • 7. Implementing High Availability and Disaster Recovery for Azure SQL Databases
  • 1. Course Introduction
  • 2. Overview
  • 3. High Availability and Disaster Recovery Concepts
  • 4. Hyperscale
  • 5. Combining On-Premises with the Cloud
  • 6. Always On Availability Groups
  • 7. Failover in the Cloud
  • 8. Database Backups
  • 9. Course Summary

  • 8. Implementing Azure SQL Data Security
  • 1. Course Introduction
  • 2. Course Overview
  • 3. Azure SQL Firewall Rules
  • 4. DEMO Vnet to Vnet and Azure Data Gateway
  • 5. Azure SQL Disk Encryption
  • 6. Azure SQL Transparent Data Encryption
  • 7. Azure SQL Column Encryption
  • 8. Azure SQL Advanced Data Security
  • 9. Azure SQL Track Data Changes
  • 10. Summary

  • 9. Azure Database Authentication and Access
  • 1. Course Introduction
  • 2. Overview
  • 3. Why Use Azure Active Directory Authentication
  • 4. Implementing Azure Active Directory Authentication
  • 5. Setting the Active Directory Admin
  • 6. Create an Azure Active Directory User
  • 7. Managed Identity
  • 8. What Weve Learned in the Demos
  • 9. Database Roles
  • 10. The Principle of Least Privilege
  • 11. Permissions on Objects
  • 12. Managing Permissions with the SSMS GUI
  • 13. Course Summary

  • 10. Azure SQL - Designing and Implementing a Migration Plan
  • 1. Azure SQL Designing and Implementing a Migration Plan - Introduction
  • 2. Evaluating Your Current Database Environment
  • 3. Migration Scenarios
  • 4. Data Transfer
  • 5. Azure Migrate
  • 6. Data Migration Service Demo
  • 7. Data Migration Assistant Assessment Demo
  • 8. Data Migration Assistant Migration Demo
  • 9. SQL Server Migration Assistant Demo
  • 10. MySQL Migration Demo
  • 11. Azure SQL Designing and Implementing a Migration Plan - Summary
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    مدرس:
    شناسه: 36070
    حجم: 10961 مگابایت
    مدت زمان: 521 دقیقه
    تاریخ انتشار: ۲۰ مرداد ۱۴۰۳
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید