Microsoft Skills Gap Assessment

Country (You Can Choose More Than One)

Costa Rica

Dominican Republic

Puerto Rico

Please Select One of the Folowing:

I am a Microsoft Business Customer "SATV"

I am a Microsoft Individual User

I am a Microsoft Partner


What certification track and courses are needed? "Please indicate quantity"
(Press symbol for further information about the course.)

Azure Skills Initiative

Microsoft azure fundamentals program

AZ-900(1 Days)Azure Fundamentals

Microsoft advance program

10979F(5 Days)Introduction to Microsoft Azure for IT Professionals

AZ-103(4 Days)Azure Administrator

AZ-203(6 Days)Azure Developer

AZ-300(5 Days)Azure Solutions Architect Technologies

AZ-301(5 Days)Azure Solutions Architect Design

AZ-400(5 Days)Azure DevOps Solutions

Microsoft migration workshops

AZ-500T00A(1 Day)Azure Security Technologies

AI-100T01A(3 Day)Designing and Implementing an Azure AI Solution

DP-100T01A(1 Day)Designing and Implementing a Data Science Solution on Azure

DP-200T01A(3 Day)Implementing an Azure Data Solution

DP-201T01A(2 Day)Designing an Azure Data Solution

Microsoft Office Specialist

Microsoft 365 Admin

Cloud Administrator

Web Developer

Database & Business Intelligence

Infra Admin





About Us | Contact Us | Terms
phone: (787) 766.2405 | fax: (787) 789.5747 | email: info@itg.online
address: Puerto Rico Science, Technology, and Research Trust, Antigua Penitenciaria Estatal Carr. # 21, Bo. Monacillos, San Juan, 00927
Copyright ©2019 Interactive Technology Group. All rights reserved.
Cloud Administrator - As companies move to the cloud, the need for cloud skilled professionals continues to rise. Companies need people with a range of skills; such as automation of deployments and workloads, to understanding how to best manage security and compliance. Through this program, students / professional learners will learn how to set up Microsoft Azure virtual machines, networks, and app services; automate workloads and deployment; and manage storage, identity, databases, security and compliance. 
Description: Deploy Windows; manage devices and data; configure connectivity; and maintain Windows.
Prerequisites: Microsoft 365 Fundamentals if needed. 
Description: Deploy and update operating systems; manage policies and profiles; manage and protect devices; and manage apps and data.
Prerequisites: Modern Desktop Administrator MD -100 
Description: Manage modern messaging infrastructure; manage mail flow topology; and manage recipients and devices.
Prerequisites: None listed 
Description: Plan and implement a hybrid configuration and migration; secure the messaging environment; and manage organizational settings.
Prerequisites: Messaging Administrator MS-200 
Description: Configure and manage SharePoint Online; configure and manage OneDrive for Business; configure and manage Teams; and configure and manage workload integrations.
Prerequisites: Experience with Windows PowerShell. Basic understanding of Active Directory and Azure AD. Basic understanding of mobile device management, and alternative operating systems (Android and macOS). Basic understanding of SQL Server management. Basic understanding of networking, including DNS. Working knowledge of windows server administration.  
Description: Configure and manage SharePoint On-Premises; configure and manage hybrid scenarios; and migrate to SharePoint Online.
Prerequisites: Teamwork Administrator Code MS-300  
Description: Implement and manage threat protection, implement and manage information protection and manage governance and compliance features in Microsoft 365.
Prerequisites: Basic conceptual understanding of Microsoft Azure. Experience with Windows 10 devices. Experience with Office 365. Basic understanding of authorization and authentication. Basic understanding of computer networks. Working knowledge of managing mobile devices.  
×

AZ-900 - Microsoft Azure Fundamentals

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificated Of Achievement
  4. 15% OFF on Exam & Practice Test
 

Course Duration: 1 Day

SATV: Yes

About This Course
This course will provide foundational level knowledge of cloud services and how those services are provided with Microsoft Azure. The course can be taken as an optional first step in learning about cloud services and Microsoft Azure, before taking further Microsoft Azure or Microsoft cloud services courses.

The course will cover general cloud computing concepts as well as general cloud computing models and services such as Public, Private and Hybrid cloud and Infrastructure-as-a-Service (IaaS), Platform-as-a-Service(PaaS) and Software-as-a-Service (SaaS).

It will also cover some core Azure services and solutions, as well as key Azure pillar services concerning security, privacy, compliance and trust. It will finally cover pricing and support services available with Azure.

Audience Profile
There are no pre-requisites for taking this course. It is targeted for anyone that wants to learn more about Microsoft Azure.
At Course Completion

After completing this course, students will be able to:
Understand general cloud computing concepts
Understand core services available with Microsoft Azure
Understand security, privacy, compliance and trust with Microsoft Azure
Understand pricing and support models available with Microsoft

Prerequisites

  • There are no pre-requisites for taking this course. Technical IT experience is not required however some general IT knowledge or experience would be beneficial.

 

Course Outline

Subject
Module 1: Cloud Concepts
Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS) and Software-as-a-Service (SaaS) Public, Private, and Hybrid cloud models
Understand general cloud computing concepts
Module 2: Core Azure Services
Core Azure architectural components
Core Azure Services and Products
Azure Solutions
Azure management tools
Understand core services available with Microsoft Azure
Module 3: Security, Privacy, Compliance and Trust
Securing network connectivity in Azure
Azure governance methodologies
Monitoring and Reporting in Azure
Privacy, Compliance and Data Protection standards in Azure
Understand security, privacy, compliance and trust with Microsoft Azure
Module 4: Azure Pricing and Support
Azure subscriptions
Planning and managing costs
Support options available with Azure
Service lifecycle in Azure
Understand pricing and support models available with Microsoft
8 hours
 
×

AZ-103 - Microsoft Azure Administrator

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificate Of Achievement
  4. 15% OFF on Exam & Practice Test
 

Course Duration: 4 Days

SATV: Yes

About This Course
This course teaches IT Professionals how to manage their Azure subscriptions, create and scale virtual machines, implement storage solutions, configure virtual networking, back up and share data, connect Azure and on-premises sites, manage network traffic, implement Azure Active Directory, secure identities, and monitor your solution.

Audience Profile
This course is for Azure Administrators. Azure Administrators manage the cloud services that span storage, networking and compute cloud capabilities, with a deep understanding of each service across the full IT lifecycle. They take end-user requests for new cloud applications and make recommendations on services to use for optimal performance and scale, as well as provision, size, monitor and adjust as appropriate. This role requires communicating and coordinating with vendors. Azure Administrators use the Azure Portal and as they become more proficient they use PowerShell and the Command Line Interface.

Prerequisites

  • There are no pre-requisites for taking this course. Technical IT experience is not required however some general IT knowledge or experience would be beneficial.

 

Course Outline

Module 1: Azure Administration
In this module, you’ll learn about to tooling Azure Administrator uses to manage their infrastructure. This includes the Azure Portal, Cloud Shell, Azure PowerShell, CLI, Resource Manager, and Resource Manager Templates. The demonstrations in this module will ensure you are successful in the course labs.

Lessons
Azure Portal and Cloud Shell
Azure PowerShell and CLI
Resource Manager
ARM Templates

Module 2: Azure Virtual Machines
In this module, you’ll learn about Azure virtual machines including planning, creating, availability and extensions.

Lessons
Virtual Machine Planning
Creating Virtual Machines
Virtual Machine Availability
Virtual Machine Extensions
Lab : Deploy and Manage Virtual Machines
Lab : Virtual Machines and Scale Sets

Module 3: Azure Storage
In this module, you’ll learn about basic storage features including storage accounts, blob storage, Azure files, and storage security.

Lessons
Storage Accounts
Azure Blobs
Azure Files
Storage Security
Lab : Implement and Manage Storage

Module 4: Virtual Networking
In this module, you’ll learn about basic virtual networking concepts like virtual networks, IP addressing, Azure DNS, and network security groups.

Lessons
Virtual Networks
IP Addressing and Endpoints
Azure DNS
Network Security Groups
Lab : Configure Azure DNS

Module 5: Intersite Connectivity
In this module, you’ll learn about intersite connectivity features including VNet Peering, VNet-to-VNet connections, Site-to-Site Connections, and ExpressRoute.

Lessons
VNet Peering
VNet-to-VNet Connections
ExpressRoute Connections
Lab : VNet Peering and Service Chaining

Module 6: Monitoring
In this module, you’ll learn about monitoring your Azure infrastructure including Azure Monitor, alerting, log analytics, and Network Watcher.

Lessons
Azure Monitor
Azure Alerts
Log Analytics
Network Watcher
Lab : Network Watcher

Module 7: Data Protection
In this module, you’ll learn about data replication strategies, backing up files and folders, and virtual machine backups.
Lessons
Data Replication
File and Folder Backups
Virtual Machine Backups
Lab : Azure Site Recovery Between Regions

Module 8: Network Traffic Management
In this module, you’ll learn about network traffic strategies including service endpoints, network routing, Azure Load Balancer, and Azure Traffic Manager.
Lessons
Network Routing
Azure Load Balancer
Azure Traffic Manager
Lab : Load Balancer and Traffic Manager

Module 9: Azure Active Directory
In this module, you’ll learn about Azure Active Directory (AD) including Azure AD Connect and Azure AD Join.
Lessons
Azure Active Directory
Azure AD Connect
Azure AD Join
Lab : Implement Directory Synchronization

Module 10: Securing Identities
In this module, you’ll learn how to secure identities including Multi-Factor Authentication, Azure AD Identity Protection, and Self-Service Password Reset.
Lessons
Multi-Factor Authentication
Azure AD Identity Protection
Self-Service Password Reset
Lab : Azure AD Identity Protection
Lab : Self-Service Password Reset

