Microsoft
Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Administration
70-764 Administering a SQL Database Infrastructure
Microsoft SQL Server 2016: Auditing
Microsoft SQL Server 2016: Backing Up Databases
Microsoft SQL Server 2016: Data Access and Permissions
Microsoft SQL Server 2016: Encryption
Microsoft SQL Server 2016: High Availability and Disaster Recovery
Microsoft SQL Server 2016: Managing Database Integrity
Microsoft SQL Server 2016: Managing Indexes and Statistics
Microsoft SQL Server 2016: Monitoring Database Activity and Queries
Microsoft SQL Server 2016: Monitoring SQL Server Instances
Microsoft SQL Server 2016: Restoring Databases
70-765 Provisioning SQL Databases
Azure SQL Database Encryption
Azure Virtual Machines
Components of a SQL Server 2016 Installation
Deploying Applications to Microsoft Azure SQL Databases
Installing and Upgrading SQL Server 2016
Microsoft Azure SQL Database Security
Migrating Client Applications
SQL Server Instances and Storage Considerations
SQL Server Performance Settings
SQL Server Virtual Machines on Azure

Microsoft SQL Server 2016: Auditing

Course Number:
df_sqla_a03_it_enus
Lesson Objectives

Microsoft SQL Server 2016: Auditing

  • start the course
  • describe why auditing is required and auditing methods
  • use triggers for auditing
  • use temporal tables for auditing
  • use temporal tables for auditing
  • view the audit log using SQL Server Management Studio or sys.fn_get_audit_file
  • describe the purpose of Extended Events
  • describe the purpose of SQL Server Audit, auditing levels, and components
  • define an audit using SQL Server Audit
  • describe the purpose of actions and actions groups
  • create server audit specifications
  • create database audit specifications
  • use dynamic management and system views to manage an audit
  • compare auditing in Azure SQL Database with SQL Server auditing and describe its purpose
  • configure auditing for Azure SQL Database
  • describe the purpose of audit logs and reports when auditing in Azure SQL Database
  • analyze audit logs and reports when auditing in Azure SQL Database
  • configure auditing in SQL Server 2016

Overview/Description
Auditing allows you to track and log database events to ensure the database is performing properly - an essential administration task. This course teaches you about auditing, including how to configure and manage an audit and query the audit log. Additionally, configuring an Azure SQL Database audit and analyzing audit logs and reports from Azure SQL Database are covered. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Microsoft SQL Server 2016: Backing Up Databases

Course Number:
df_sqla_a04_it_enus
Lesson Objectives

Microsoft SQL Server 2016: Backing Up Databases

  • start the course
  • describe the reasons for backing up a database and supported backup types
  • determine the appropriate strategy for backing up a database
  • determine the appropriate media for backing up a database
  • recognize how to plan a retention policy for backing up databases
  • create a backup using SQL Server Management Studio
  • create a backup using Transact-SQL
  • describe how transaction log backup works
  • create an automated backup job in SQL Server Management Studio
  • describe the features and benefits of backing up a database to the Azure Blob Storage Service
  • describe best practice and troubleshooting tips for backing up to the Azure Blob Storage Service
  • back up a database to Azure
  • describe the purpose of the three recovery models
  • view and change recovery models using SQL Server Management Studio
  • recognize how to view and change recovery models using Transact-SQL
  • describe tasks that should be completed after changing the recovery model
  • manage and implement a backup strategy in SQL Server 2016

Overview/Description
A tested backup strategy is the most effective means of protecting your data from media failure, user errors, hardware failures, and other potential disasters. This course teaches you about backing up data in SQL Server 2016, including backing up large databases, configuring alerting for backup issues, and managing translation log backups. In addition, this course covers backing up to Azure SQL Database, configuring recovery models, and automating backup jobs. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Microsoft SQL Server 2016: Data Access and Permissions

Course Number:
df_sqla_a02_it_enus
Lesson Objectives

