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

DevOps Implementation Boot Camp

For decades there have been big disconnects between the different roles of the IT shop. We struggle with inherent barriers between development projects and the stable infrastructure needed to deploy and run products. Applications get completed and tested in insulated internal environments without adequate collaboration between production IT staff and infrastructure administrators. Unforeseen challenges plague the production environment, wreaking havoc with deadlines, deliverables, and ultimately the business mission. Security is often a wet blanket at best, and an afterthought at worst. In the meantime, huge backlogs of work and technical debt pile up, chronically eroding the efficiency and agility of the business’ IT capability.

This three-day DevOps Implementation training class is loaded with practical real-world tools and techniques. From the nation’s largest Agile development trainers comes a comprehensive program to get you started on the road to DevOps success. You will leave this course fully literate in the whole array of available DevOps tools and lessons, ready to select what’s right for you and chart a path to holistic long-term IT success in your own organization.

Attendees who successfully complete this course receive the ICP designation after course completion. The ICP-FDO is one of two Continuous Learning Certifications (CLCs) on the DevOps Track. This certification provides an overview of core concepts for DevOps and is geared towards a broad audience of professionals, technical and non-technical. The learning objectives cover areas such as the business case for DevOps, Continuous Integration, Continuous Delivery, accompanying cultural changes, operational considerations, configuration management, etc. Participants who complete this certification will gain an excellent foundation in DevOps concepts and ingredients for a successful transition.

Uncategorized

Monitoring and Operating a Private Cloud (M20246)

In this course, you will receive an overview of a private cloud infrastructure, the business and technical drivers behind the implementation, and how System Center 2012 can be used to monitor and operate the private cloud infrastructure. Through hands-on exercises you will gain the skills to configure and optimize a new business unit cloud, deploy pre-packaged applications, and create a new service template to deploy a service into the cloud. You will also learn how System Center Operations Manager is used to monitor the various services that underpin the private cloud. You will learn the core functionality of Service Manager and achieve the skills to create and manage change requests, incidents, and release records as well as the security model behind Service Manager.

Uncategorized

Communicating for Clarity

Communication is one of the most important factors influencing the success of organizations and individuals. Communication errors and misunderstandings can result in lost opportunities, lost productivity and worst of all, lost customers. This one-day course combines concepts developed through research with a prime model and key tools that give you the skills you need to communicate more clearly. The solution is not more communication, but clearer communication.

Communicating for Clarity focuses on the following competencies:

Creating a clear and engaging message
Encouraging clear communication from others

Uncategorized

Developing SQL Databases (M20762)

In this course, you will learn the major tools of the SQL Server 2016 platform, logical table design, indexing, query plans, and data and domain integrity. You will focus on creating database objects, including views, stored procedures, parameters and functions. You will also learn procedure coding, such as indexes, triggers, SQL Common Language Runtime (CLR), SQL Server spatial data, and considerations for binary large object (BLOB) data.

This course uses Microsoft SQL Server 2016 and incorporates material from the Official Microsoft Learning Product 20762: Developing SQL Databases.

GK Digital Learning is also available with digital Microsoft Official Courseware (dMOC). Click here to purchase.