Tijdens de ICT-cursus 70-765 Provisioning SQL Databases worden de volgende onderdelen behandeld:
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
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
Volg ons: