Microsoft SQL Server Provisioning SQL Databases exam 70-765
Provisioning SQL Databases exam 70-765
€369,00
Microsoft SQL Server

Provisioning SQL Databases exam 70-765

EUR 369,00 Excl. btw

Bestel deze unieke E-Learning cursus Provisioning SQL Databases exam 70-765, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, voortgangs door rapportage en testen.

  • E-learning Training
Op voorraad
Bestel voor 16:00 uur en start vandaag.
Aantal
- +
  • Voor 23:00 uur besteld, morgen in huis
  • Certificaat van deelname
  • Bedrijven bestellen op factuur
  • Betaal in 3x geen extra kosten 0% rente en zonder BKR met in3
  • Meer informatie? Neem contact op over dit product
Productomschrijving

Provisioning SQL Databases exam 70-765 E-Learning

Bestel deze unieke E-Learning cursus Provisioning SQL Databases exam 70-765 online, 1 jaar 24/ 7 toegang tot rijke interactieve video’s, spraak, voortgangsbewaking door rapportages en testen per hoofdstuk om de kennis direct te toetsen.


Cursusinhoud

Components of a SQL Server 2016 Installation

start the course
recognize the SQL Server 2016 components
describe SQL Server 2016 instances
describe SQL Server 2016 editions
describe SQL Server versions
explain SQL Server 2016 32-bit systems
explain SQL Server 2016 64-bit systems
recognize the different SQL Server 2016 architecture layers
explain SQL Server 2016 CPU usage
explain SQL Server 2016 Server memory management
describe parallelism in SQL Server 2016
explain I/O operations in SQL Server 2016
describe the various services used by SQL Server 2016
describe the various account types available in SQL Server 2016
explain the different network protocols supported by SQL Server 2016
understand the various hardware requirements for SQL Server 2016
understand the various software requirements for SQL Server 2016
describe considerations when implementing I/O subsystems for SQL Server 2016
demonstrate how to use the SQLIOSim tool in SQL Server 2016
demonstrate how to use the Diskspd tool in SQL Server 2016
determine the requirements for a successful SQL Server deployment

Installing and Upgrading SQL Server 2016

start the course
explain SQL Server 2016 tempdb files
describe tempdb attributes
understand tempdb sizing
describe SQL installation options
demonstrate how to install SQL Server 2016
recognize post-installation best practices
demonstrate SQL Server servicing installation
recognize unattended installation options
perform an unattended SQL Server 2016 installation
create an upgrade strategy for SQL Server 2016
recognize the supported upgrade paths for SQL Server 2016
use the data migration assistance in SQL Server 2016
explain how to upgrade from SQL Server 2005
explain how and when to use the in-place upgrade option
explain how and when to use the side-by-side upgrade option
describe hybrid and rolling upgrade options in SQL Server 2016
demonstrate how to use the upgrade advisor in SQL Server 2016
describe the SQL Server distributed replay feature
determine the appropriate installation options and features for a given scenario

SQL Server Virtual Machines on Azure

start the course
explain SQL Server on Azure virtual machines
recognize SQL Server Azure VM usage scenarios
explain per-minute licensing
recognize the differences between IaaS and on-premises deployments
demonstrate how to connect to a SQL Server Azure VM
demonstrate how to migrate a database to a SQL Server Azure VM
perform a backup of a database to an Azure storage account
perform a restore from an Azure storage account to an Azure VM
configure automatic patching and updating of an Azure VM running SQL Server
describe the customer experience improvement program (CEIP)
explain service tiers in SQL Server 2016
describe common service tier use cases
demonstrate how to create a sysadmin account
explain elastic database pools
describe when to use the appropriate service tier
explain SQL Server 2016 database transaction units
describe how to provision an Azure SQL Server 2016 database
demonstrate how to create an Azure SQL Server 2016 database
demonstrate how to connect to an Azure SQL Server 2016 database
determine when to deploy SQL to Azure VMs and databases

SQL Server Instances and Storage Considerations

start the course
describe SQL Server instances
explain how to host a SQL Server instance using Azure VMs
recognize the benefits of using Azure automation
explain how and when to use Azure Resource Manager
demonstrate how to deploy SQL Server using templates
provide an introduction to data storage with SQL Server
discuss considerations when planning disk storage devices
explain the different types of RAID configurations
differentiate between the five SQL Server system databases
demonstrate how to create user databases in SQL Server 2016
explain the use of filegroups in SQL Server 2016
describe how SQL Server uses the buffer pool extension
demonstrate how to configure the storage buffer pool extension
explain how storage spaces can be used in SQL Server 2016
describe storage layout considerations when using virtual machines
describe other possible storage solutions, including NAS, DAS, and SAN
determine effective disk or storage configuration for a given scenario

Microsoft Azure SQL Database Security

Determining how to secure databases in SQL Server 2016 is one of the most important parts of a deployment strategy. This course covers how to implement firewalls, authentication, and auditing to ensure Microsoft Azure SQL database security. In addition, this course covers dynamic data masking, a feature in SQL Server 2016 that can be used to limit exposure to sensitive data. This course is one of a series of courses that cover the objectives for the 20765A: Provisioning SQL Databases exam.

Azure SQL Database Encryption

