SQL-20765

Install, configure and operate SQL Server locally and in the cloud

Form of participation
Form of training
Length of training
  • 3 day (3×8 Lessons)
  • daily 9:00 - 17:00
Available languages
  • Hungarian
Dates

Training price

from 
235 000 Ft
+ VAT/person
Please choose the date and form of participation!
Would you like a custom made solution, group training on this topic?
Find out more about our customised training services here.

Suggested For

The course is recommended for database experts (operators, administrators) with previous SQL Server operation knowledge and experience, who will be responsible for implementing, installing and upgrading SQL Server 2016 systems in local and cloud-based infrastructures.

Outline

Ask our sales colleagues for a personalised offer!

  • SQL Server architecture and components overview, SQL Server services, configuration options, SQL Server versions and upgrade options.
  • SQL Server 2016 deployment: deployment planning, pre-installation considerations; managing TempDB files; deploying SQL Server 2016 in a local (on-premise) environment; implementing automated deployment solutions.
  • Migrating from previous SQL Server versions: analyzing upgrade requirements, upgrading SQL Server services, migrating SQL Server data and applications.
  • Deploying SQL Server in an Azure environment: overview of SQL Server virtual machines, installing and configuring Azure SQL databases, migrating local databases to Azure SQL database.
  • Working with databases: concepts, creating databases, reviewing and managing database files and file groups, moving database files, buffer pool extension concepts and usage.
  • Database storage: concepts, storage performance, SMB file sharing, implementing storage under Azure, stretch database concepts and implementation.
  • Database maintenance: ensuring database integrity, index maintenance, overview of automated routine maintenance options.
  • Preparing for SQL Server deployment in Azure environment: Azure storage, Azure SQL authentication, SQL Server virtual machines in Azure environment, deploying Azure SQL databases.
  • Migrating databases to Azure SQL database.
  • SQL Server installation on Azure virtual machine.
  • Managing databases in the cloud.
Outline (PDF)

Prerequisites

Windows Server 2012 or 2016 operator basics, previous SQL Server operator knowledge and experience, basic knowledge of virtualization and cloud technologies. Completion of or knowledge of courses 20461 or 20761 and operator training courses 10775 or 20764. As the course materials are in English, basic English language skills at document reading level are required. The presentation will be in Hungarian.