E-1379411

Provisioning Microsoft SQL Databases • E-learning

A tanfolyamot üzemeltetők, rendszergazdák, adatbázis adminisztrátorok, adatbázis tervezők részére ajánljuk, akiknek feladatuk lesz SQL Server 2016 rendszerek konfigurálása, üzemeltetése, adatbázisok menedzselése, mentése...stb.
Tananyag szintje
Közepes
Tananyag hossza
12 óra 38 perc
Elérhető képzési nyelvek
  • Magyar
Képzési forma
Személyre szabott ajánlatot szeretnél?
Kollégáink készséggel állnak rendelkezésedre, hogy segítsenek a neked megfelelő megoldás kialakításában.
Ajánlatot kérek

Tematika

Module 0: Provisioning SQL Databases - Overview
  • Overview: Provisioning SQL Databases - Overview
Module 1: SQL Server Components
  • Overview: SQL Server Components
  • Lesson 1: Introduction to the SQL Server Platform
  • Lesson 2: Overview of SQL Server Architecture
  • Lesson 3: SQL Server Services and Configuration Options
Module 2: Installing SQL Server
  • Overview: Installing SQL Server
  • Lesson 1: Considerations for Installing SQL Server
  • Lesson 2: tempdb Files
  • Lesson 3: Installing SQL Server
  • Lesson 4: Automating Installation
  • 20765c-module02-lab
Module 3: Upgrading SQL Server to SQL Server 2017
  • Overview: Upgrading SQL Server to SQL Server 2017
  • Lesson 1: Upgrade Requirements
  • Lesson 2: Upgrade of SQL Server Services
  • Lesson 3: Side-by-Side Upgrade: Migrating SQL Server Data and Applications
  • Lab 3: Upgrading SQL Server
Module 4: Working with Databases
  • Overview: Working with Databases
  • Lesson 1: Introduction to Data Storage with SQL Server
  • Lesson 2: Managing Storage for System Databases
  • Lesson 3: Managing Storage for User Databases
  • Lesson 4: Moving and Copying Database Files
  • Lesson 5: Configuring the Buffer Pool Extension
  • Lab 4: Managing Database Storage
Module 5: Performing Database Maintenance
  • Overview: Performing Database Maintenance
  • Lesson 1: Ensuring Database Integrity
  • Lesson 2: Maintaining Indexes
  • Lesson 3: Automating Routine Maintenance Tasks
  • Lab 5: Performing Ongoing Database Maintenance
Module 6: Database Storage Options
  • Overview: Database Storage Options
  • Lesson 1: SQL Server Storage Performance
  • Lesson 2: SMB Fileshare
  • Lesson 3: SQL Server Storage in Microsoft Azure
  • Lesson 4: Stretch Database
  • Lab 6: Implementing Stretch Database
Module 7: Planning to Deploy SQL Server on Microsoft Azure
  • Overview: Planning to Deploy SQL Server on Microsoft Azure
  • Lesson 1: SQL Server on Virtual Machines and Azure SQL Database
  • Lesson 2: Azure Storage
  • Lesson 3: Azure SQL Server Authentication
  • Lesson 4: Deploying Databases in Azure SQL Database
  • Lab 7: Plan and Deploy an Azure SQL Database
Module 8: Migrating Databases to Azure SQL Database
  • Overview: Migrating Databases to Azure SQL Database
  • Lesson 1: Database Migration Testing Tools
  • Lesson 2: Database Migration Compatibility Issues
  • Lesson 3: Migrating an On-Premises Database to an Azure SQL Database
  • Lab 8: Migrating SQL Server with Azure
Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine
  • Overview: Deploying SQL Server on a Microsoft Azure Virtual Machine
  • Lesson 1: Deploying SQL Server on Azure Virtual Machines
  • Lesson 2: Migrating a Database to a Microsoft Azure Virtual Machine
  • Lab 9: Deploying SQL Server on an Azure Virtual Machine
Module 10: Managing Databases in the Cloud
  • Overview: Managing Databases in the Cloud
  • Lesson 1: Managing Security in Azure SQL Database
  • Lesson 2: Configuring Azure Storage
  • Lesson 3: Azure Automation
  • Lab 10: Managing Databases in the Cloud
Tematika (PDF)