Cisco utbildning

Insoft Services är en av få utbildningsleverantörer inom EMEAR som erbjuder hela utbudet av Cisco-certifiering och specialiserad teknikutbildning.

Läs mer

Cisco-certifieringar

Upplev en blandad inlärningsmetod som kombinerar det bästa av instruktörsledd utbildning och e-lärande i egen takt för att hjälpa dig att förbereda dig för ditt certifieringsprov.

Läs mer

Cisco Learning Credits

Cisco Learning Credits (CLC) är förbetalda utbildningskuponger som löses in direkt med Cisco och som gör det enklare att planera för din framgång när du köper Ciscos produkter och tjänster.

Läs mer

Cisco Fortbildning

Ciscos fortbildningsprogram erbjuder alla aktiva certifikatinnehavare flexibla alternativ för att omcertifiera genom att slutföra en mängd olika kvalificerade utbildningsartiklar.

Läs mer

Cisco Digital Learning

Certifierade medarbetare är VÄRDERADE tillgångar. Utforska Ciscos officiella digitala utbildningsbibliotek för att utbilda dig själv genom inspelade sessioner.

Läs mer

Partner för affärsaktivering

Cisco Business Enablement Partner Program fokuserar på att vässa affärskunskaperna hos Cisco Channel Partners och kunder.

Läs mer

Cisco Kurskatalog

Läs mer

Fortinet-certifieringar

Fortinet Network Security Expert (NSE) -programmet är ett utbildnings- och certifieringsprogram på åtta nivåer för att lära ingenjörer om deras nätverkssäkerhet för Fortinet FW-färdigheter och erfarenheter.

Tekniska utbildningar

Tekniska utbildningar

Insoft är erkänt som Fortinet Authorized Training Center på utvalda platser i EMEA.

Läs mer

Fortinet Kurskatalog

Utforska ett brett utbud av Fortinet-scheman i olika länder samt onlinekurser.

Läs mer

ATC-status

Kolla in vår ATC-status i utvalda länder i Europa.

Läs mer

Fortinet Professionella tjänster

Globalt erkända team av certifierade experter hjälper dig att göra en smidigare övergång med våra fördefinierade konsult-, installations- och migreringspaket för ett brett utbud av Fortinet-produkter.

Läs mer

Microsoft-utbildning

Insoft Services tillhandahåller Microsoft-utbildning i EMEAR. Vi erbjuder Microsofts tekniska utbildnings- och certifieringskurser som leds av instruktörer i världsklass.

Tekniska utbildningar

Extreme-utbildning

Lär dig exceptionella kunskaper och färdigheter i Extreme Networks.

Technische Kurse

Tekniske-certifieringar

Vi tillhandahåller omfattande läroplan för tekniska kompetensfärdigheter på certifieringsprestationen.

Läs mer

Extreme Kurskatalog

Hier finden Sie alle Extreme Networks online und den von Lehrern geleiteten Kalender für den Klassenraum.

Läs mer

ATP-ackreditering

Som auktoriserad utbildningspartner (ATP) säkerställer Insoft Services att du får de högsta tillgängliga utbildningsstandarderna.

Läs mer

Konsultpaket

Vi erbjuder innovativt och avancerat stöd för att designa, implementera och optimera IT-lösningar.Vår kundbas inkluderar några av de största telekombolagen globalt.

Lösningar och tjänster

Globalt erkända team av certifierade experter hjälper dig att göra en smidigare övergång med våra fördefinierade konsult-, installations- och migreringspaket för ett brett utbud av Fortinet-produkter.

Om oss

Insoft Tillhandahåller auktoriserade utbildnings- och konsulttjänster för utvalda IP-leverantörer.Lär dig hur vi revolutionerar branschen.

Läs mer
  • +46 8 502 431 88
  • Professional SQL Server High Availability and Disaster Recovery

    Duration
    3 Dagar
    Delivery
    (Online och på plats)
    Price
    Pris på begäran
    The Professional SQL Server High Availability and Disaster Recovery training course explain the High Availability (HA) and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. In this course, you'll learn what they are, how to monitor them, and how to troubleshoot any related problems. You will be introduced to the availability groups of AlwaysOn and learn how to configure them to extend your database mirroring. Through this course, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies. By the end of the course, you'll be equipped with all that you need to know to develop a robust and high-performance infrastructure.   See other courses available

    After completing this course, you will be able to:

    • Configure and troubleshoot replication, AlwaysOn, and log shipping
    • Study the best practices to implement HA and DR solutions
    • Design HA and DR topologies for the SQL Server and study how to choose a topology for your environment
    • Use T-SQL to configure replication, AlwaysOn, and log shipping
    • Migrate from on-premises SQL Server to Azure SQL Database
    • Manage and maintain AlwaysOn availability groups for extended database mirroring

    Lesson 1: Getting Started with SQL Server HA and DR

    • What is High Availability and Disaster Recovery?
    • HA and DR Terminologies
    • SQL Server HA and DR Solutions
    • Introduction to SQL Server Replication
    • Types of Replication
    • Configuring Snapshot Replication Using SQL Server Management Studio
    • Optimizing Snapshot Replication

    Lesson 2: Transactional Replication

    • Understanding Transactional Replication
    • Configuring Transactional Replication
    • Azure SQL Database as a Subscriber in Transaction Replication
    • Understanding Peer-To-Peer Transactional Replication
    • Configuring Peer-To-Peer Transactional Replication
    • Modifying an Existing Publication

    Lesson 3: Monitoring Transactional Replication

    • The Replication Monitor
    • Real-World Transactional Replication Problems and Solutions
    • Conflicts in Peer-to-Peer Transactional Replication

    Lesson 4: AlwaysOn Availability Groups

    • AlwaysOn Availability Group Concepts and Terminology
    • AlwaysOn Availability Groups
    • Creating Hyper-V VMs
    • Active Directory Domain Controller
    • Installing the SQL Server Developer Edition
    • Windows Server Failover Cluster
    • Configuring AlwaysOn Availability Groups
    • AlwaysOn Availability Groups on Microsoft Azure

    Lesson 5: Managing AlwaysOn Availability Groups

    • AlwaysOn AG Failover
    • Managing AlwaysOn Availability Groups
    • Monitoring AlwaysOn Availability Groups
    • Troubleshooting AlwaysOn Availability Groups

    Lesson 6: Configuring and Managing Log Shipping

    • Configuring Log Shipping
    • Managing and Monitoring Log Shipping
    • Troubleshooting Common Log Shipping Issues
    • Comparing AlwaysOn, Replication, and Log Shipping

    This course is for you if you’re a database administrator or database developer who wants to improve the performance of your production environment.

    Prior experience of working with SQL Server will help you get the most out of this course.

     

    Hardware:

    For the optimal student experience, we recommend the following hardware configuration:

    • Processor: 1.8 GHz or higher Pentium 4 (or equivalent)
    • Memory: 8 GB RAM
    • Hard disk: 200 GB free space
    • An internet connection

    Software:

    • Operating System: Windows 8 or above
    • Internet Browser: Google Chrome (latest version)
    • An Azure subscription
    • SQL Server Management Studio 17.2 or above
    • PowerShell 5.1
    • SQL Server 2014 SP2 or above installed as named instance Server\SQL2014
    • SQL Server 2016 SP2 installed as named instance Server\SQL2016
    The Professional SQL Server High Availability and Disaster Recovery training course explain the High Availability (HA) and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. In this course, you'll learn what they are, how to monitor them, and how to troubleshoot any related problems. You will be introduced to the availability groups of AlwaysOn and learn how to configure them to extend your database mirroring. Through this course, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies. By the end of the course, you'll be equipped with all that you need to know to develop a robust and high-performance infrastructure.   See other courses available

    After completing this course, you will be able to:

    • Configure and troubleshoot replication, AlwaysOn, and log shipping
    • Study the best practices to implement HA and DR solutions
    • Design HA and DR topologies for the SQL Server and study how to choose a topology for your environment
    • Use T-SQL to configure replication, AlwaysOn, and log shipping
    • Migrate from on-premises SQL Server to Azure SQL Database
    • Manage and maintain AlwaysOn availability groups for extended database mirroring

    Lesson 1: Getting Started with SQL Server HA and DR

    • What is High Availability and Disaster Recovery?
    • HA and DR Terminologies
    • SQL Server HA and DR Solutions
    • Introduction to SQL Server Replication
    • Types of Replication
    • Configuring Snapshot Replication Using SQL Server Management Studio
    • Optimizing Snapshot Replication

    Lesson 2: Transactional Replication

    • Understanding Transactional Replication
    • Configuring Transactional Replication
    • Azure SQL Database as a Subscriber in Transaction Replication
    • Understanding Peer-To-Peer Transactional Replication
    • Configuring Peer-To-Peer Transactional Replication
    • Modifying an Existing Publication

    Lesson 3: Monitoring Transactional Replication

    • The Replication Monitor
    • Real-World Transactional Replication Problems and Solutions
    • Conflicts in Peer-to-Peer Transactional Replication

    Lesson 4: AlwaysOn Availability Groups

    • AlwaysOn Availability Group Concepts and Terminology
    • AlwaysOn Availability Groups
    • Creating Hyper-V VMs
    • Active Directory Domain Controller
    • Installing the SQL Server Developer Edition
    • Windows Server Failover Cluster
    • Configuring AlwaysOn Availability Groups
    • AlwaysOn Availability Groups on Microsoft Azure

    Lesson 5: Managing AlwaysOn Availability Groups

    • AlwaysOn AG Failover
    • Managing AlwaysOn Availability Groups
    • Monitoring AlwaysOn Availability Groups
    • Troubleshooting AlwaysOn Availability Groups

    Lesson 6: Configuring and Managing Log Shipping

    • Configuring Log Shipping
    • Managing and Monitoring Log Shipping
    • Troubleshooting Common Log Shipping Issues
    • Comparing AlwaysOn, Replication, and Log Shipping

    This course is for you if you’re a database administrator or database developer who wants to improve the performance of your production environment.

    Prior experience of working with SQL Server will help you get the most out of this course.

     

    Hardware:

    For the optimal student experience, we recommend the following hardware configuration:

    • Processor: 1.8 GHz or higher Pentium 4 (or equivalent)
    • Memory: 8 GB RAM
    • Hard disk: 200 GB free space
    • An internet connection

    Software:

    • Operating System: Windows 8 or above
    • Internet Browser: Google Chrome (latest version)
    • An Azure subscription
    • SQL Server Management Studio 17.2 or above
    • PowerShell 5.1
    • SQL Server 2014 SP2 or above installed as named instance Server\SQL2014
    • SQL Server 2016 SP2 installed as named instance Server\SQL2016
      Datum
      Datum på begäran

    Follow Up Courses

    Filtrera
    • 2 Dagar
      Datum på begäran
      Price on Request
      Book Now
    • 3 Dagar
      Datum på begäran
      Price on Request
      Book Now
    • 3 Dagar
      Datum på begäran
      Price on Request
      Book Now
    • 3 Dagar
      Datum på begäran
      Price on Request
      Book Now
    • 2 Dagar
      Datum på begäran
      Price on Request
      Book Now
    • 4 Dagar
      Datum på begäran
      Price on Request
      Book Now
    • 2 Dagar
      Datum på begäran
      Price on Request
      Book Now
    • 3 Dagar
      Datum på begäran
      Price on Request
      Book Now

    Know someone who´d be interested in this course?
    Let them know...

    Use the hashtag #InsoftLearning to talk about this course and find students like you on social media.