Designing and Implementing Cloud Data Platform Solutions (M55247)

COURSE OUTLINE:

Description

This course is intended for data professionals who want to design and implement database solutions in SQL Server and on Microsoft Azure. Security, Availability, Disaster Recovery, Scalability, Monitoring and Troubleshooting options will also be demonstrated.

Audience

This course is intended for experienced data professionals who design and implement on-premises and Microsoft Azure data solutions.

Prerequisites

Experience working with databases
Experience using SQLï¿½

Learning Objectives

Create SQL Server and Microsoft Azure data solutions
Create Security solutions for on-premises and cloud databases
Configure High-Availability, Disaster Recovery and Scalability options for databases
Monitor, Manage and Automate database solutions

Module 1: Designing and Implementing Database Solutions for SQL Server and Microsoft Azure

Design and Implement Hybrid SQL Server solutions
Design and Implement Azure SQL Database solutions
Design and Implement MySQL and PostgreSQL database solutions in Azure
Review

Module 2: Manage, Design and Implement Database Security

Design and Implement SQL Server database security
Design and Implement Azure SQL Database security
Review

Module 3: Design for High-Availability, Disaster Recovery and Scalability

Design and Implement High-Availability Solutions
Design and Implement Disaster Recovery Solutions
Design and Implement Scalability Solutions
Review

Module 4: Monitor and Troubleshoot Database Implementations in Azure

Monitor and Troubleshoot SQL Server VMs on Azure
Monitor and Troubleshoot Azure SQL Databases
Review

RELATED COURSES

Uncategorized

ENC9K-Implementing Cisco Catalyst 9000 Switches

This course includes Cisco Training Exclusives

EXCLUSIVE TO GLOBAL KNOWLEDGE – Accelerate your Cisco learning experience with complimentary access to the IT Skills Video On-Demand Library, Introduction to Cybersecurity digital learning course, course recordings, IT Resource Library, and digital courseware.

Learn more

This hands-on course covers many features of the Cisco IOS XE platform and describes how to manage devices from a single dashboard, the Cisco DNA Center. You will learn how to use the Cisco Catalyst 9000 family of switches to enable Software Defined Access (SD-Access) and provide end-to-end security and automation with centralized management using DNA Center.

Uncategorized

Azure Infrastructure and Deployment Track (AZ-100)

This course teaches IT Professionals:

Manage their Azure subscriptions, including access, policies, and compliance, as well as how to track and estimate service usage and related costs.
How cloud resources are managed in Azure through user and group ents
Learn how to grant appropriate access to Azure AD users, groups, and services through Role-based access control (RBAC).
Discover the core monitoring tools and capabilities provided by Azure, including Azure Alerts and Activity Log.
Introduced to Log Analytics as a broad data analytics solution and use this service to query and analyze operational data.
Learn about the Azure Resource Manager deployment model, and how to work with resources, resource groups and ARM templates.
implement Azure storage solutions for a variety of scenarios.
Learn about the different storage accounts and services as well as basic data replication concepts and available replication schemes. Students are also introduced to Storage Explorer as a convenient way to work with Azure storage data.
Learn the types of storage and how to work with managed and custom disks.
Azure blob storage is how Azure stores unstructured data in the cloud, and students learn how to work with blobs and blob containers.
Learn how to use Azure Files to work with file shares that are accessed via the Server Message Block (SMB) protocol.
In addition to blob storage, the course covers Table and Queue storage as storage options for structured data.
Learn how to secure and manage storage using Shared Access Signatures (SAS) and Azure Backup, using Recovery Services Vault. Next, students learn how to use Azure File Sync to centralize an organizationï¿½s file Shares in Azure Files. Content Delivery Network (CDN) is used to store cached content on a distributed network of servers that are close to end users. Students learn how to optimize content delivery with Azure CDN, as well as how to transfer large amounts of data using the Azure Import/Export service.
Learn how to monitor Azure storage by configuring metrics and alerts and using the Activity Log. Students learn how to analyze usage trends, trace requests, and diagnose issues with a storage account.
How to create and manage virtual machines as part of an Infrastructure as a Service (IaaS) computing infrastructure.
Learn how to assess their on-premises environment for virtual machine readiness in preparation for moving resources to the cloud, including sizing, pricing, and design considerations.
Learn how to create and deploy virtual machines in Azure, using the Azure portal, PowerShell, and ARM templates. The course includes instruction on deploying custom images and Linux virtual machines.
Learn how to configure the networking and storage components of virtual machines.
Deploying highly available virtual machines is critical in the light of planned and unplanned events, and students learn how to use availability sets to ensure that virtual machine resources are available during downtime.
Learn how to use extensions and Desired State Configuration (DSC) for post deployment automation and configuration tasks.
Learn how to perform virtual machine backups, and to use Azureï¿½s monitoring capabilities to collect, view, and analyze virtual machine diagnostic and log data.
Configure and manage Azure virtual networks (VNets).
The benefits of moving an infrastructure to the cloud, removing the need to maintain expensive datacenters are an appealing proposition for many small and medium-sized companies. Regardless, once resources are moved to Azure, they require the same networking functionality as an on-premises deployment, and this course deals with the basic network configuration tasks.
The basis of IP addressing, with specific emphasis on how public and private IP addressing works in the cloud.
Learn how to configure network routing and how to implement Azure DNS.
Securing the network infrastructure is of key importance and students learn how to use Network Security Groups (NSGs) to limit network traffic to resources in a virtual network, by creating security rules that allow or deny inbound or outbound traffic.
Learn how to use NSG logging to diagnose and troubleshoot network connectivity problems.
Different connectivity scenarios for Azure virtual networks and students learn how to connect virtual networks with VNet-to-VNet VPN gateways and virtual network peering.
Use Azure Active Directory (AD) to provide employees and customers with a multi-tenant cloud-based directory and identity management system.
Learn the differences between Azure AD and Active Directory Domain Services (AD DS), as well the differences in functionality offered by the different editions of Azure AD.
Learn how to configure self-service password reset, or to use the option of password writeback to reset user passwords regardless of their location. Students are then introduced to Azure AD Identity Protection and learn how they can use it to protect their organizations from compromised accounts, identity attacks, and configuration issues.
Learn how to integrate Azure AD with the many Software as a Service (SaaS) applications that are used, in order to secure user access to those applications.
Concepts of Azure domains and tenants, and users and groups are explained and students learn how to work with the various Azure AD objects. Students are introduced to Azure role-based access control to be able to provide a more granular access based on the principle of least privilege. An administrator, or user, can do exactly the task they need to accomplish; no more, no less.
Learn how to work with Azure joined devices and Hybrid AD joined devices, enabling their users to be productive wherever and whenever ï¿½ but ensuring that corporate assets are protected and that devices meet security and compliance standards.
Learn how to use Azure AD Connect to integrate their on-premises directories with Azure AD, providing a common identity for their users of Office 365, Azure, and SaaS applications integrated with Azure AD.
Learn how to use Azure AD Application Proxy to be able to provide their users with remote access to web application that are published on-premises, such as SharePoint sites, Outlook Web Access, or any other line of business (LOB) applications the organization has.

Uncategorized

Azure Solution Architect Bootcamp (AZ-300 and AZ-301)

In an intensive and immersive hands-on learning environment, you will build the skills needed for Azure Architect-Technologies contains courseware that helps prepare students for Exams AZ-300 and AZ-301. Passing this exam is required to earn the Azure Architect-Technologies certification.

This boot camp includes all the exam vouchers required for certification.ï¿½ It also includes access to our Microsoft Boot Camp Exclusives, providing indispensable certification exam prep.

You will prepare for these exams:

Exam AZ-300: Microsoft Azure Architect Technologies
Exam AZ-301: Microsoft Azure Architect Design

This course covers:

Course AZ-300T01: Deploying and Configuring Infrastructure.
Course AZ-300T02: Implementing Workloads and Security.
Course AZ-300T03: Understanding Cloud Architect Technology Solutions.
Course AZ-300T04: Creating and Deploying Apps.
Course AZ-300T05: Implementing Authentication and Secure Data.
Course AZ-300T06: Developing for the Cloud.

Uncategorized

Azure Integration and Security Track (AZ-101)

This course teaches IT professionals:

How to discover, assess, plan and implement a migration of on-premises resources and infrastructure to Azure. Students will learn how to use Azure Migrate to perform the discovery and assessment phase that is critical to a successful migration. Students will also learn how to use Azure Site Recovery for performing the actual migration of workloads to Azure. The course focuses primarily on using ASR on a Hyper-V infrastructure to prepare and complete the migration process. In addition, students learn about other scenarios, such as migration of VMware vSphere Hypervisor virtual machines and System Center VMM Hyper-V machines.
How to manage and maintain the infrastructure for the core web apps and services that developers build and deploy. Students will learn how Azure App Service is used as a Platform as a Service (PaaS) offering for deploying cloud apps for web and mobile environments. Students will learn how to use App Service Environments (ASE) to host a dedicated environment for securing and running App Service apps at scale. Students will also learn how to use deployment slots as staging environments for web apps, that can then be swapped into production when needed. This course also teaches students how to scale up and scale out to meet and adjust for demand, and how bandwidth for web traffic can be optimized using Application Gateways and Content Delivery Networks (CDN). Lastly, the course provides students with an overview of serverless computing solutions, including Azure Functions, Event Grid, Service Bus, and Logic Apps.
How to implement and configure different Azure networking traffic distribution mechanisms, including Azure Load Balancer, Azure Traffic Manager, and Azure Application Gateway. Students will also learn how to implement site connectivity for multiple scenarios including cross-premises and hybrid configurations, as well as extending on-premises networks into the Microsoft cloud over a dedicated private connection, using Azure ExpressRoute. Lastly, students will learn how to use Network Watcher to monitor and troubleshoot Azure virtual networks. They will also learn how to troubleshoot and remediate common errors in Azure Application Gateway and Azure Load Balancer.
To understand the challenges that organizations face in keeping modern IT environments secure, as the more distributed environments that are part of a cloud-first or hybrid world have rapidly created new security challenges for IT. The course focuses on three key areas in the defense against attackers who target security vulnerabilities, resulting particularly from credential theft and compromised identities: Role-Based Access Control (RBAC), Multi-Factor Authentication (MFA), and Azure Active Directory Privileged Identity Management (PIM). Students learn to implement two-step verification to secure the sign-in process, as well has how to use advanced features like trusted IPs and Fraud Alerts with MFA to customize their identity access strategy. Using Privileged Identity Management, students learn how to apply just the right amount of access rights for just the right amount of time to the various administrative roles as well as to resources.