Module 11: Governance and Compliance
In this module, you’ll learn about managing your subscriptions and accounts including role-based access control, users and groups, and Azure policy.
Lessons
Subscriptions and Accounts
Role-Based Access Control (RBAC)
Users and Groups
Azure Policy
Lab : Role-Based Access Control
Lab : Governance and Compliance

Module 12: Data Services
In this module, you’ll learn how to effectively share data using Import and Export service, Data Box, Content Delivery Network, and File Sync.
Lessons
Content Delivery Network
File Sync
Import and Export Service
Data Box
Lab : File Sync

32 Hours 

 
×

AZ-203 - Developing Solutions for Microsoft Azure (Azure Developer Associate)

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificate Of Achievement
  4. 15% OFF on Exam & Practice Test
 

Course Duration: 6 Days

SATV: Yes

About This Course
In this course, students will gain the knowledge and skills needed to implement Azure IaaS services and features in their development solutions. The course covers provisioning virtual machines, using Batch Service to deploy/maintain resources, and how to create containerized solutions by using Azure Kubernetes Service.

In this course will gain the knowledge and skills needed to implement Azure Platform as a Service feature and services in their development solutions. Students will learn how to create and manage Azure App Service resources, integrate push and offline sync in their mobile apps, and how to document an API. Students will also learn how to create and test Azure Functions.

In this course, students will gain the knowledge and skills needed to leverage Azure storage services and features in their development solutions. It covers Azure Table storage, Azure Cosmos DB, Azure Blob, and developing against relational databases in Azure.

In this course, students will gain the knowledge and skills needed to include Azure authentication and authorization services in their development solutions. Students will learn how identity is managed and utilized in Azure solutions by using the Microsoft identity platform. Students will also learn about access control (claims-based authorization and role-based access control) and how to implement secure data solutions. Throughout the course, students learn how to create and integrate these resources by using the Azure CLI, REST, and application code.

In this course students will gain the knowledge and skills needed to ensure applications hosted in Azure are operating efficiently and as intended. Students will learn how Azure Monitor operates and how to use tools like Log Analytics and Application Insights to better understand what is happening in their application. Students will also learn how to implement autoscale, instrument their solutions to support monitoring and logging, and use Azure Cache and CDN options to enhance the end-user experience.

This course is all about communication between apps and services. Students will learn how to create and manage their own APIs by using API Management, and how to use the different event- and message-based services in Azure within their development solutions. Throughout the course students learn how to create and integrate these resources by using the Azure Portal, Azure CLI, REST, and application code.

Audience Profile
Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.

Prerequisites

  • Students should have 1-2 years of experience as a developer. This course assumes students know how to code and have a fundamental knowledge of Azure.
  • It is recommended that students have some experience with PowerShell or Azure CLI, working in the Azure portal, and with at least one Azure-supported programming language. Most of the examples in this course are presented in C\# .NET.

 

Course Outline

Module 1: Implement solutions that use virtual machines
Students will learn how to properly plan for VM deployment. It covers VM creation by using the Azure Portal, PowerShell, and through code. It also covers creating and using ARM templates for repeatable deployments and how to use Azure Disk Encryption to secure information on the VM.

Lessons
Provision VMs
Create ARM templates
Configure Azure Disk Encryption for VMs
After completing this module, students will be able to:
Learn how to create and deploy virtual machines by using the Azure Portal, PowerShell, and through code.
Learn how to create and deploy Azure Resource Manager templates by using the Azure Portal and Visual Studio.
Understand the different encryption options and learn how to encrypt existing and new deployments.

Module 2: Implement batch jobs by using Azure Batch Services
Azure Batch creates and manages a pool of compute nodes (virtual machines), installs the applications you want to run, and schedules jobs to run on the nodes.

Lessons
Azure Batch overview
Run a batch job by using the Azure CLI and Azure Portal
Run batch jobs by using code
Manage batch jobs by using the Batch Service API
After completing this module, students will be20191003 able to:
Understand how the Azure Batch service works
Learn how to create and run batch jobs by using the Azure CLI
Learn how to create and run batch jobs by using code
Learn how to use the Azure Batch Service API to manage jobs

Module 3: Create containerized solutions
You can build and run modern, portable, microservices-based applications that benefit from Kubernetes orchestrating and managing the availability of those application components. Kubernetes supports both stateless and stateful applications as teams progress through the adoption of microservices-based applications.

Lessons
Create an Azure Managed Kubernetes Service (AKS) cluster
Create container images for solutions
Publish an image to the Azure Container Registry
Run containers by using Azure Container Instance or AKS
After completing this module, students will be able to:
Learn core concepts for Azure Kubernetes Service (AKS)
Learn how to deploy AKS clusters
Publish an image to the Azure Container Registry
Learn about Azure Container Instances and how to deploy to them

Module 4: Create App Service web apps
Azure App Service Web Apps (or just Web Apps) is a service for hosting web applications, REST APIs, and mobile back ends. Web Apps not only adds the power of Microsoft Azure to your application, such as security, load balancing, autoscaling, and automated management.

Lessons
Azure App Service core concepts
Creating an Azure App Service web app
Creating background tasks by using WebJobs in Azure App Service
After completing this module, students will be able to:
Understand App Service core concepts and capabilities
Know how to create App Service web apps by using Azure CLI, Azure Portal, and PowerShell.
Be able to create continuous and triggered WebJobs

Module 5: Creating Azure App Service mobile apps
The Mobile Apps feature of Azure App Service gives enterprise developers and system integrators a mobile-application development platform that’s highly scalable and globally available.

Lessons
Getting started with mobile apps in App Service
Enable push notifications for your app
Enable offline sync for your app
After completing this module, students will be able to:
Push their app on to the Mobile App service
How to register apps for push notifications

Module 6: Create Azure App Service API apps
This module covers how to create and document an Azure App Service API.
Lessons
Creating APIs
Using Swagger to document an API
After completing this module, students will be able to:
Know how to create an APIM instance and create a new API
Know how to use Swashbuckle to create Swagger objects in ASP.NET Core

Module 7: Implement Azure Functions
Azure Functions is a solution for easily running small pieces of code, or “functions,” in the cloud. You can write just the code you need for the problem at hand, without worrying about a whole application or the infrastructure to run it.

Lessons
Azure Functions overview
Develop Azure Functions using Visual Studio
Implement durable functions
After completing this module, students will be able to:
Understand the core features and functionality of Azure Functions
Be able to create functions, bindings, and triggers
Know common patters for Durable Functions and be able to create them

Module 8: Develop solutions that use Azure Table storage
Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. Because Table storage is schemaless, it’s easy to adapt your data as the needs of your application evolve.

Lessons
Azure Table storage overview
Authorization in Table storage
Table service REST API
After completing this module, students will be able to:
Understand the features and uses of Azure Table storage
Know how to utilize Shared Key authorization
Know how to use the Azure Table storage REST service to manage data

Module 9: Develop solutions that use Azure Cosmos DB storage
This module covers Azure Cosmos DB storage. It instructs students on how it works, how to manage containers and items, and create and update documents by using code.

Lessons
Azure Cosmos DB overview
Managing containers and items
Create and update documents by using code
After completing this module, students will be able to:
Understand core features and functionality of Azure Cosmos DB
Be able to manage containers and items
Be able to create and update documents

Module 10: Develop solutions that use a relational database
SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML.

Lessons
Azure SQL overview
Create, read, update, and delete database tables by using code
After completing this module, students will be able to:
Know how the Azure SQL Database service works
Be able to perform database operations by using code

Module 11: Develop solutions that use Microsoft Azure Blob storage
Azure Blob storage is Microsoft’s object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that does not adhere to a particular data model or definition, such as text or binary data.

Lessons
Azure Blob storage overview
Working with Azure Blob storage
After completing this module, students will be able to:
Understand when and why to use Azure Blob storage
Know how to set and retrieve Blob storage properties and metadata
Know how to replicate and copy Blobs

Module 12: Implement authentication
Microsoft identity platform is an evolution of the Azure Active Directory (Azure AD) identity service and developer platform. It allows developers to build applications that sign in all Microsoft identities, get tokens to call Microsoft Graph, other Microsoft APIs, or APIs that developers have built.

Lessons
Microsoft identity platform
Implement OAuth2 authentication
Implement managed identities for Azure resources
Implement authentication by using certificates, forms-based authentication, or tokens
Implement multi-factor authentication
After completing this module, students will be able to:
Understand the architecture of the Microsoft identity platform
Be able to implement OAuth2 authentication in their solutions
Be able to use Azure Key Vault to store and retrieve authentication information

Module 13: Implement access control
This module covers claims-based and role-based access control.

Lessons
Claims-based authorization
Role-based access control (RBAC) authorization
After completing this module, students will be able to:
Learn how to use claims-based authorization in their development solutions
How to manage access to resources using RBAC through the REST API

Module 14: Implement secure data solutions
This module covers securing data at rest and during transmission.

Lessons
Encryption options
End-to-end encryption
Implement Azure confidential computing
Manage cryptographic keys in Azure Key Vault
After completing this module, students will be able to:
Understand encryption options
Learn how to encrypt data with Transparent Data Encryption
Manage and utilize encryption keys by using the Azure key Vault

Module 15: Introduction to Azure Monitor
Azure Monitor is the central service that includes all of tools you need to monitor and optimize your solution.

Lessons
Overview of Azure Monitor
After completing this module, students will be able to:
Understand how Azure Monitor works
Know where and how Azure Monitor collects data

Module 16: Develop code to support scalability of apps and services
This module covers how applications scale and how to handle some troubleshooting.

Lessons
Implement autoscale
Implement code that addresses singleton application instances
Implement code that handles transient faults
After completing this module, students will be able to:
Understand autoscale patterns and best practices for scaling their solutions
How to use the Azure CLI to communicate with a specific copy of a resource
How to handle transient faults in your solution

Module 17: Instrument solutions to support monitoring and logging
This module covers adding code to your app to send the data to Azure Monitor.