Microsoft SQL Server 2016: Data Access and Permissions

  • start the course
  • describe the types of database users and their purpose
  • create a database user using SQL Server Management Studio
  • create a database user using Transact-SQL
  • describe available server permissions
  • recognize the steps involved in granting a user access to a database and its objects
  • grant access to database objects
  • revoke access to database objects
  • describe database-level roles and their purpose
  • describe server-level roles and their purpose
  • describe the purpose of application roles
  • recognize why you would use and how to create a custom role
  • describe the purpose of row-level security and how to implement it
  • implement row-level security using T-SQL and predicates
  • implement row-level security using T-SQL and predicates
  • describe the purpose of dynamic data masking
  • define dynamic data masking
  • describe the benefits and features of using Azure SQL Database
  • create and configure a new Azure SQL Database
  • connect to and manage an Azure SQL Database using a local instance of SSMS
  • configure data access and permissions in SQL Server 2016

Overview/Description
To protect data in a SQL Server Database environment, you need to ensure that only trusted users and applications have access to it. In this course, you will learn about configuring data access and permissions. This includes managing database object permissions, as well as creating and maintaining users and custom roles. In addition, this course covers configuring user options for Azure SQL Database, row-level security, and dynamic data masking. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Microsoft SQL Server 2016: Encryption

Course Number:
df_sqla_a01_it_enus
Lesson Objectives

Microsoft SQL Server 2016: Encryption

  • start the course
  • describe the encryption features supported in SQL Server 2016
  • describe Transparent Data Encryption and the keys used for encrypting and decrypting data
  • use Transparent Data Encryption
  • describe the features and limitations of Always Encrypted
  • use the Always Encrypted Wizard
  • configure Always Encrypted using SQL Server Management Studio
  • configure Always Encrypted using PowerShell
  • describe support and limitations for encryption with Azure SQL Database
  • describe the benefits, requirements, restrictions, methods, and recommended practices for backup encryption
  • create an encrypted backup
  • recognize the purpose of cell-level encryption and how to use Transact-SQL and symmetric encryption to configure it
  • enable encrypted connections to a database
  • troubleshoot encryption
  • configure encryption in SQL Server 2016

Overview/Description
Ensuring data security is an important part of administering any database infrastructure, and encryption is one method to help you protect sensitive data. This course will teach you about encryption-related tools and processes used in SQL Server 2016, including cell-level, backup, and connection encryption. In addition, this course covers the Always Encrypted feature, Transparent Data Encryption, and troubleshooting. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database Administrators, database professionals

Microsoft SQL Server 2016: High Availability and Disaster Recovery

Course Number:
df_sqla_a10_it_enus
Lesson Objectives

Microsoft SQL Server 2016: High Availability and Disaster Recovery

  • start the course
  • recognize the purpose and benefits of log shipping
  • configure log shipping with SQL Server Management Studio
  • configure log shipping with Transact-SQL
  • describe log shipping management tasks such as adding databases, removing log shipping, failing over, and changing roles
  • recognize the tables and stored procedures used for monitoring log shipping
  • describe the features and benefits of AlwaysOn Availability Groups
  • describe the purpose of the failover process and the available failover modes
  • describe the capabilities provided by Windows Server Failover Clustering and its relationship to AlwaysOn components
  • describe how high availability is accomplished by monitoring cluster resources
  • create a new availability group
  • change the failover mode in an AlwaysOn availability group
  • configure read-only routing for an availability group using Transact-SQL
  • describe the purpose of distributed availability groups
  • create a distributed availability group with Transact-SQL
  • configure cluster shared volumes
  • manage high availability in SQL Server 2016

Overview/Description
Data is an important enterprise asset and it is vital that it be protected, retrievable, and highly available. This course covers managing high availability and disaster recovery in SQL Server 2016. This includes configuring and monitoring log shipping, as well as managing shared disks and configuring cluster shared volumes. In addition, this course covers configuring Windows clustering, creating an availability group and distributed availability groups, configuring read-only routing, and managing failover. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Microsoft SQL Server 2016: Managing Database Integrity

Course Number:
df_sqla_a06_it_enus
Lesson Objectives

