LO035417 Professional Azure SQL Database Administration

    This is a 3-day course which balances theory and hand-on applications that are focused on practical takeaways to learn Azure SQL Database.
    This course complies with instructional designing principles for all the 9 lessons. This will ensure that you repeat and reinforce your gained knowledge at every step. Each and every minute spent during this 3-day course will incrementally take you to a next level.

    COURSE OBJECTIVE:
    If you are interested in developing new or migrating existing applications with Azure SQL Database, then this course is for you.

    The course will provide enough knowledge of the following:

    • Provision a new Azure SQL Database or Migrate an existing on-premise SQL Server database to Azure SQL Database
    • Backup and restore Azure SQL Database
    • Secure and scale an Azure SQL Database
    • Monitor and tune an Azure SQL Database
    • Implement high availability and disaster recovery with Azure SQL Database
    • Automate common management tasks with PowerShell
    • Develop a scalable cloud solution with SQL Database

     

    TARGET AUDIENCE:
    This course is for database administrators, database developers, or application developers interested in developing new or migrating existing applications with Azure SQL Database.
    Prior experience of working on an on-premises SQL Server, and should have knowledge of PowerShell and C# are the prerequisites for this course.

    COURSE PREREQUISITES:
    Hardware:

    For successful completion of this course, students will require computer systems with the following:

    • Intel Core i5 or equivalent Processor: i3
    • Memory: 8 GB RAM
    • Hard disk: 20 GB
    • Projector
    • Internet connection
    Software:

    • OS: Windows 8 or above
    • Browser: Latest version of Google Chrome
    • SQL Server Management Studio 17.2 or above
    • Microsoft Azure PowerShell
    • Microsoft RML Utilities
    • Microsoft® Data Migration Assistant v3.4
    • SQL Server 2016 Feature pack

    COURSE CONTENT:
    Microsoft Azure SQL Database Primer

    • Azure SQL Database Architecture
    Migrating an SQL Server Database to an Azure SQL Database

    • Azure SQL Database Service Tiers
    • Determining an Appropriate Service Tier
    • Determining Compatibility Issues
    • Determining the Migration Method
    Backing up the SQL Database

    • Automatic Backups
    • Manual Backups
    Restoring an Azure SQL Database

    • Restore Types
    Securing an Azure SQL Database

    • Access Control
    • Proactive Security
    • Scaling Out Azure SQL Database
    • Vertical Scaling
    • Horizontal Scaling
    Elastic Pools

    • Introducing Elastic Pools
    • Elastic Jobs
    High Availability and Disaster Recovery

    • High Availability
    • Disaster Recovery
    Monitoring and Tuning Azure SQL Database

    • Monitoring an Azure SQL Database Using the Azure Portal
    • Tuning an Azure SQL Database

    FOLLOW ON COURSES:
    Not available. Please contact.

    Tilleggsinformasjon

    Varighet

    3 dag(er)

    Språk

    Engelsk/Norsk kursmateriell, Engelsk/Norsk kursholder

    Sted

    Virtuelt (90% av våre kurs blir tatt opp)/Vi setter opp kurs over hele landet