Lessons
Configure instrumentation in an app or server by using Application Insights
Analyze and troubleshoot solutions by using Azure Monitor
After completing this module, students will be able to:
Know how to add default code to web pages, console apps, and Windows desktop apps to support telemetry
Know how to use dashboards and other tools to monitor and troubleshoot their app

Module 18: Integrate caching and content delivery within solutions
This module shows students how to leverage Azure Cache for Redis and Azure CDNs to deliver assets to users more quickly.

Lessons
Azure Cache for Redis
Develop for storage on CDNs
After completing this module, students will be able to:
Understand how Azure Cache for Redis operates and how to configure and interact with it
Know how to manage Azure CDN

Module 19: Develop an App Service Logic App
Logic Apps helps you build solutions that integrate apps, data, systems, and services across enterprises or organizations by automating tasks and business processes as workflows. This module covers what they are and how to create them.

Lessons
Azure Logic Apps overview
Create Logic Apps by using Visual Studio
Create custom connectors for Logic Apps
Create custom templates for Logic Apps
After completing this module, students will be able to:
Understand how to create and manage Azure Logic Apps.

Module 20: Integrate Azure Search within solutions
Azure Search is a search-as-a-service cloud solution that gives developers APIs and tools for adding a rich search experience over private, heterogenous content in web, mobile, and enterprise applications. In this module students will learn how to integrate Azure Search in to their solutions.

Lessons
Create and query an Azure Search Index
Full text search in Azure Search
After completing this module, students will be able to:
Provision the service, create an index, load data, and execute searches.

Module 21: API Management
API Management (APIM) helps organizations publish APIs to external, partner, and internal developers to unlock the potential of their data and services.

Lessons
Introduction to the API Management service
Securing your APIs
Defining API policies
After completing this module, students will be able to:
Provision the APIM service using the Azure Portal, secure APIs with subscriptions and client certificates, and use API policies to modify the behavior of an API.

Module 22: Develop event-based solutions
This module covers developing event-based solutions in Azure by integrating Azure Event Grid, Event Hubs, and Notification Hubs in your applications.

Lessons
Implement solutions that use Azure Event Grid
Implement solutions that use Azure Event Hubs
Implement solutions that use Azure Notification Hubs
After completing this module, students will:
Know how the services work and how to integrate them in to their solutions.

Module 23: Develop message-based solutions
Microsoft Azure Service Bus is a fully managed enterprise integration message broker. Service Bus is most commonly used to decouple applications and services from each other, and is a reliable and secure platform for asynchronous data and state transfer. Azure Queue storage is a service for storing large numbers of messages that can be accessed from anywhere in the world via authenticated calls using HTTP or HTTPS.
Lessons
Implement solutions that use Azure Service Bus
Implement solutions that use Azure Queue Storage queues
After completing this module, students will be able to:
Understand how to leverage Azure message-based services in their solutions.

48 Hours 

 
Description: This course provides an introduction to HTML5, CSS3, and JavaScript. This course helps students gain basic HTML5/CSS3/JavaScript programming skills. They are intended to focus on the principles and coding components/structures that are used to establish an HTML5 software application.
Prerequisites: Experience creating Web applications, including writing simple JavaScript code, creating Windows client applications, use of Visual Studio 2017. 
Description: Develop advanced ASP.NET MVC applications using .NET Framework tools and technologies. The focus will be on coding activities that enhance the performance and scalability of a web application. ASP.NET MVC will be introduced and compared with Web Forms so that students know when each should/could be used.
Prerequisites: Experience developing web-based applications by using Microsoft Visual Studio and Microsoft ASP.NET, proficiency in using the .NET Framework, and some familiarity with the C# language. 
Description: The main purpose of the course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. 
Description: The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.
Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. 
Description: The course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI. This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.
Prerequisites: Basic knowledge of relational databases. Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals. Basic knowledge of data analytics equivalent to having attended course 10994. 
Description: Course provides students with the knowledge and skills analyze data with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
Prerequisites: Excellent knowledge of relational databases and reporting. Some basic knowledge of data warehouse schema topology (including star and snowflake schemas). Some exposure to basic programming constructs (such as looping and branching). An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable. Familiarity with Microsoft Office applications – particularly Excel. 
Description: The course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing storage and compute by using Windows Server 2016, and who need to understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016.
Prerequisites: A basic understanding of networking fundamentals. An awareness and understanding of security best practices. An understanding of basic AD DS concepts. Basic knowledge of server hardware. Experience supporting and configuring Windows client operating systems such as Windows 8 or Windows 10. 
Description: The course provides the fundamental networking skills required to deploy and support Windows Server 2016 in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking.
Prerequisites: Experience working with Windows Server 2008 or Windows Server 2012 Experience working in a Windows Server infrastructure enterprise environment. Knowledge of the Open Systems Interconnection (OSI) model. Understanding of core networking infrastructure components and technologies such as cabling, routers, hubs, and switches. Familiarity with networking topologies and architectures such as local area networks (LANs), wide area networks (WANs) and wireless networking. Some basic knowledge of the TCP/IP protocol stack, addressing and name resolution. Experience with and knowledge of Hyper-V and virtualization. Hands-on experience working with the Windows client operating systems such as Windows 8.1 or Windows 10. 
Description: The course teaches IT professionals how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory–related issues with Windows Server 2016. Additionally, this course teaches students how to deploy other Active Directory server roles, such as Active Directory Federation Services (AD FS) and Active Directory Certificate Services (AD CS).
Prerequisites:
Description: The course is designed for candidates looking to demonstrate foundational knowledge on the considerations and benefits of adopting cloud services in general and the Software as a Service (SaaS) cloud model. This exam will also cover knowledge of available options and benefits gained by implementing Microsoft 365 cloud service offerings. .
Prerequisites:
$("div").text($("form").serialize());
Description: This course will provide you with the knowledge and skills to plan and administer a Microsoft SharePoint 2016 environment. The course teaches you how to deploy, administer, and troubleshoot your SharePoint environment. This course also provides guidelines, best practices, and considerations that help you optimize your SharePoint deployment.
Prerequisites: An ideal candidate for this course must have at least one year of experience with deploying and administering multiple SharePoint 2013 farms across a large enterprise. Because many customers have not upgraded from SharePoint 2010, a candidate can also have at least two years of experience with SharePoint 2010. However, they also must understand the differences between SharePoint 2010 and SharePoint 2013, particularly in terms of hybridization. 
Description: This course will teach you how to plan, configure, and manage the advanced features in a SharePoint 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Students also will learn about business intelligence solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016.
Prerequisites: An ideal candidate for this course must have at least one year experience with deploying and administering multiple SharePoint Server 2013 farms across a large enterprise. The candidate should have completed Course 20339-1A: Planning and Administering Microsoft SharePoint 2016, or should demonstrate equivalent skills. 
Description: In this course, you will use Configuration Manager and its associated site systems to efficiently manage network resources. You will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You will also discover how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports.
Prerequisites: Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management Installation, configuration, and troubleshooting for Windows-based personal computers Basic concepts of public key infrastructure (PKI) security Basic understanding of scripting and Windows PowerShell syntax Basic understanding of Windows Server roles and services Basic understanding of the configuration options for iOS, Android, and Windows Mobile device platforms. 
Description: This course that describes the integration of various online cloud services with Microsoft System Center Configuration Manager. This course covers integration with online services such as Microsoft Store for Business, Microsoft Office 365, and Microsoft Azure. It also describes how to manage mobile devices by using methods such as on-premises mobile device management and Exchange Server integration.
Prerequisites: To help you prepare for this class, attend the following course: Course 20703-1A: Administering System Center Configuration Manager. 
×

10979F - Introduction to Microsoft Azure for IT Professionals

This course provides the underlying knowledge required by ITPros/Devs who will be evaluating Microsoft Azure, whether they are administrators, developers, or database administrators.
 
This course introduces students to the principles of cloud computing. Students will become familiar with how these principles have been implemented in Microsoft Azure. In addition, this course explains how to implement the core Azure infrastructure, consisting of virtual networks and storage. With this foundation, students will be able to create the most common Azure services, including Azure Virtual Machines, Web Apps, and Azure SQL Database. The students will also learn about container-based Azure services and the most prominent examples of serverless computing. The course concludes by describing features of Azure Active Directory (Azure AD).
 
Audience Profile
This course is intended for individuals who want to evaluate deploying, configuring, and administering services and virtual machines (VMs) by using Azure. This includes:
  • Developers who want to evaluate creating Azure solutions.
  • Windows Server administrators who want to evaluate the migration of on-premises Active Directory roles and services to the cloud.
  • IT professionals who want to evaluate the use of Azure to host websites and mobile app back-end services.
  • Database administrators who want to evaluate the use of Azure to host SQL databases.
 
At Course Completion
After completing this course, students will be able to:
  • Describe cloud computing, Azure, and Azure subscriptions.
  • Use Azure PowerShell, the Azure Software Development Kit (SDK), and the Azure command-line interface (CLI) to manage Azure subscriptions.
  • Create and configure virtual machines in Azure, and manage their disks.
  • Create, configure, and monitor web apps in Azure and deploy Azure platform as a service (PaaS) cloud services.
  • Create and configure Azure virtual networks.
  • Create, manage, and configure cloud storage in Azure.
  • Use Azure SQL Database to create, configure, and manage SQL databases.
  • Create and manage Azure AD.
 
Prerequisites
Before attending this course, students must have a background in IT. In addition to their professional experience, students who attend this training should already have the following technical knowledge:
  • Understanding of how to deploy websites
  • A basic understanding of virtualization
  • A basic understanding of Active Directory concepts, including domains, users, and domain controllers
  • A basic understanding of database concepts, including tables and simple queries
 
Course Outline
Module 1: Getting started with Microsoft Azure
This module introduces students to cloud services and the various Azure services. It describes how to use the Azure portal to access and manage Azure services, and to manage Azure subscription and billing.
Lessons
  • What is cloud computing?
  • What is Azure?
  • Managing Azure
  • Subscription management, support, and billing