Microsoft SQL Server 2016: Managing Database Integrity

  • start the course
  • describe the purpose of the Database Consistency Checker
  • use the Database Consistency Checker in SQL Server Management Studio
  • use the catalog view to see information about progress and current phase of execution
  • describe the types of consistency checks appropriate for databases
  • perform consistency checks on tables and indexes
  • recognize common consistency check errors and their resolutions
  • recognize possible causes of database corruption
  • detect corruption in a SQL Server database
  • recover from database corruption
  • use SQL Server 2016 tools to ensure database consistency

Overview/Description
Managing database integrity by ensuring objects are structurally sound and properly allocated is an important aspect of database administration. This course teaches you how to implement database consistency checks, as well as how to identify and recover from database corruption. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Microsoft SQL Server 2016: Managing Indexes and Statistics

Course Number:
df_sqla_a09_it_enus
Lesson Objectives

Microsoft SQL Server 2016: Managing Indexes and Statistics

  • start the course
  • describe the types of indexes available in SQL Server and the importance of managing them properly
  • detect fragmented indexes and determine the degree of fragmentation
  • repair index fragmentation using SQL Server Management Studio
  • repair index fragmentation using Transact-SQL
  • use the Missing Indexes feature to identify missing indexes and to create them, if needed
  • find and remove underutilized indexes
  • describe the purpose of columnstore indexes, as well as why and when to use them
  • improve columnstore index performance
  • defragment columnstore indexes
  • identify and correct outdated statistics
  • describe the purpose and characteristics of the auto_update_statistics option
  • implement Auto Update Statistics
  • implement statistics for large tables
  • manage indexes in SQL Server 2016

Overview/Description
By carefully managing aspects of your database like indexes and statistics, you are able to better tune performance and identify potential issues. This course teaches you about index management tasks, such as identifying and repairing fragmentation, identifying and creating missing indexes, identifying and dropping underused indexes, and managing existing columnstore indexes. In addition, this course covers statistic management topics, such as identifying and correcting outdated statistics, using Auto Update Statistics, and statistics for large tables. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Microsoft SQL Server 2016: Monitoring Database Activity and Queries

Course Number:
df_sqla_a07_it_enus
Lesson Objectives

Microsoft SQL Server 2016: Monitoring Database Activity and Queries

  • start the course
  • recognize the types of activities that can be monitored using Activity Monitor
  • use Activity Monitor in SQL Server Management Studio to monitor database activity
  • identify blocks using Activity Monitor and stored procedures
  • describe the role of the data collector
  • describe the components that make up the data collection system
  • configure the data collector
  • use System Monitor to monitor resource usage
  • describe the purpose of utility control point and the requirements for its use
  • use the Create UCP wizard to create a SQL Server utility control point
  • complete the creation of a SQL Server utility control point
  • describe the purpose of the Query Store, its features, and configuration options
  • describe scenarios for using the Query Store
  • describe the features, benefits, and architecture of performance monitoring with Extended Events
  • create an Extended Events session
  • recognize how Extended Events can be used to troubleshoot performance issues
  • describe the features, benefits, and architecture of SQL Trace
  • describe the uses of SQL Trace
  • identify issues with execution plans
  • monitor database activity in SQL Server 2016

Overview/Description
An enterprise database infrastructure has a lot of moving pieces, and it's crucial that they be monitored. This course focuses on managing and monitoring SQL Server database activity and queries. Covered topics include monitoring current sessions, identifying sessions that cause blocking activity or consume tempdb resources, configuring a data collector, and creating a utility control point. In addition, it covers query monitoring activities such as managing the Query Store, configuring Extended Events and trace events, identifying problematic execution plans, and troubleshooting server health using Extended Events. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Microsoft SQL Server 2016: Monitoring SQL Server Instances

Course Number:
df_sqla_a08_it_enus
Lesson Objectives

