Existing User Login

New User? Create An Account

Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Microsoft 70-765 : Provisioning SQL Databases

E-COURSE:

Microsoft 70-765 : Provisioning SQL Databases

Instructor-led video course with presentations, workbooks, games, flashcards and quizzes.
Overview

Microsoft exam 70-765 ("Provisioning SQL Databases") is one of two tests you must pass to earn a Microsoft Certified Solutions Associate (MCSA): 2016 Database Administration certification. This course supplies you with the knowledge you need to pass the 70-765.  This course is intended to show how to arrange SQL Server databases both on start and in SQL Azure. This training is a piece of a Microsoft certification path and can enable you to get ready for your Microsoft certificates.

Objectives
  • Implement SQL in Azure
  • Manage SQL Storage
  • Deploy SQL Server instances
  • Configure secure access to Microsoft Azure SQL Databases
  • Plan for SQL Server installation
  • Manage SQL Server instances
  • Deploy a Microsoft Azure SQL Database
  • Manage databases and instances
  • Configure SQL Server performance settings
  • Deploy SQL Server databases to Azure virtual machines
  • Perform database maintenance
Prerequisites
  • Essential knowledge of the Microsoft Windows working framework and its center usefulness.
  • Understanding of Transact-SQL and working experience with it.
  • Knowledge and practical skills regarding social databases.
  • Some experience related to the database structure.
Target Audience
  • Web Developers
  • Software Developers
  • Programmers
  • Anyone who wants to pass Exam 70-765

Module 1: Deploy a Microsoft Azure SQL Database

1.1 Introduction

1.2 Introducing the Azure SQL Database Part 1

1.3 Introducing the Azure SQL Database Part 2

1.4 Setting Up Azure Lab

1.5 Chose a Service Tier Part 1

1.6 Chose a Service Tier Part 2

1.7 Create Servers and Databases Part 1

1.8 Creating a Azure SQL Server and Database Lab

1.9 Create Servers and Databases Part 2

1.10 Create Servers and Databases Part 3

1.11 Connecting SSMS to Azure SQL Lab Part 1

1.12 Connecting SSMS to Azure SQL Lab Part 2

1.13 Create a Sysadmin Account

1.14 Creating Azure SQL Logins and Users Lab

1.15 Configure Elastic Pools

1.16 Creating and Conguring an Elastic Pool Lab

Module 2: Plan for SQL Server Installation

2.1 Plan for an IaaS or On-Premises Deployment Part 1

2.2 Plan for an IaaS or On-Premises Deployment Part 2

2.3 Select the Appropriate Size for a Virtual Machine

2.4 Plan Storage Pools Based on Performance Requirements Part 1

2.5 Plan Storage Pools Based on Performance Requirements Part 2

2.6 Evaluate Best Practices for Installation

2.7 Design a Storage Layout for a SQL Server Virtual Machine

Module 3: Deploy SQL Server Instances

3.1 Deploy a SQL Server Instance in IaaS and On-Premises

3.2 Restoring AdventureWorks 2016 Database Lab

3.3 Provision an Azure Virtual Machine to Host a SQL Server Instance

3.4 Provisioning an Azure Virtual Machine to Host a SQL Server Lab

3.5 Manually Install SQL Server on an Azure Virtual Machine

3.6 Installing SQL 2016 Lab Part 1

3.7 Installing SQL 2016 Lab Part 2

3.8 Automate the Deployment of SQL Server Databases

3.9 Exploring Azure SQL Database Automation Lab

3.10 Deploy SQL Server by Using Templates

3.11 Managing JSON Templates Lab

Module 4: Deploy SQL Server Databases to Azure Virtual Machines

4.1 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine

4.2 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1

4.3 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2

4.4 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3

4.5 Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4

4.6 Generate Benchmark Data for Performance Needs

4.7 Generating Benchmark Data Lab Part 1

4.8 Generating Benchmark Data Lab Part 2

4.9 Perform Performance Tuning on Azure IaaS

4.10 Perform Performance Tuning on Azure IaaS Lab Part 1

4.11 Perform Performance Tuning on Azure IaaS Lab Part 2

4.12 Support Availability Sets in Azure Part 1

4.13 Support Availability Sets in Azure Part 2

4.14 Manage High Availability Lab Part 1

4.15 Manage High Availability Lab Part 2

4.16 Manage High Availability Lab Part 3

4.17 Manage High Availability Lab Part 4

4.18 Manage High Availability Lab Part 5

Module 5: Configure Secure Access to Microsoft Azure SQL Databases

5.1 Configure Firewall Rules

5.2 Creating Firewall Rules Lab

5.3 Configure Always Encrypted for Azure SQL Database

5.4 Implementing Always Encrypted Lab

5.5 Configure Cell-Level Encryption

5.6 Cell-Level Encryption Lab

5.7 Configure Dynamic Data Masking

5.8 Dynamic Data Masking Lab

5.9 Configure Transparent Data Encryption (TDE)

5.10 Transparent Data Encryption (TDE) Lab

E-COURSE E-Learning Expert-led video course with presentations, workbooks, quizzes, games and flashcards.
USD 195 USD 95 51% OFF
  • 22:57:17
    + Hours Of learning
  • Includes video, presentations, workbooks, quizzes, flashcards & games
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top