start the course
provide a general overview of transparent data encryption
demonstrate how to use transparent data encryption
demonstrate how to use transparent data encryption commands and functions
describe the TDE catalog views in SQL Server 2016
describe the TDE dynamic management views in SQL Server 2016
describe considerations when implementing TDE
demonstrate how to enable TDE using the Azure portal
demonstrate how to enable and disable TDE using PowerShell
demonstrate how to disable TDE using the Azure portal
describe how to move a TDE protected database
describe the Always Encrypted database engine feature
recognize when to use the Always Encrypted feature in SQL Server 2016
configure Always Encrypted in SQL Server 2016
describe the available database permissions in SQL Server 2016
understand the encryption key hierarchy in SQL Server 2016
recognize when to use cell-level encryption
describe the security permissions required for cell-level encryption
demonstrate how to encrypt data using simple symmetric encryption
configure encryption for Azure SQL Databases

SQL Server Performance Settings

start the course
describe how to evaluate and tune database performance
demonstrate how to improve performance by changing service tiers
configure elastic database pools to scale resources automatically
configure the database scope in SQL Server 2016
demonstrate how to configure memory options including min server memory and max server memory
demonstrate how to configure and view memory options using T-SQL
describe the three approaches you can use to manage memory when running multiple instances of the database engine
describe the role of operators in SQL Server 2016
demonstrate how to create an operator in SQL Server 2016
perform the necessary steps to delete an operator in SQL Server 2016
demonstrate how to configure operator availability in SQL Server 2016
edit an existing operator in SQL Server 2016
access and view operator information in SQL Server 2016
demonstrate how to designate a fail-safe operator in SQL Server 2016
configure alerts based on monitoring metrics in SQL Server 2016
create an alert rule on a metric within the Azure portal
assign alerts to an operator in SQL Server 2016
manage alerts in SQL Server 2016
optimize SQL Server 2016 database performance

Deploying Applications to Microsoft Azure SQL Databases

start the course
explain the difference between single-tenant and multi-tenant data architectures
recognize the architectural considerations that influence choosing between a single vs multi tenant
explain considerations, such as economic, security, tenant, relating to multiple tenants
describe how to manage multi-tenant data in SQL Server 2016
describe the benefits of partitioning and isolating tenant data
demonstrate how to manage deployments that support multiple tenants
recognize the various steps and considerations involved with migrating on-premise SQL Server databases to Azure
recognize the tools available to test for SQL Database compatibility
describe how to migrate a non-SQL Server database
demonstrate how to migrate a SQL Server database using the Microsoft Azure database wizard
compare the bacpac export and transactional replication migration methods
demonstrate how to create a BACPAC file to use in a database migration
explain the Azure data factory
describe the data transformation activities supported by Azure data factory
discuss how to install the data management gateway
create linked services that connect to data sources in Azure data factory
define and create tables to specify how to access datasets
demonstrate how to define, create, and start the pipeline
manage data using the Azure Data Factory

Azure Virtual Machines

start the course
describe the primary migration methods available when migrating to Azure VMs
describe how to use the Azure VM deployment wizard
describe alternative deployment options such as backing up to a file and URL
demonstrate how to detach and copy to URL and attach from URL using the AzCopy command line utility
explain the Microsoft Azure import/export service
describe the benefits of generating benchmark data
explain why it is important to perform cache warming prior to gathering benchmark data
describe the Iometer tool and how it can be used to gather benchmark data
demonstrate how to use the IOMeter tool to gather benchmark data
explain how the FIO tool can be used to gather benchmark data on Azure VMs
explain how to effectively tune data disks in Azure
describe how VM disk caching works
explain how using data compression reduces overall I/O
describe the different types of platform events that can affect the availability of VMs
demonstrate how to configure multiple VMs in an availability set for redundancy
configure each application tier into separate availability sets for redundancy
describe the benefits of combining Azure load balancer with availability sets
configure multiple storage accounts for each availability set
migrate data using the Microsoft Azure VM wizard

Migrating Client Applications

start the course
explain the role of connection strings
describe the use of connection strings in Azure
discuss how to create connection strings for Azure storage accounts
create a connection string using a shared access signature
create a connection string to an explicit storage endpoint
parse a connection string from a configuration file
develop application retry connection logic
describe the different options for distributing network traffic using Azure
describe the traffic manager feature found in Azure
explain the priority traffic routing method
explain the weighted traffic routing method
explain the performance traffic routing method
describe the 1-tier application pattern
explain the 3-tier application pattern
explain the presentation tier scale out application pattern
describe the business tier scale out application pattern
describe the 2-tier and 3-tier presentation and business tiers scale out and HADR application pattern
describe the 2-tier and 3-tier using the Azure VMs and Cloud services application pattern
explain the N-Tier hybrid application pattern
demonstrate how to create a traffic manager profile

Specificaties
Duur 25 uur
Taal Engels
Certificaat van deelname Ja
Online toegang 365 dagen
Voortgangsbewaking Ja
Award Winning E-learning Ja
Geschikt voor mobiel Ja
Wat onze klanten zeggen

average of 0 review(s)

Geen reviews gevonden
Help ons en andere klanten door het schrijven van een review
Mijn account
You are not logged in. Log in to make use of all the benefits. Or create an account now.
Taal
Winkelwagen
Uw winkelwagen is leeg
Menu
Zoeken
Search suggestions
Geen cursussen of trainingen gevonden...
Wij slaan cookies op om onze website te verbeteren. Is dat akkoord? Ja Nee Meer over cookies »