Microsoft SQL Server 2016: Monitoring SQL Server Instances

  • start the course
  • describe Database Mail, mail profiles, and the importance of security
  • describe the logging levels and the need for a retention policy in Database Mail
  • configure Database Mail
  • recognize the features, benefits, and components of SQL Server Agent
  • describe the purpose of SQL Server Agent operators, the types of contact methods, and notifications
  • create a SQL Server Agent operator using SQL Server Management Studio
  • describe the purpose of SQL Server Agent alerts, how they are triggered, and what they can do
  • recognize the troubleshooting process for SQL Server Agent alerts and notifications
  • create SQL Server Agent alerts and configure their actions using SQL Server Management Studio
  • create alerts that respond to user-defined events
  • define actions a SQL Server Agent should take in the event of job failure
  • describe the purpose and components of Policy-Based Management
  • configure Policy-Based Management properties and failure notification alerts
  • create a Policy-Based Management policy using SQL Server Management Studio
  • recognize how to manage an existing Policy-Based Management policy
  • identify used and available space on data volumes
  • recognize what affects the performance of a server and when to use baseline measurements
  • recognize performance issues that may affect SQL Server
  • monitor instances in SQL Server 2016

Overview/Description
Regularly monitoring your SQL Server instances helps you to identify and correct issues before they cause damage and provides valuable insight for performance tuning. This course teaches you about monitoring SQL Server 2016 instances, including creating and managing operators and SQL Server Agent alerts, defining custom alert actions and failure actions, configuring Database Mail and Policy-Based Management, and identifying available space on data volumes and performance degradation. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Microsoft SQL Server 2016: Restoring Databases

Course Number:
df_sqla_a05_it_enus
Lesson Objectives

Microsoft SQL Server 2016: Restoring Databases

  • start the course
  • recognize what is involved in restoring a database, what can be restored, and restore scenario models
  • describe the purpose and prerequisites of restoring a database backup under the simple recovery model
  • restore a database under the simple recovery model
  • describe the purpose of and considerations for restoring a database under the full recovery model
  • restore a database under the full recovery model
  • restore a database under the full recovery model
  • automate and test restores
  • describe point-in-time recovery and perform point-in-time recovery using SQL Server Management Studio
  • perform point-in-time recovery using Transact-SQL
  • describe the goal of file restore and how it differs in the simple recovery model versus the full recovery model
  • restore files and filegroups
  • restore files to a new location
  • restore files and filegroups over existing files
  • recognize when a page restore is useful, as well as its limitations and restrictions
  • restore pages using SQL Server Management Studio and Transact-SQL
  • describe the purpose and process of piecemeal restore
  • describe the purpose and requirements of piecemeal restore in the simple recovery model
  • describe the purpose and requirements of piecemeal restore in the full recovery model
  • restore a database using a piecemeal restore
  • restore a database in SQL Server 2016

Overview/Description
An effective data protection strategy requires the ability to restore data from a backup in case of disaster, failure, or errors. This course covers restoring SQL Server 2016 databases, including how to perform piecemeal and page restores. It also covers performing point-in-time recovery, restoring file groups, and planning automation for restore testing. This course is one of a series in the Skillsoft learning path that covers the objectives for the 70-764: Administering a SQL Database Infrastructure exam.

Target Audience
Database administrators and database professionals

Azure SQL Database Encryption

Course Number:
df_sqlp_a06_it_enus
Lesson Objectives

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

Overview/Description
Transparent Data Encryption (TDE) performs real-time I/O encryption of data and can be used to secure SQL servers and Azure SQL databases. This course covers how to implement TDE, as well as other encryption solutions such as Always Encrypted and Cell-level encryption. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

Azure Virtual Machines

Course Number:
df_sqlp_a09_it_enus
Lesson Objectives

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

Overview/Description
Microsoft SQL Server applications can be moved to Azure virtual machines to help reduce costs and to optimize overall performance. This course covers the various methods used to migrate applications from an on-premise environment to Azure virtual machines. In addition, topics such as gathering benchmark data, performance tuning, and configuring availability sets for redundancy are covered. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

Components of a SQL Server 2016 Installation

Course Number:
df_sqlp_a01_it_enus
Lesson Objectives

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

