Acest curs va fi retras din portofoliul vendorului Microsoft la data 31 DECEMBRIE 2021. Până atunci poate fi livrat la cerere, în condiții speciale. Vă invităm pe pagina Vendorului Microsoft pentru a descoperi cursurile actuale și planurile de creștere în carieră în funcție de tehnologiile vizate.

Microsoft 20465 – Designing a Data Solution with Microsoft SQL Server

In this course you will learn how to plan and implement enterprise database infrastructure solutions making use of Microsoft SQL Server 2012 and 2014.

You will also take a look at Enterprise Data Architecture along with multi-server configuration management.

Other topics covered in this course include consolidating database workloads, cloud data, Microsoft Azure services, high availability, clustering AlwaysOn Availability, disaster recovery and data replication.

Cui i se adresează?

This course is aimed at anyone whose responsibilities include designing database solutions.

Ce vei învăța?

Upon completion you will know how to:

Access an Existing Enterprise Environment
Plan and Implement Policy-Based Management
Consolidation Workloads
Private Cloud Considerations
Microsoft Azure Storage
Implement and Configure Databases in Microsoft Azure Database and in Microsoft Azure Virtual Machines
Windows Server Failover Clustering and AlwaysOn Failover Cluster Instance
AlwaysOn Availability Groups Implementation
High Availability and Disaster Recovery Solutions
Plan and Implement Database Replication

Cerințe preliminare:

Students need to have:

You should have technical knowledge of relational databases, including
Database planning, implementation, and management
Querying with Transact-SQL
Basic knowledge of high availability, disaster recovery, and Microsoft Azure technologies around cloud computing
Administering Microsoft SQL Server 2012 Databases (M10775)
Developing Microsoft SQL Server 2012 Databases (M10776)

Agenda cursului:

Materialele de curs sunt în limba Engleză. Predarea se face în limba Română.

Agenda cursului:

Materialele de curs sunt în limba Engleză. Predarea se face în limba Română.

1. Introduction to Enterprise Data Architecture

Enterprise Data Considerations
Access an Existing Infrastructure

2. Multi-Server Configuration Management

Policy-based Management
Microsoft System Center

3. Consolidate Database Workloads with SQL Server 2014

Database Server Consolidation Considerations
Resource Management in a Consolidated Database Infrastructure

4. Introduction to Cloud Data Solutions

Cloud Computing
SQL Server in a Private Cloud

5. Introduction to Microsoft Azure

Microsoft Azure Overview and Microsoft Storage

6. Microsoft Azure SQL Database

Introduction to Microsoft Azure SQL Database
Microsoft Azure SQL Database Security
Implement and Manage Databases

7. SQL Server in Microsoft Azure Virtual Machines

Introduction to Microsoft Azure Virtual Machines
Microsoft Azure Virtual Machine Connectivity and Security
Create Databases in a Microsoft Azure Virtual Machine

8. Introduction to High Availability in SQL Server 2014

High Availability Concepts and Options in SQL Server 2014
Log Shipping

9. Clustering with Windows Server and SQL Server 2014

Introduction to Windows Server Failover Clustering
SQL Server AlwaysOn Failover Cluster Instances

10. Automating Multi-Server Maintenance AlwaysOn Availability Groups

AlwaysOn Availability Groups Introduction and Considerations

11. Plan High Availability and Disaster Recover

High Availability and Disaster Recovery with SQL Server 2014
High Availability and Disaster Recovery for Databases in Microsoft Azure

12. Replicating Data

SQL Server Replication
Planning Replication

Este recomandat să continui cu:

Nu există cursuri recomandate după finalizarea acestui curs.

Programe de certificare

MCSE: Data Platform