Inhoud ICT-cursus 70-765 Provisioning SQL Databases

• 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

• 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

• 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

• 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

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.

• 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

• 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

• 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

• 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

• 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