Lab : Using the Azure portals
  • Customizing the Azure portal interface
  • Viewing billing, usage, and quotas data
After completing this module, you will be able to:
  • Describe cloud computing.
  • Describe Azure and its various services.
  • Manage Azure services from the Azure portal.
  • Manage your Azure subscription and billing. 
     
Module 2: Microsoft Azure management tools
This module explains Azure PowerShell and its use in managing Azure subscriptions. It also describes how to use the Azure SDK and the Azure CLI to manage Azure subscriptions.
Lessons
  • What is Azure PowerShell?
  • Azure SDK and Azure CLI
Lab : Using Microsoft Azure management tools
  • Using the Azure PowerShell modules
  • Using the Azure CLIAfter completing this module, you will be able to:
  • Describe and use Azure PowerShell to manage your Azure subscription.
  • Describe the Visual Studio Tools for Azure and use the Azure CLI to manage your Azure subscription. 
     
Module 3: Virtual machines in Microsoft Azure
This module explains how to create and configure virtual machines in Azure and how to manage disks for virtual machines.
Lessons
  • Creating and configuring Azure VMs
  • Configuring Azure VM storage
Lab : Creating a VM in Azure
  • Creating a VM from the Azure portal by using an Azure Marketplace image
  • Verifying the functionality of the VM
  • Configuring storage of a VM
After completing this module, you will be able to:
  • Create and configure VMs in Azure.
  • Configure VM availability.
  • Configure disks for VMs. 
     
Module 4: Azure Web Apps
This module explains how to create, configure, and monitor web apps in Azure.
Lessons
  • Creating and configuring Azure web apps
  • Deploying and monitoring Azure web apps
Lab : Creating and managing Azure web apps
  • Creating and configuring an Azure web app
After completing this module, you will be able to:
  • Create and configure web apps in Microsoft Azure.
  • Deploy and monitor Azure web apps. 
     
Module 5: Implementing Azure networking
This module explains how to create and implement Azure networks and how to use their components to enhance the resiliency and availability of virtual machines.
Lessons
  • Getting started with Azure networking
  • Getting started with Azure Load Balancer
Lab : Creating and configuring virtual networks
  • Creating a virtual network
  • Creating an Azure load balancer
After completing this module, you will be able to:
  • Describe the purpose and functionality of Azure networking and Azure virtual networks.
  • Create Azure virtual networks.
  • Describe and implement Azure Load Balancer. 
     
Module 6: Introduction Azure Storage and Data Services
This module explains the features and benefits of Azure storage and data services.
Lessons
  • Understanding Azure Storage options
  • Creating and managing storage
  • Understanding options for relational database deployments
  • Creating and connecting to Azure SQL databases
Lab : Configuring Azure Storage
  • Creating and configuring an Azure Storage account
  • Creating and managing blobs
Lab : Creating a SQL Database in Azure
  • Creating a new Azure SQL database in Azure and configuring SQL Server firewall rules
  • Managing content of an Azure SQL database by using SQL Server Management Studio
After completing this module, you will be able to:
  • Describe the features and benefits of Microsoft Azure Storage.
  • Create and manage Azure Storage.
  • Describe options for relational database deployment in Microsoft Azure.
  • Create, connect to, and manage the content of Microsoft Azure SQL Database instances. 
     
Module 7: Introduction to containers and serverless computing in Azure
This module explains the options for implementing containers and describes the serverless technologies available in Azure.
Lessons
  • Implementing Windows and Linux containers in Azure
  • Introduction to Azure serverless computing
Lab : Implementing containers on Azure VMs
  • Implementing Docker hosts on Azure VMs
  • Deploying containers to Azure VMs
  • Deploying multicontainer applications with Docker Compose to Azure VMs
After completing this module, you will be able to:
  • Describe the options for implementing containers in Azure.
  • Describe the serverless technologies available in Azure. 
     
Module 8: Configuring and managing Azure AD
This module explains how to create users, domains, and directories in Azure AD, integrate applications with Azure AD, and use Multi-Factor Authentication.
Lessons
  • Overview of Azure AD
  • Manage Azure AD authentication and authorization
Lab : Create and manage Azure Active Directory
After completing this module, you will be able to:
  • Create and manage Azure AD tenants, domains, and users.
  • Manage Azure AD authentication and authorization.
 
×

AZ-300 Azure Solutions Architect Technologies

Description

Materials Include:
  1. Microsoft Official Courseware
  2. Microsoft Official Virtual Labs
  3. Official Microsoft Certificate Of Achievement
  4. 15% OFF on Exam & Practice Test
 

Course Duration: 6 Days

SATV: Yes

About This Course
In this course, students will gain the knowledge and skills needed to implement Azure IaaS services and features in their development solutions. The course covers provisioning virtual machines, using Batch Service to deploy/maintain resources, and how to create containerized solutions by using Azure Kubernetes Service.

In this course will gain the knowledge and skills needed to implement Azure Platform as a Service feature and services in their development solutions. Students will learn how to create and manage Azure App Service resources, integrate push and offline sync in their mobile apps, and how to document an API. Students will also learn how to create and test Azure Functions.

In this course, students will gain the knowledge and skills needed to leverage Azure storage services and features in their development solutions. It covers Azure Table storage, Azure Cosmos DB, Azure Blob, and developing against relational databases in Azure.

In this course, students will gain the knowledge and skills needed to include Azure authentication and authorization services in their development solutions. Students will learn how identity is managed and utilized in Azure solutions by using the Microsoft identity platform. Students will also learn about access control (claims-based authorization and role-based access control) and how to implement secure data solutions. Throughout the course, students learn how to create and integrate these resources by using the Azure CLI, REST, and application code.

In this course students will gain the knowledge and skills needed to ensure applications hosted in Azure are operating efficiently and as intended. Students will learn how Azure Monitor operates and how to use tools like Log Analytics and Application Insights to better understand what is happening in their application. Students will also learn how to implement autoscale, instrument their solutions to support monitoring and logging, and use Azure Cache and CDN options to enhance the end-user experience.

This course is all about communication between apps and services. Students will learn how to create and manage their own APIs by using API Management, and how to use the different event- and message-based services in Azure within their development solutions. Throughout the course students learn how to create and integrate these resources by using the Azure Portal, Azure CLI, REST, and application code.

Audience Profile
Students in this course are interested in Azure development or in passing the Microsoft Azure Developer Associate certification exam.

Prerequisites

  • Students should have 1-2 years of experience as a developer. This course assumes students know how to code and have a fundamental knowledge of Azure.
  • It is recommended that students have some experience with PowerShell or Azure CLI, working in the Azure portal, and with at least one Azure-supported programming language. Most of the examples in this course are presented in C\# .NET.

 

Course Outline

Module 1: Implement solutions that use virtual machines
Students will learn how to properly plan for VM deployment. It covers VM creation by using the Azure Portal, PowerShell, and through code. It also covers creating and using ARM templates for repeatable deployments and how to use Azure Disk Encryption to secure information on the VM.

Lessons
Provision VMs
Create ARM templates
Configure Azure Disk Encryption for VMs
After completing this module, students will be able to:
Learn how to create and deploy virtual machines by using the Azure Portal, PowerShell, and through code.
Learn how to create and deploy Azure Resource Manager templates by using the Azure Portal and Visual Studio.
Understand the different encryption options and learn how to encrypt existing and new deployments.

Module 2: Implement batch jobs by using Azure Batch Services
Azure Batch creates and manages a pool of compute nodes (virtual machines), installs the applications you want to run, and schedules jobs to run on the nodes.

Lessons
Azure Batch overview
Run a batch job by using the Azure CLI and Azure Portal
Run batch jobs by using code
Manage batch jobs by using the Batch Service API
After completing this module, students will be able to:
Understand how the Azure Batch service works
Learn how to create and run batch jobs by using the Azure CLI
Learn how to create and run batch jobs by using code
Learn how to use the Azure Batch Service API to manage jobs

Module 3: Create containerized solutions
You can build and run modern, portable, microservices-based applications that benefit from Kubernetes orchestrating and managing the availability of those application components. Kubernetes supports both stateless and stateful applications as teams progress through the adoption of microservices-based applications.

Lessons
Create an Azure Managed Kubernetes Service (AKS) cluster
Create container images for solutions
Publish an image to the Azure Container Registry
Run containers by using Azure Container Instance or AKS
After completing this module, students will be able to:
Learn core concepts for Azure Kubernetes Service (AKS)
Learn how to deploy AKS clusters
Publish an image to the Azure Container Registry
Learn about Azure Container Instances and how to deploy to them

Module 4: Create App Service web apps
Azure App Service Web Apps (or just Web Apps) is a service for hosting web applications, REST APIs, and mobile back ends. Web Apps not only adds the power of Microsoft Azure to your application, such as security, load balancing, autoscaling, and automated management.

Lessons
Azure App Service core concepts
Creating an Azure App Service web app
Creating background tasks by using WebJobs in Azure App Service
After completing this module, students will be able to:
Understand App Service core concepts and capabilities
Know how to create App Service web apps by using Azure CLI, Azure Portal, and PowerShell.
Be able to create continuous and triggered WebJobs

Module 5: Creating Azure App Service mobile apps
The Mobile Apps feature of Azure App Service gives enterprise developers and system integrators a mobile-application development platform that’s highly scalable and globally available.

Lessons
Getting started with mobile apps in App Service
Enable push notifications for your app
Enable offline sync for your app
After completing this module, students will be able to:
Push their app on to the Mobile App service
How to register apps for push notifications

Module 6: Create Azure App Service API apps
This module covers how to create and document an Azure App Service API.
Lessons
Creating APIs
Using Swagger to document an API
After completing this module, students will be able to:
Know how to create an APIM instance and create a new API
Know how to use Swashbuckle to create Swagger objects in ASP.NET Core

Module 7: Implement Azure Functions
Azure Functions is a solution for easily running small pieces of code, or “functions,” in the cloud. You can write just the code you need for the problem at hand, without worrying about a whole application or the infrastructure to run it.

Lessons
Azure Functions overview
Develop Azure Functions using Visual Studio
Implement durable functions
After completing this module, students will be able to:
Understand the core features and functionality of Azure Functions
Be able to create functions, bindings, and triggers
Know common patters for Durable Functions and be able to create them

Module 8: Develop solutions that use Azure Table storage
Azure Table storage is a service that stores structured NoSQL data in the cloud, providing a key/attribute store with a schemaless design. Because Table storage is schemaless, it’s easy to adapt your data as the needs of your application evolve.

Lessons
Azure Table storage overview
Authorization in Table storage
Table service REST API
After completing this module, students will be able to:
Understand the features and uses of Azure Table storage
Know how to utilize Shared Key authorization
Know how to use the Azure Table storage REST service to manage data

Module 9: Develop solutions that use Azure Cosmos DB storage
This module covers Azure Cosmos DB storage. It instructs students on how it works, how to manage containers and items, and create and update documents by using code.

Lessons
Azure Cosmos DB overview
Managing containers and items
Create and update documents by using code
After completing this module, students will be able to:
Understand core features and functionality of Azure Cosmos DB
Be able to manage containers and items
Be able to create and update documents

Module 10: Develop solutions that use a relational database
SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML.

Lessons
Azure SQL overview
Create, read, update, and delete database tables by using code
After completing this module, students will be able to:
Know how the Azure SQL Database service works
Be able to perform database operations by using code

Module 11: Develop solutions that use Microsoft Azure Blob storage
Azure Blob storage is Microsoft’s object storage solution for the cloud. Blob storage is optimized for storing massive amounts of unstructured data. Unstructured data is data that does not adhere to a particular data model or definition, such as text or binary data.

Lessons
Azure Blob storage overview
Working with Azure Blob storage
After completing this module, students will be able to:
Understand when and why to use Azure Blob storage
Know how to set and retrieve Blob storage properties and metadata
Know how to replicate and copy Blobs

Module 12: Implement authentication
Microsoft identity platform is an evolution of the Azure Active Directory (Azure AD) identity service and developer platform. It allows developers to build applications that sign in all Microsoft identities, get tokens to call Microsoft Graph, other Microsoft APIs, or APIs that developers have built.

Lessons
Microsoft identity platform
Implement OAuth2 authentication
Implement managed identities for Azure resources
Implement authentication by using certificates, forms-based authentication, or tokens
Implement multi-factor authentication
After completing this module, students will be able to:
Understand the architecture of the Microsoft identity platform
Be able to implement OAuth2 authentication in their solutions
Be able to use Azure Key Vault to store and retrieve authentication information

Module 13: Implement access control
This module covers claims-based and role-based access control.

Lessons
Claims-based authorization
Role-based access control (RBAC) authorization
After completing this module, students will be able to:
Learn how to use claims-based authorization in their development solutions
How to manage access to resources using RBAC through the REST API

Module 14: Implement secure data solutions
This module covers securing data at rest and during transmission.

Lessons
Encryption options
End-to-end encryption
Implement Azure confidential computing
Manage cryptographic keys in Azure Key Vault
After completing this module, students will be able to:
Understand encryption options
Learn how to encrypt data with Transparent Data Encryption
Manage and utilize encryption keys by using the Azure key Vault

Module 15: Introduction to Azure Monitor
Azure Monitor is the central service that includes all of tools you need to monitor and optimize your solution.

Lessons
Overview of Azure Monitor
After completing this module, students will be able to:
Understand how Azure Monitor works
Know where and how Azure Monitor collects data

Module 16: Develop code to support scalability of apps and services
This module covers how applications scale and how to handle some troubleshooting.

Lessons
Implement autoscale
Implement code that addresses singleton application instances
Implement code that handles transient faults
After completing this module, students will be able to:
Understand autoscale patterns and best practices for scaling their solutions
How to use the Azure CLI to communicate with a specific copy of a resource
How to handle transient faults in your solution

Module 17: Instrument solutions to support monitoring and logging
This module covers adding code to your app to send the data to Azure Monitor.

Lessons
Configure instrumentation in an app or server by using Application Insights
Analyze and troubleshoot solutions by using Azure Monitor
After completing this module, students will be able to:
Know how to add default code to web pages, console apps, and Windows desktop apps to support telemetry
Know how to use dashboards and other tools to monitor and troubleshoot their app

Module 18: Integrate caching and content delivery within solutions
This module shows students how to leverage Azure Cache for Redis and Azure CDNs to deliver assets to users more quickly.

Lessons
Azure Cache for Redis
Develop for storage on CDNs
After completing this module, students will be able to:
Understand how Azure Cache for Redis operates and how to configure and interact with it
Know how to manage Azure CDN

Module 19: Develop an App Service Logic App
Logic Apps helps you build solutions that integrate apps, data, systems, and services across enterprises or organizations by automating tasks and business processes as workflows. This module covers what they are and how to create them.

Lessons
Azure Logic Apps overview
Create Logic Apps by using Visual Studio
Create custom connectors for Logic Apps
Create custom templates for Logic Apps
After completing this module, students will be able to:
Understand how to create and manage Azure Logic Apps.

Module 20: Integrate Azure Search within solutions
Azure Search is a search-as-a-service cloud solution that gives developers APIs and tools for adding a rich search experience over private, heterogenous content in web, mobile, and enterprise applications. In this module students will learn how to integrate Azure Search in to their solutions.

Lessons
Create and query an Azure Search Index
Full text search in Azure Search
After completing this module, students will be able to:
Provision the service, create an index, load data, and execute searches.

Module 21: API Management
API Management (APIM) helps organizations publish APIs to external, partner, and internal developers to unlock the potential of their data and services.

Lessons
Introduction to the API Management service
Securing your APIs
Defining API policies
After completing this module, students will be able to:
Provision the APIM service using the Azure Portal, secure APIs with subscriptions and client certificates, and use API policies to modify the behavior of an API.

Module 22: Develop event-based solutions
This module covers developing event-based solutions in Azure by integrating Azure Event Grid, Event Hubs, and Notification Hubs in your applications.

Lessons
Implement solutions that use Azure Event Grid
Implement solutions that use Azure Event Hubs
Implement solutions that use Azure Notification Hubs
After completing this module, students will:
Know how the services work and how to integrate them in to their solutions.

Module 23: Develop message-based solutions
Microsoft Azure Service Bus is a fully managed enterprise integration message broker. Service Bus is most commonly used to decouple applications and services from each other, and is a reliable and secure platRegister for asynchronous data and state transfer. Azure Queue storage is a service for storing large numbers of messages that can be accessed from anywhere in the world via authenticated calls using HTTP or HTTPS.
Lessons
Implement solutions that use Azure Service Bus
Implement solutions that use Azure Queue Storage queues
After completing this module, students will be able to:
Understand how to leverage Azure message-based services in their solutions.

48 Hours 

 
×

AZ-301 Azure Solutions Architect Design

Description

The AZ-301 exam is targeted at experienced IT experts, the exam covers a variety of subjects and services, all of which are covered in Skylines Academy’s latest course. In order to understand core architect technologies, Skylines Academy will lead you through a series of sections, modules, and demos to prepare you for taking, and ultimately passing, the Microsoft Azure AZ-301 exam.

This course curriculum is as follows:

  • Determine Workload Requirements

  • Design Identity Management

  • Design a Data Solution

  • Establish Business Continuity

  • Design Deployment and Migrations

  • Design an Infrastructure Strategy

  • Example Designs

Lectures will educate you on the fundamental terms and principles of the Azure platform and demos will enable you with a hands-on experience using scenarios to empower you in the real world.

Welcome to the Skylines Academy AZ-301 course! We’re happy you’re joining us!


Note: If you took the AZ-300 course, there will be some overlap. There is a lot to repeat around subjects covered in AZ-300 to make sure you have the basis on core technologies that align with the curriculum. Where possible, I try to make the distinction but you will find that we need to cover core infrastructure topics again before moving onto design elements. Feel free to ignore these videos if you took my AZ-300 course, or watch them again for a good refresh before taking your AZ-301 exam. I continue to update this course based on design examples so you can try to take your hands on knowledge and think about it from an architecture perspective.

Who this course is for:
  • Azure Architects
  • IT Administrators
 
×

AZ-400 Azure DevOps Solutions

Candidates for this exam are DevOps professionals who combine people, processes, and technologies to continuously deliver valuable products and services that meet end user needs and business objectives. DevOps professionals streamline delivery by optimizing practices, improving communications and collaboration, and creating automation. They design and implement strategies for application code and infrastructure that allow for continuous integration, testing, delivery, monitoring, and feedback.

Candidates must be proficient with Agile practices. They must be familiar with both Azure administration and Azure development and experts in at least one of these areas. Azure DevOps professionals must be able to design and implement DevOps practices for version control, compliance, infrastructure as code, configuration management, build, release, and testing by using Azure technologies.

Skills measured

  • Design a DevOps strategy
  • Implement DevOps development processes
  • Implement continuous integration
  • Implement continuous delivery
  • Implement dependency management
  • Implement application infrastructure
  • Implement continuous feedback
 
×

AZ-500T00A Azure Security Technologies

Candidates for this exam are Microsoft Azure security engineers who implement security controls, maintain the security posture, manage identity and access, and protect data, applications, and networks. Candidates identify and remediate vulnerabilities by using a variety of security tools, implement threat protection, and respond to security incident escalations. As a Microsoft Azure security engineer, candidates often serve as part of a larger team dedicated to cloud-based management and security and may also secure hybrid environments as part of an end-to-end infrastructure.

Candidates for this exam should have strong skills in scripting and automation; a deep understanding of networking, virtualization, and cloud N-tier architecture; and a strong familiarity with cloud capabilities, Microsoft Azure products and services, and other Microsoft products and services.

Skills measured

  • Manage identity and access (20-25%)
  • Implement platform protection (35-40%)
  • Manage security operations (15-20%)
  • Secure data and applications (30-35%)
 
×

AI-100T01A Designing and Implementing an Azure AI Solution

Candidates for this exam analyze the requirements for AI solutions, recommend appropriate tools and technologies, and implements solutions that meet scalability and performance requirements.

Candidates translate the vision from solution architects and work with data scientists, data engineers, IoT specialists, and AI developers to build complete end-to-end solutions. Candidates design and implement AI apps and agents that use Microsoft Azure Cognitive Services and Azure Bot Service. Candidates can recommend solutions that use open source technologies.

Candidates understand the components that make up the Azure AI portfolio and the available data storage options.

Candidates implement AI solutions that use Cognitive Services, Azure bots, Azure Search, and data storage in Azure. Candidates understand when a custom API should be developed to meet specific requirements.

Skills measured

  • Analyze solution requirements (25-30%)
  • Design AI solutions (40-45%)
  • Implement and monitor AI solutions (25-30%)
 
×

DP-201T01A Designing an Azure Data Solution

Candidates for this exam are Microsoft Azure data engineers who collaborate with business stakeholders to identify and meet the data requirements to design data solutions that use Azure data services.

Azure data engineers are responsible for data-related tasks that include designing Azure data storage solutions that use relational and non-relational data stores, batch and real-time data processing solutions, and data security and compliance solutions.

Candidates for this exam must design data solutions that use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.

Skills measured

  • Design Azure data storage solutions (40-45%)
  • Design data processing solutions (25-30%)
  • Design for data security and compliance (25-30%)
 
×

DP-100T01A Designing and Implementing a Data Science Solution on Azure

Candidates for this exam apply scientific rigor and data exploration techniques to gain actionable insights and communicate results to stakeholders. Candidates use machine learning techniques to train, evaluate, and deploy models to build AI solutions that satisfy business objectives. Candidates use applications that involve natural language processing, speech, computer vision, and predictive analytics.

Candidates serve as part of a multi-disciplinary team that incorporates ethical, privacy, and governance considerations into the solution. Candidates typically have background in mathematics, statistics, and computer science.

Skills measured

  • Define and prepare the development environment (15-20%)
  • Prepare data for modeling (25-30%)
  • Perform feature engineering (15-20%)
  • Develop models (40-45%)
 
×

DP-200T01A Implementing an Azure Data Solution

Candidates for this exam are Microsoft Azure data engineers who collaborate with business stakeholders to identify and meet the data requirements to implement data solutions that use Azure data services.

Azure data engineers are responsible for data-related tasks that include provisioning data storage services, ingesting streaming and batch data, transforming data, implementing security requirements, implementing data retention policies, identifying performance bottlenecks, and accessing external data sources.

Candidates for this exam must be able to implement data solutions that use the following Azure services: Azure Cosmos DB, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Storage, Azure Data Factory, Azure Stream Analytics, Azure Databricks, and Azure Blob storage.

Skills measured

  • Implement data storage solutions (40-45%)
  • Manage and develop data processing (25-30%)
  • Monitor and optimize data solutions (30-35%)
 
×

20764 Administering a SQL Database Infrastructure

Course Duration: 5 Days

SATV: Yes

About This Course

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Audience Profile

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

At Course Completion

After completing this course, students will be able to:

  • Authenticate and authorize users

  • Assign server and database roles

  • Authorize users to access resources

  • Protect data with encryption and auditing

  • Describe recovery models and backup strategies

  • Backup SQL Server databases

  • Restore SQL Server databases

  • Automate database management

  • Configure security for the SQL Server agent

  • Manage alerts and notifications

  • Managing SQL Server using PowerShell

  • Trace access to SQL Server

  • Monitor a SQL Server infrastructure

  • Troubleshoot a SQL Server infrastructure

  • Import and export data

Course OutlineModule 1: SQL Server SecurityProtection of data within your Microsoft SQL Server databases is essential and requires a working knowledge of the issues and SQL Server security features. This module describes SQL Server security models, logins, users, partially contained databases, and cross-server authorization. Lessons
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Connect to databases
  • Authorization Across Servers
  • Partially Contained Databases
Lab : Authenticating Users
  • Create Logins
  • Create Database Users
  • Correct Application Login Issues
  • Configure Security for Restored Databases

After completing this module, you will be able to:

  • SQL Server basic concepts.

  • SQL Server connection authentication.

  • User login authorization to databases.

  • Partially contained databases.

  • Authorization across servers.

Module 2: Assigning Server and Database RolesUsing roles simplifies the management of user permissions. With roles, you can control authenticated users’ access to system resources based on each user’s job function—rather than assigning permissions user-by-user, you can grant permissions to a role, then make users members of roles. Microsoft SQL Server includes support for security roles defined at server level and at database level. Lessons
  • Working with server roles
  • Working with Fixed Database Roles
  • Assigning User-Defined Database Roles
Lab : Assigning server and database roles
  • Assigning Server Roles
  • Assigning Fixed Database Roles
  • Assigning User-Defined Database Roles
  • Verifying Security

After completing this module, you will be able to:

  • Describe and use server roles to manage server-level security.

  • Describe and use fixed database roles.

  • Use custom database roles and application roles to manage database-level security.

Module 3: Authorizing Users to Access ResourcesIn the previous modules, you have seen how Microsoft SQL Server security is organized and how sets of permissions can be assigned at the server and database level by using fixed server roles, user-defined server roles, fixed database roles, and application roles. The final step in authorizing users to access SQL Server resources is the authorization of users and roles to access server and database objects. In this module, you will see how these object permissions are managed. In addition to access permissions on database objects, SQL Server provides the ability to determine which users are allowed to execute code, such as stored procedures and functions. In many cases, these permissions and the permissions on the database objects are best configured at the schema level rather than at the level of the individual object. Schema-based permission grants can simplify your security architecture. You will explore the granting of permissions at the schema level in the final lesson of this module.Lessons
  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level
Lab : Authorizing users to access resources
  • Granting, Denying, and Revoking Permissions on Objects
  • Granting EXECUTE Permissions on Code
  • Granting Permissions at the Schema Level

After completing this module, you will be able to:

  • Authorize user access to objects.

  • Authorize users to execute code.

  • Configure permissions at the schema level.

Module 4: Protecting Data with Encryption and AuditingWhen configuring security for your Microsoft SQL Server systems, you should ensure that you meet any of your organization’s compliance requirements for data protection. Organizations often need to adhere to industry-specific compliance policies, which mandate auditing of all data access. To address this requirement, SQL Server provides a range of options for implementing auditing. Another common compliance requirement is the encryption of data to protect against unauthorized access in the event that access to the database files is compromised. SQL Server supports this requirement by providing transparent data encryption (TDE). To reduce the risk of information leakage by users with administrative access to a database, columns containing sensitive data—such as credit card numbers or national identity numbers—can be encrypted using the Always Encrypted feature. This module describes the available options for auditing in SQL Server, how to use and manage the SQL Server Audit feature, and how to implement encryption.Lessons
  • Options for auditing data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption
Lab : Using Auditing and Encryption
  • Working with SQL Server Audit
  • Encrypt a Column as Always Encrypted
  • Encrypt a Database using TDE

After completing this module, you will be able to:

  • Describe the options for auditing data access.

  • Implement SQL Server Audit.

  • Manage SQL Server Audit.

  • Describe and implement methods of encrypting data in SQL Server.

  • Implement encryption

Module 5: Recovery Models and Backup StrategiesOne of the most important aspects of a database administrator's role is ensuring that organizational data is reliably backed up so that, if a failure occurs, you can recover the data. Even though the computing industry has known about the need for reliable backup strategies for decades—and discussed this at great length—unfortunate stories regarding data loss are still commonplace. A further problem is that, even when the strategies in place work as they were designed, the outcomes still regularly fail to meet an organization’s operational requirements. In this module, you will consider how to create a strategy that is aligned with organizational needs, based on the available backup models, and the role of the transaction logs in maintaining database consistency.Lessons
  • Understanding Backup Strategies
  • SQL Server Transaction Logs
  • Planning Backup Strategies
Lab : Understanding SQL Server recovery models
  • Plan a Backup Strategy
  • Configure Database Recovery Models

After completing this module, you will be able to:

  • Describe various backup strategies.

  • Describe how database transaction logs function.

  • Plan SQL Server backup strategies.

Module 6: Backing Up SQL Server DatabasesIn the previous module, you learned how to plan a backup strategy for a SQL Server system. You can now learn how to perform SQL Server backups, including full and differential database backups, transaction log backups, and partial backups. In this module, you will learn how to apply various backup strategies.Lessons
  • Backing Up Databases and Transaction Logs
  • Managing Database Backups
  • Advanced Database Options
Lab : Backing Up Databases
  • Backing Up Databases
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup

After completing this module, you will be able to:

  • Perform backups of SQL Server databases and transaction logs.

  • Manage database backups.

  • Describe advanced backup options.

Module 7: Restoring SQL Server 2016 DatabasesIn the previous module, you learned how to create backups of Microsoft SQL Server 2016 databases. A backup strategy might involve many different types of backup, so it is essential that you can effectively restore them. You will often be restoring a database in an urgent situation. You must, however, ensure that you have a clear plan of how to proceed and successfully recover the database to the required state. A good plan and understanding of the restore process can help avoid making the situation worse. Some database restores are related to system failure. In these cases, you will want to return the system as close as possible to the state it was in before the failure. Some failures, though, are related to human error and you might wish to recover the system to a point before that error. The point-in-time recovery features of SQL Server 2016 can help you to achieve this. Because they are typically much larger, user databases are more likely to be affected by system failures than system databases. However, system databases can be affected by failures, and special care should be taken when recovering them. In particular, you need to understand how to recover each system database because you cannot use the same process for all system databases. In this module, you will see how to restore user and system databases and how to implement point-in-time recovery. Lessons
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
Lab : Restoring SQL Server Databases
  • Restoring a Database Backup
  • Restring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore

After completing this module, you will be able to:

  • Explain the restore process.

  • Restore databases.

  • Perform advanced restore operations.

  • Perform a point-in-time recovery.

Module 8: Automating SQL Server ManagementThe tools provided by Microsoft SQL Server make administration easy when compared to some other database engines. However, even when tasks are easy to perform, it is common to have to repeat a task many times. Efficient database administrators learn to automate repetitive tasks. This can help to avoid situations where an administrator forgets to execute a task at the required time. Perhaps more importantly, the automation of tasks helps to ensure that they are performed consistently, each time they are executed. This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to implement multiserver jobs. Lessons
  • Automating SQL Server management
  • Working with SQL Server Agent
  • Managing SQL Server Agent Jobs
  • Multi-server Management
Lab : Automating SQL Server Management
  • Create a SQL Server Agent Job
  • Test a Job
  • Schedule a Job
  • Configure Master and Target Servers

After completing this module, you will be able to:

  • Describe methods for automating SQL Server Management.

  • Configure jobs, job step types, and schedules.

  • Manage SQL Server Agent jobs.

  • Configure master and target servers.

Module 9: Configuring Security for SQL Server AgentOther modules in this course have demonstrated the need to minimize the permissions that are granted to users, following the principle of “least privilege.” This means that users have only the permissions that they need to perform their tasks. The same logic applies to the granting of permissions to SQL Server Agent. Although it is easy to execute all jobs in the context of the SQL Server Agent service account, and to configure that account as an administrative account, a poor security environment would result from doing this. It is important to understand how to create a minimal privilege security environment for jobs that run in SQL Server Agent.Lessons
  • Understanding SQL Server Agent Security
  • Configuring Credentials
  • Configuring Proxy Accounts
Lab : Configuring Security for SQL Server Agent
  • Analyzing Problems in SQL Server Agent
  • Configuring a Credential
  • Configuring a Proxy Account
  • Configuring and testing the Security Context of a Job

After completing this module, you will be able to:

  • Explain SQL Server Agent security.

  • Configure credentials.

  • Configure proxy accounts.

Module 10: Monitoring SQL Server with Alerts and NotificationsOne key aspect of managing Microsoft SQL Server in a proactive manner is to make sure you are aware of problems and events that occur in the server, as they happen. SQL Server logs a wealth of information about issues. You can configure it to advise you automatically when these issues occur, by using alerts and notifications. The most common way that SQL Server database administrators receive details of events of interest is by email message. This module covers the configuration of Database Mail, alerts, and notifications for a SQL Server instance, and the configuration of alerts for Microsoft Azure SQL Database. Lessons
  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Operators, Alerts, and Notifications
  • Alerts in Azure SQL Database
Lab : Monitoring SQL Server with Alerts and Notifications
  • Configuring Database Mail
  • Configuring Operators
  • Configuring Alerts and Notifications
  • Testing Alerts and Notifications

After completing this module, you will be able to:

  • Monitor SQL Server errors.

  • Configure database mail.

  • Configure operators, alerts, and notifications.

  • Work with alerts in Azure SQL Database.

Module 11: Introduction to Managing SQL Server by using PowerShellThis module looks at how to use Windows PowerShell with Microsoft SQL Server. Businesses are constantly having to increase the efficiency and reliability of maintaining their IT infrastructure; with PowerShell, you can improve this efficiency and reliability by creating scripts to carry out tasks. PowerShell scripts can be tested and applied multiple times to multiple servers, saving your organization both time and money.Lessons
  • Getting Started with Windows PowerShell
  • Configure SQL Server using PowerShell
  • Administer and Maintain SQL Server with PowerShell
  • Managing Azure SQL Databases using PowerShell
Lab : Using PowerShell to Manage SQL Server
  • Getting Started with PowerShell
  • Using PowerShell to Change SQL Server settings

After completing this module, you will be able to:

  • Describe the benefits of PowerShell and its fundamental concepts.

  • Configure SQL Server by using PowerShell.

  • Administer and maintain SQL Server by using PowerShell.

  • Manage an Azure SQL Database by using PowerShell.

Module 12: Tracing Access to SQL Server with Extended eventsMonitoring performance metrics provides a great way to assess the overall performance of a database solution. However, there are occasions when you need to perform more detailed analysis of the activity occurring within a Microsoft SQL Server instance—to troubleshoot problems and identify ways to optimize workload performance. SQL Server Extended Events is a flexible, lightweight event-handling system built into the Microsoft SQL Server Database Engine. This module focuses on the architectural concepts, troubleshooting strategies and usage scenarios of Extended Events. Lessons
  • Extended Events Core Concepts
  • Working with Extended Events
Lab : Extended Events
  • Using the System_Health Extended Events Session
  • Tracking Page Splits Using Extended Events

After completing this module, you will be able to:

  • Describe Extended Events core concepts.

  • Create and query Extended Events sessions.

Module 13: Monitoring SQL Server The Microsoft SQL Server Database Engine can run for long periods without the need for administrative attention. However, if you regularly monitor the activity that occurs on the database server, you can deal with potential issues before they arise. SQL Server provides a number of tools that you can use to monitor current activity and record details of previous activity. You need to become familiar with what each of the tools does and how to use them. It is easy to become overwhelmed by the volume of output that monitoring tools can provide, so you also need to learn techniques for analyzing their output.Lessons
  • Monitoring activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data
  • SQL Server Utility
Lab : Monitoring SQL Server

After completing this module, you will be able to:

  • Monitor current activity.

  • Capture and manage performance data.

  • Analyze collected performance data.

  • Configure SQL Server Utility.

Module 14: Troubleshooting SQL ServerDatabase administrators working with Microsoft SQL Server need to adopt the important role of troubleshooter when issues arise—particularly if users of business-critical applications that rely on SQL Server databases are being prevented from working. It is important to have a solid methodology for resolving issues in general, and to be familiar with the most common issues that can arise when working with SQL Server systems. Lessons
  • A Trouble Shooting Methodology for SQL Server
  • Resolving Service Related Issues
  • Resolving Connectivity and Log-in issues
Lab : Troubleshooting Common Issues
  • Troubleshoot and Resolve a SQL Login Issue
  • Troubleshoot and Resolve a Service Issue
  • Troubleshoot and Resolve a Windows Login Issue
  • Troubleshoot and Resolve a Job Execution Issue
  • Troubleshoot and Resolve a Performance Issue

After completing this module, you will be able to:

  • Describe a troubleshooting methodology for SQL Server.

  • Resolve service-related issues.

  • Resolve login and connectivity issues.

Module 15: Importing and Exporting DataWhile a great deal of data residing in a Microsoft SQL Server system is entered directly by users who are running application programs, there is often a need to move data in other locations, to and from SQL Server. SQL Server provides a set of tools you can use to transfer data in and out. Some of these tools, such as the bcp (Bulk Copy Program) utility and SQL Server Integration Services, are external to the database engine. Other tools, such as the BULK INSERT statement and the OPENROWSET function, are implemented in the database engine. With SQL Server, you can also create data-tier applications that package all the tables, views, and instance objects associated with a user database into a single unit of deployment. In this module, you will explore these tools and techniques so that you can import and export data to and from SQL Server. Lessons
  • Transferring Data to and from SQL Server
  • Importing and Exporting Table Data
  • Using bcp and BULK INSERT to Import Data
  • Deploying and Upgrading Data-Tier Application
Lab : Importing and Exporting Data
  • Import and Excel Data Using the Import Wizard
  • Import a Delimited Text File Using bcp
  • Import a Delimited Text File using BULK INSERT
  • Create and Test an SSIS Package to Extract Data
  • Deploy a Data-Tier Application

After completing this module, you will be able to:

  • Describe tools and techniques for transferring data.

  • Import and export table data.

  • Use bcp and BULK INSERT to import data.

  • Use data-tier applications to import and export database applications.

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

·         Basic knowledge of the Microsoft Windows operating system and its core functionality.

·         Working knowledge of Transact-SQL.

·         Working knowledge of relational databases.

·         Some experience with database design.

 
×

20765 Provisioning SQL Databases

Course Duration: 5 Days

SATV: Yes

About This Course

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

Audience Profile

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

At Course Completion

After completing this course, students will be able to:

  • Provision a Database Server

  • Upgrade SQL Server

  • Configure SQL Server

  • Manage Databases and Files (shared)

  • Provision, migrate and manage databases in the cloud

Course OutlineModule 1: SQL Server ComponentsThis module describes the various SQL Server components and versions.Lessons
  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture
  • SQL Server Services and Configuration Options

After completing this module, you will be able to:

  • Describe SQL Server components and versions.

  • Describe SQL Server architecture and resource usage.

  • Describe SQL Server services and how you manage the configuration of those services.

Module 2: Installing SQL Server This modules describes the process to install SQL Server 2016.Lessons
  • Considerations for SQL Installing Server
  • TempDB Files
  • Installing SQL Server
  • Automating Installation
Lab : Installing SQL Server
  • Preparing to install SQL Server
  • Install an instance of SQL Server
  • Perform post installation checks
  • Automating Installation

After completing this module, you will be able to:

  • Describe the considerations when installing SQL Server.

  • Describe TempDB files.

  • Install SQL Server.

  • Automate a SQL Server installation.

Module 3: Upgrading SQL Server to SQL Server 2017This module describes the process for upgrading to SQL Server 2017. Lessons
  • Upgrade Requirements
  • Upgrade SQL Server Services
  • Side by Side Upgrade: Migrating SQL Server Data and Applications
Lab : Upgrading SQL Server
  • Create the Application Logins
  • Restore the backups of the TSQL Database
  • Orphaned Users and Database Compatibility Level

After completing this module, you will be able to:

  • Describe the upgrade requirements for SQL Server.

  • Upgrade SQL Server.

  • Migrate SQL Server data and applications.

Module 4: Working with DatabasesThis module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.Lessons
  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving and Copying Database Files
  • Buffer Pool Extension
Lab : Managing Database Storage
  • Configuring tempdb Storage
  • Creating Databases
  • Attaching a Database
  • Enable Buffer Pool Extension

After completing this module, you will be able to:

  • Describe Data Storage with SQL Server.

  • Manage Storage for System Databases.

  • Manage Storage for User Databases.

  • Move and Copy Database Files.

  • Describe and use Buffer Pool Extensions.

Module 5: Performing Database MaintenanceThis module covers database maintenance plans.Lessons
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
Lab : Performing Database Maintenance
  • Use DBCC CHECKDB to Verify Database Integrity
  • Rebuild Indexes
  • Create a Database Maintenance Plan

After completing this module, you will be able to:

  • Ensure Database Integrity.

  • Maintain Indexes.

  • Automate Routine Database Maintenance.

Module 6: Database Storage OptionsDescribe SQL Server storage options.Lessons
  • SQL Server storage Performance
  • SMB Fileshare
  • SQL Server Storage in Microsoft Azure
  • Stretch Databases
Lab : Implementing Stretch Database
  • Run Stretch Database Advisor
  • Implement Stretch Database

After completing this module, you will be able to:

  • Describe SQL Server Storage Performance.

  • Describe SMB Fileshare.

  • Explain SQL Server Storage in Microsoft Azure.

  • Describe Stretch Database.

Module 7: Planning to Deploy SQL Server on Microsoft AzureThis module describes how to plan to deploy SQL Server on Azure.Lessons
  • SQL Server Virtual Machines in Azure
  • Azure Storage
  • Azure SQL Authentication
  • Deploying an Azure SQL Database
Lab : Plan and Deploy an Azure SQL Database
  • Plan an Azure SQL Database, Networking, performance tiers, security
  • Provision an Azure SQL Database
  • Connect to an Azure SQL Database

After completing this module, you will be able to:

  • Describe SQL Server Virtual Machines in Azure.

  • Describe Azure Storage.

  • Explain Azure SQL Authentication, auditing and compliance.

  • Deploy an Azure SQL Database.

Module 8: Migrating Databases to Azure SQL DatabaseThis module describes how to migrate databases to Azure SQL Database.Lessons
  • Database Migration Testing Tools
  • Database Migration Compatibility Issues
  • Migrating a SQL Server Database to Azure SQL Database
Lab : Migrating SQL Server Databases to Azure
  • Perform Migration Testing
  • Migrate a SQL Server Database to Azure SQL Database
  • Test a Migrated Database

After completing this module, students will be able to:

  • Describe various database migration testing tools.
  • Explain database migration compatibility issues.
  • Migrate a SQL Server database to Azure SQL database.


Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine This module describes how to deploy SQL Server on Microsoft Azure VMs.Lessons
  • Deploying SQL Server on an Azure VM
  • The Deploy Database to a Microsoft Azure VM Wizard
Lab : Deploying SQL Server on an Azure Virtual Machine
  • Provision an Azure VM
  • Use the Deploy Database to Azure VM Wizard

After completing this module, students will be able to:

  • Deploy SQL Server on an Azure VM.
  • Use The Deploy Database to a Microsoft Azure VM Wizard.
  • Configure SQL Server Connections
Module 10: Managing databases in the CloudThis module describes how to manage SQL Server on Azure.Lessons
  • Managing Azure SQL Database Security
  • Configure Azure storage
  • Azure Automation
Lab : Managing Databases in the Cloud
  • Add data masking
  • Use Azure automation to stop Virtual Machines

After completing this module, students will be able to:

  • Manage Azure SQL Database Security.
  • Configure Azure storage.
  • Implement Azure Automation.
Additional Reading


This course requires that you meet the following prerequisites:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

  • Working knowledge of Transact-SQL.

  • Working knowledge of relational databases.

  • Some experience with database design

 
Description: .
Prerequisites:

Course: Microsoft OneDrive Basic Fundamentals

Hours: 3

Prerequisites: N/A

Description:

This course teaches participants how to use the Office 365 cloud storage service, OneDrive. This cloud service woks like a traditional hard drive. During the course, participants will learn how how to use both the OneDrive Desktop App and the OneDrive Web App. Finally, participants will learn how to store, upload, and download files, and use Office Web App for business accounts in a collaborative environment.


Objectives:

At the end of the course OneDrive Basics Fundamentals, participants will be able to:

  • Manage files in the cloud storage service OneDrive.

  • Upload and download files.

  • Set-up folder to sync to OneDrive.

  • Understand the status of OneDrive files.

  • Use OneDrive Files On-Demand.


Framework Topics

  1. What is OneDrive for Business?

  2. OneDrive Basics Fundamentals

    1. Introduction to Microsoft OneDrive

      1. Set up a OneDrive Account

      2. Get started with OneDrive at work

      3. OneDrive basics for work

    2. Manage your files

      1. How to upload files and folders to OneDrive

      2. Create files and folders

      3. Delete files and folders

      4. Restore deleted files on OneDrive

    3. Share and sync files

      1. Sync folder in OneDrive

      2. Understanding the sync status

      3. Sync OneDrive files

      4. Share files using OneDrive

    4. OneDrive files On-Demand

      1. Manage OneDrive files On-Demand


Reference

Microsoft. (2019, July 01). Office 365 Training Center. Retrieved from https://support.office.com/en-us/office-training-center





 

Microsoft Teams Basics Fundamentals

Hours: 4


Prerequisites: N/A

Description:

In this course, participants will learn how to use the Microsoft Teams collaboration app in a business environment. Participants will understand how to manage a team through the Microsoft Teams app, helping them to stay organized, have conversations in one place, chat, and create channels by projects, topics and/or team groups. Finally, participants will learn how to manage online meetings with the goal of improving both the communications and collaborative work environment of a business.


Objectives

At the end of the course, the participant will be able to:

  • Set up and customize Teams.

  • Collaborate in teams and channels

  • Work with post and messages.

  • Upload and find files.

  • Start chats and calls.

  • Manage meetings, set up live event and record meetings.

Framework Topics

  1. Introduction to Microsoft Teams

    1. What is Microsoft Teams?

  2. Set up and customize your team

    1. Get your team up and running

    2. Create your team

    3. Create a team from an existing group

    4. Manage team settings and permission

    5. Organize your teams

  3. Collaborate in team and channels

    1. Collaborate in teams

      1. Overview of teams and channels

      2. Collaborate in teams

    2. Manage channels

      1. Create a channel

      2. Team owner, manage channels and add or remove members

      3. Show and hide channels

      4. Works in channels

      5. Work in file together

      6. Send email to a channel

    3. Manage chats and calls

      1. Start a chat in Teams

      2. Make calls

      3. Hide chats, delete messages

      4. Set up a delegate to take your calls

  4. Meeting in Teams

    1. Manage meetings

      1. Meetings in Microsoft Teams

      2. Join a meeting in Teams

      3. Manage the meeting

      4. Manage calendar meeting view

    2. Share content in meeting

      1. Show your screen during a meeting

      2. Show PowerPoint slides in meeting

      3. Share your screen in a meeting

      4. Give and take control of shared content

      5. Switch between people and content

    3. Recording meeting or live events

      1. Play and share a meeting recording

      2. Record a meeting in Teams

      3. Plan and schedule a live event

      4. Produce a live event

      5. Attend to live event

  5. Take meeting notes in Microsoft Teams

      1. Prepare collaborative notes before, during and after the meeting

References

Microsoft. (2019, July 01). Office 365 Training Center. Retrieved from https://support.office.com/en-us/office-training-center










 

Microsoft Planner Basics Fundamentals

Hours: 2.0

Prerequisites: N/A

Description:

In this course, participants will learn the advantages of using Microsoft Planner and Microsoft Teams together. The course will help participants understand new ways of making plans using Microsoft Planner, as well as create and organize plans, assign tasks, share files, and chat about the status and get progress updates of tasks or projects. This course helps and organization’s staff and leaders in the management of operations using the Planner app, with the goal of obtaining a big picture of productivity in relation to a project, all in one place.


Objectives

At the end of the course, the participant will be able to:

  • Create new plans, assign tasks, and share files with others.

  • Organize teamwork and collaborate on projects in a simple, visual way.

  • Chat with others to make sure you're on the same page.

  • Keep track of your team's progress and stay on top of your work—from anywhere, on any device.

  • Work with Microsoft Teams and Microsoft Planner together.


Framework Topics


  1. Introduction to Microsoft Planner

    1. What is Microsoft Planner?

    2. Set up and configure Microsoft Planner account


  1. Create new plan and tasks

    1. New plan, new group

      1. Build your plan

      2. Add a plan to an existing group

      3. Create a plan in the same group

      4. Add tasks to a plan

      5. Manage your tasks

      6. Add people to your plan

      7. See planner tasks in Microsoft To-Do


  1. More ways to get organized with Microsoft Planner

    1. Get organize with Microsoft Planner

      1. Create buckets to sort your tasks

      2. Set and update task progress

      3. Track progress

      4. Add task start and due dates

      5. See your planner schedule in Outlook Calendar

      6. Comments on tasks in Microsoft Planner

      7. Use schedule view in Microsoft Planner

      8. Plan an event in Planner


  1. Attach files, photos or links

    1. Attach files, photos or links

    2. Publish content

    3. Support customers in Microsoft Planner


  1. Use Planner in Microsoft Teams

    1. Create a plan with Planner in Teams

    2. Use Planner in Microsoft Teams

    3. Organize your teams in Planner

    4. Plan actions in Teams versus Planner for web

    5. Open your teams-created in Planner or Teams


References

Microsoft. (2019, July 01). Office 365 Training Center. Retrieved from https://support.office.com/en-us/office-training-center