MCSEClasses Certification Training Boot Camp MCSE MCSD MCDBA Cisco CIW Linux Oracle Java Security Military Discounts Testimonials About Us Linux/Unix Certification MCSD Certification Home MCSE Certification MCDBA Certification Cisco Certification Security Certification Java Certification Oracle® Certification CIW Certification Jobs Boot Camp Financing Boot Camp Pricing Boot Camp Technical Schedule Contact Us

MCA Microsoft Course DP-300: Administering Relational Databases on Microsoft Azure

Course Length: 4 days
Certifications: Microsoft MCA Certified: Azure Database Administrator Associate
Number of Exams: 1

Class Schedule
Call for Class Schedule
  • Hands-on instruction by a certified instructor
  • Includes all course materials
  • Exam DP-300: The Azure Database Administrator implements and manages the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server.

    The Azure Database Administrator uses a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

    Skills measured

    • Plan and implement data platform resources
    • Implement a secure environment
    • Monitor and optimize operational resources
    • Optimize query performance
    • Perform automation of tasks
    • Plan and implement a High Availability and Disaster Recovery (HADR) environment
    • Perform administration by using T-SQL

    Course outline

    Plan and Implement Data Platform Resources

    Deploy resources by using manual methods
    • deploy database offerings on selected platforms
    • configure customized deployment templates
    • apply patches and updates for hybrid and IaaS deployment
    Recommend an appropriate database offering based on specific requirements
    • evaluate requirements for the deployment
    • evaluate the functional benefits/impact of possible database offerings
    • evaluate the scalability of the possible database offering
    • evaluate the HA/DR of the possible database offering
    • evaluate the security aspects of the possible database offering
    Configure resources for scale and performance
    • configure Azure SQL database/elastic pools for scale and performance
    • configure Azure SQL managed instances for scale and performance
    • configure SQL Server in Azure VMs for scale and performance
    • calculate resource requirements
    • evaluate database partitioning techniques, such as database sharding
    Evaluate a strategy for moving to Azure
    • evaluate requirements for the migration
    • evaluate offline or online migration strategies
    • evaluate requirements for the upgrade
    • evaluate offline or online upgrade strategies
    Implement a migration or upgrade strategy for moving to Azure
    • implement an online migration strategy
    • implement an offline migration strategy
    • implement an online upgrade strategy
    • implement an offline upgrade strategy

    Implement a Secure Environment

    Configure database authentication by using platform and database tools
    • configure Azure AD authentication
    • create users from Azure AD identities
    • configure security principals
    Configure database authorization by using platform and database tools
    • configure database and object-level permissions using graphical tools
    • apply principle of least privilege for all securables
    Implement security for data at rest
    • implement Transparent Data Encryption (TDE)
    • implement object-level encryption
    • implement Dynamic Data Masking
    • implement Azure Key Vault and disk encryption for Azure VMs
    Implement security for data in transit
    • configure SQL DB and database-level firewall rules
    • implement Always Encrypted
    • configure Azure Data Gateway
    Implement compliance controls for sensitive data
    • apply a data classification strategy
    • configure server and database audits
    • implement data change tracking
    • perform vulnerability assessment

    Monitor and Optimize Operational Resources

    Monitor activity and performance
    • prepare an operational performance baseline
    • determine sources for performance metrics
    • interpret performance metrics
    • assess database performance by using Azure SQL Database Intelligent Performance
    • configure and monitor activity and performance at the infrastructure, server, service, and database levels
    Implement performance-related maintenance tasks
    • implement index maintenance tasks
    • implement statistics maintenance tasks
    • configure database auto-tuning
    • automate database maintenance tasks
    • manage storage capacity
    Identify performance-related issues
    • configure Query Store to collect performance data
    • identify sessions that cause blocking
    • assess growth/fragmentation of databases and logs
    • assess performance-related database configuration parameters
    Configure resources for optimal performance
    • configure storage and infrastructure resources
    • configure server and service account settings for performance
    • configure Resource Governor for performance
    Configure a user database for optimal performance
    • implement database-scoped configuration
    • configure compute resources for scaling
    • configure Intelligent Query Processing (IQP)

    Optimize Query Performance

    Review query plans
    • determine the appropriate type of execution plan
    • identify problem areas in execution plans
    • extract query plans from the Query Store
    Evaluate performance improvements
    • determine the appropriate Dynamic Management Views (DMVs) to gather query performance information
    • identify performance issues using DMVs
    • identify and implement index changes for queries
    • recommend query construct modifications based on resource usage
    • assess the use of hints for query performance
    Review database table and index design
    • identify data quality issues with duplication of data
    • identify normal form of database
    • assess index design for performance
    • validate data types defined for columns
    • recommend table and index storage including filegroups
    • evaluate table partitioning strategy
    • evaluate the use of compression for tables and indexes

    Perform Automation of Tasks

    Create scheduled tasks
    • manage schedules for regular maintenance jobs
    • configure multi-server automation
    • configure notifications for task success/failure/non-completion
    Evaluate and implement an alert and notification strategy
    • create event notifications based on metrics
    • create event notifications for Azure resources
    • create alerts for server configuration changes
    • create tasks that respond to event notifications
    Manage and automate tasks in Azure
    • perform automated deployment methods for resources
    • automate Backups
    • automate performance tuning and patching
    • implement policies by using automated evaluation modes

    Plan and Implement a High Availability and Disaster Recovery (HADR) Environment

    Recommend an HADR strategy for a data platform solution
    • recommend HADR strategy based on RPO/RTO requirements
    • evaluate HADR for hybrid deployments
    • evaluate Azure-specific HADR solutions
    • identify resources for HADR solutions
    Test an HADR strategy by using platform, OS and database tools
    • test HA by using failover
    • test DR by using failover or restore
    Perform backup and restore a database by using database tools
    • perform a database backup with options
    • perform a database restore with options
    • perform a database restore to a point in time
    • configure long-term backup retention
    Configure DR by using platform and database tools
    • configure replication
    • configure Azure Site Recovery for a database offering
    Configure HA using platform, OS and database tools
    • create an Availability Group
    • integrate a database into an Availability Group
    • configure quorum options for a Windows Server Failover Cluster
    • configure an Availability Group listener

    Perform Administration by Using T-SQL

    Examine system health
    • evaluate database health using DMVs
    • evaluate server health using DMVs
    • perform database consistency checks by using DBCC
    Monitor database configuration by using T-SQL
    • assess proper database autogrowth configuration
    • report on database free space
    • review database configuration options
    Perform backup and restore a database by using T-SQL
    • prepare databases for AlwaysOn Availability Groups
    • perform transaction log backup
    • perform restore of user databases
    • perform database backups with options
    Manage authentication by using T-SQL
    • manage certificates
    • manage security principals
    Manage authorization by using T-SQL
    • configure permissions for users to access database objects
    • configure permissions by using custom roles is your best choice for DP-300, DP-300 training, DP-300 certification, DP-300 certification boot camp, DP-300 boot camp, DP-300 certification training, DP-300 boot camp training, DP-300 boot camp certification, DP-300 certification course, DP-300 course, training DP-300, certification DP-300, boot camp DP-300, certification DP-300 boot camp, certification DP-300 training, boot camp DP-300 training, certification DP-300 course.

    mcseclasses home | technical schedule | application schedule | class outlines | mcse, mcdba, mcsd training | microsoft .net | cisco certification | security training | ced solutions oracle® certification training | linux, unix, aix | comptia certification | webmaster training | pricing | locations | financing | instructors needed | e-mail us

    Search classes by keyword:

    Search classes by category:

    Copyright © 2021 CED Solutions. CED Solutions Refund Policy. All Rights Reserved.

    MCSE certification boot camps and courses are offered in these select cities: Albany MCSE, Albuquerque MCSE, Alexandria MCSE, Anchorage MCSE, Atlanta MCSE, Austin MCSE, Billings MCSE, Birmingham MCSE, Bismarck MCSE, Boise MCSE, Boston MCSE, Charleston MCSE, Charlotte MCSE, Cheyenne MCSE, Chicago MCSE, Cincinnati MCSE, Cleveland MCSE, Columbia MCSE, Columbus MCSE, Dallas MCSE, Denver MCSE, Des Moines MCSE, Detroit MCSE, Hartford MCSE, Honolulu MCSE, Houston MCSE, Indianapolis MCSE, Jackson MCSE, Kansas City MCSE, Las Cruces MCSE, Lincoln MCSE, Little Rock MCSE, Los Angeles MCSE, Louisville MCSE, Madison MCSE, Milwaukee MCSE, Minneapolis MCSE, Montpelier MCSE, New Orleans MCSE, New York City MCSE, Norfolk MCSE, Oklahoma City MCSE, Omaha MCSE, Philadelphia MCSE, Phoenix MCSE, Pierre MCSE, Pittsburgh MCSE, Portland MCSE, Princeton MCSE, Providence MCSE, Raleigh MCSE, Richmond MCSE, Sacramento MCSE, Salt Lake City MCSE, San Antonio MCSE, San Diego MCSE, San Francisco MCSE, San Jose MCSE, Seattle MCSE, Stamford MCSE, Tulsa MCSE, Washington MCSE, Wilmington MCSE.

    MCSE Canada Boot Camps : mcse Calgary, mcse Edmonton, mcse Halifax, mcse Hamilton, mcse Kitchener, mcse London, mcse Montreal, mcse Ottawa, mcse Quebec City, mcse Toronto, mcse Vancouver, mcse Winnipeg.

    CED Solutions offers MCSE certification boot camps and courses in the United States: MCSE Alabama, MCSE Alaska, MCSE Arizona, MCSE Arkansas, MCSE California, MCSE Colorado, MCSE Connecticut, MCSE District of Columbia, MCSE Delaware, MCSE Georgia, MCSE Hawaii, MCSE Idaho, MCSE Illinois, MCSE Indiana, MCSE Iowa, MCSE Kansas, MCSE Kentucky, MCSE Louisiana, MCSE Maine, MCSE Massachusetts, MCSE Michigan, MCSE Minnesota, MCSE Mississippi, MCSE Missouri, MCSE Montana, MCSE Nebraska, MCSE New Jersey, MCSE New Mexico, MCSE New York, MCSE North Carolina, MCSE North Dakota, MCSE Ohio, MCSE Oklahoma, MCSE Oregon, MCSE Pennsylvania, MCSE Rhode Island, MCSE South Carolina, MCSE South Dakota, MCSE Texas, MCSE Utah, MCSE Vermont, MCSE Virginia, MCSE Washington, MCSE West Virginia, MCSE Wisconsin, MCSE Wyoming.

    MCSE Canada Boot Camps : Alberta mcse, British Columbia mcse, Manitoba mcse, New Brunswick mcse, Newfoundland mcse, Nova Scotia mcse, Ontario mcse, Saskatchewan mcse. Quebec mcse.