Overview/Description
It is important to understand the various components, editions, and versions that exist when discussing SQL Server 2016. This course provides and introduction for both the SQL Server platform and SQL Server architecture, while also providing an overview of best practices and guidelines to follow when preparing for an installation of SQL Server 2016. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

Deploying Applications to Microsoft Azure SQL Databases

Course Number:
df_sqlp_a08_it_enus
Lesson Objectives

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

Overview/Description
There are many variables to consider when deciding on a single-tenant or multi-tenant design for Windows Azure. This course covers the considerations for each, as well as the requirements and processes involved in migrating data to Azure SQL Databases. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

Installing and Upgrading SQL Server 2016

Course Number:
df_sqlp_a02_it_enus
Lesson Objectives

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

Overview/Description
Whether performing a SQL Server 2016 installation or an upgrade, it's important to understand the numerous recommended pre- and post-installation best practices set forth by Microsoft to ensure a successful deployment. This course covers deployment options such as unattended installations and upgrades, as well as the various tools available in SQL Server 2016 to migrate data and ensure compatibility. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

Microsoft Azure SQL Database Security

Course Number:
df_sqlp_a05_it_enus
Lesson Objectives

Microsoft Azure SQL Database Security

  • start the course
  • describe the benefits of enabling a SQL Server firewall
  • demonstrate how to configure SQL Server 2016 firewall rules
  • demonstrate how to manage existing firewall rules in the Azure portal
  • explain how to restrict and secure a connection to a SQL Server database
  • explain how the connection process redirects machines to a different IP address and port
  • describe how to implement authentication in SQL Server 2016
  • describe considerations involving the implementation of contained database users
  • explain the restrictions involving managing logins and users
  • describe how to implement SQL database auditing
  • explain how authorization can be used when securing SQL Server databases
  • describe dynamic data masking
  • describe the four types of dynamic data masks
  • explain how to implement dynamic data masking policies and permissions
  • demonstrate how to query masked columns in SQL Server 2016
  • explain the limitations and restrictions of dynamic data masking
  • demonstrate how to create a dynamic data mask
  • demonstrate how to configure dynamic data masking using the Azure portal
  • demonstrate how to configure dynamic data masking using PowerShell
  • configure firewall rules in Azure SQL Database

Overview/Description
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.

Target Audience
SQL Server database administrators and application developers

Migrating Client Applications

Course Number:
df_sqlp_a10_it_enus
Lesson Objectives

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

Overview/Description
Connection strings are used to allow client applications to interact with Azure SQL databases. This course covers the application connections strings, as well as the Azure Traffic Manager, which is used to control the distribution of incoming user traffic. In addition, this course covers the various types of application patterns available for SQL Server-based applications in an Azure environment. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

SQL Server Instances and Storage Considerations

Course Number:
df_sqlp_a04_it_enus
Lesson Objectives

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

Overview/Description
SQL Server uses instances to allow more than one copy of a SQL Server component to be installed on a single server. This course covers deploying SQL Server instances in IaaS and on-premise, as well as how to provision and install SQL Server on Azure virtual machines. Also covered in this course are the various storage solutions available in SQL Server 2016 and the considerations associated with each. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

SQL Server Performance Settings

Course Number:
df_sqlp_a07_it_enus
Lesson Objectives

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

Overview/Description
SQL Server 2016 offers various tools to tune a SQL Server environment for peak performance. This course covers how to maximize database performance as well as the maximum amount of server memory. In addition, this course covers how to configure operators and alerts in SQL Server 2016. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

SQL Server Virtual Machines on Azure

Course Number:
df_sqlp_a03_it_enus
Lesson Objectives

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

Overview/Description
Azure virtual machines provide a way to move on-premise SQL Server workloads and applications to the cloud. This course will cover the recommended usage scenarios for Azure VMs, as well as how to provision, create, and connect to Azure SQL Databases. This course is one of a series of courses that cover the objectives for the 70-765: Provisioning SQL Databases exam.

Target Audience
SQL Server database administrators and application developers

Close Chat Live