Inhoud ICT-cursus 70-765 Provisioning SQL Databases

Inhoud van de ICT-cursus 70-765 Provisioning SQL Databases | De Kantooropleider

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
Print pagina