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
Duration: 01:23
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
Duration: 01:30
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
Duration: 01:36
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
Duration: 01:17
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
Duration: 01:35
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
Duration: 01:35
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
Duration: 01:38
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
Duration: 01:54
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
Duration: 01:49
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
Duration: 01:59