Corso attualmente non disponibile
Designing a Data Solution with Microsoft SQL Server
Corso
Online
Descrizione
-
Tipologia
Corso
-
Metodologia
Online
Valutare un ambiente aziendale esistente.
Pianificare e attuare gestione basata su criteri.
Descrivere le considerazioni per il consolidamento dei carichi di lavoro con SQL Server 2014.
Descrivere le considerazioni per l'inclusione di SQL Server 2014 in un cloud privato.
Utilizzare archiviazione Windows Azure con SQL Server 2014.
Implementare e configurare database in SQL Azure.
Implementare e configurare database nelle macchine virtuali Windows Azure.
Descrivere le tecnologie ad alta disponibilità in SQL Server 2014 e attuare il log shipping.
Descrivere Windows Server Failover Clustering e implementare un un'istanza del cluster di failover AlwaysOn.
Implementare un gruppo di disponibilità Always On.
Pianificare elevata disponibilità e soluzioni di disaster recovery.
Pianificare e implementare la replica del database.
Profilo del corso
Professionista IT
Questo corso richiede che siano soddisfatti i seguenti requisiti:Almeno 2 anni di esperienza di lavoro con i database relazionali, tra cui:Pianificazione e implementazione dei databaseGestione dei databaseInterrogazione con Transact-SQLAlcune conoscenze di base di alta disponibilità e disaster recoveryAlcune conoscenze di base delle tecnologie di Windows Azure e concetti intorno cloud computing
Visita il sito Internet
Opinioni
Successi del Centro
Tutti i corsi devono essere aggiornati
La media delle valutazioni dev'essere superiore a 3,7
Più di 50 opinioni degli ultimi 12 mesi
6 anni del centro in Emagister.
Materie
- SQL
- Testing
- Windows
- Informatica e tecnologia
- Windows Server
- Management
- Clustering
- Microsoft SQL Server
- Security
- Information tecnology
- Server
- Windows Server 2008
- Informatica
- SQL Server 2014
- Azure SQL Database
Programma
CONTENUTI:
Module 1: Introduction to Enterprise Data Architecture
Considerations for Enterprise Data
Assessing an Existing Infrastructure
Lab : Assessing an Existing Enterprise Data Infrastructure
Using the MAP Toolkit
Reviewing MAP Toolkit Reports
Module 2: Multi-Server Configuration Management
Policy-Based Management
Microsoft System Center
Lab : Planning and Implementing Policy-Based Management
Planning a Policy-Based Management Strategy
Implementing Policy-Based Management
Testing Policy Compliance
Module 3: Consolidating Database Workloads with SQL Server 2014
Considerations for Database Server Consolidation
Managing Resources in a Consolidated Database Infrastructure
Lab : SQL Server Consolidation
Preparing for Database Consolidation
Managing Resources for an Instance of SQL Server
Managing Resources for Multiple Instances on a Windows Server
Module 4: Introduction to Cloud Data Solutions
Overview of Cloud Computing
SQL Server in a Private Cloud
Lab : Preparing a SQL Server Installation in a Virtual Machine Template
Creating a prepared Instance
Completing a prepared Instance
Module 5: Introduction to Windows Azure
Windows Azure Overview
Windows Azure Storage
Lab : Using Windows Azure
Creating a Windows Azure Storage Account
Backing Up a Database to Windows Azure
Module 6: Windows Azure SQL Database
Introduction to Windows Azure SQL Database
Windows Azure SQL Database Security
Implementing and Managing Databases
Lab : Using Windows Azure SQL Database
Provisioning Windows Azure SQL Database
Configuring Windows Azure SQL Database Security
Migrating a Database to Windows Azure SQL Database
Module 7: SQL Server in Windows Azure Virtual Machines
Introduction to Windows Azure Virtual Machines
Windows Azure Virtual Machine Connectivity and Security
Creating Databases in a Windows Azure Virtual Machine
Lab : Using Windows Azure Virtual Machines
Creating a Windows Azure Virtual Machine
Configuring Windows Azure Virtual Machines Security and Connectivity
Creating Databases on a Virtual Machine
Module 8: Introduction to High Availability in SQL Server 2014
High Availability Concepts and Options in SQL Server 2014
Log Shipping
Lab : Using Log Shipping
Configure Log Shipping
Test the Log Shipping Configuration
Test Failover
Module 9: Clustering with Windows Server and SQL Server 2014
Introduction to Windows Server Failover Clustering
SQL Server AlwaysOn Failover Cluster Instances
Lab : Implementing an AlwaysOn Failover Cluster Instance
Inspect the Windows Server Failover Cluster Configuration
Install an AlwaysOn Failover Cluster Instance
Configure tempdb to Use Local Storage
Test Automatic Failover and Failback
Module 10: AlwaysOn Availability Groups
Introduction to AlwaysOn Availability Groups
Working with AlwaysOn Availability Groups
Considerations for Using AlwaysOn Availability Groups
Lab : Implementing and Testing an AlwaysOn Availability Group
Implementing an AlwaysOn Availability Group
Connecting to an AlwaysOn Availability Group
Testing Failover
Configure Quorum Voting
Module 11: Planning High Availability and Disaster Recovery
High Availability and Disaster Recovery with SQL Server 2014
High Availability and Disaster Recovery for Databases in Windows Azure
Lab : Planning High Availability and Disaster Recovery
Planning High Availability and Disaster Recovery Solutions with SQL Server 2014
Planning High Availability and Disaster Recovery Solutions by Using Windows Azure
Module 12: Replicating Data
SQL Server Replication
Planning Replication
Lab : Planning and Implementing Replication
Planning Replication
Implementing Replication
Ulteriori informazioni
Designing a Data Solution with Microsoft SQL Server