Abstract:

This workshop is a chance for developers and IT Pros to come together and learn the architecture skills necessary to design solutions for Microsoft Azure.

The classroom experience for this workshop is high-level review of the pre-requisite materials students are expected to have completed in advance.

Then, students will assemble into groups to work on several real-world design case studies to design solutions for the Microsoft Azure platform.

 

 

 

 

Table of Contents:

 

• Design Principles for Cloud Infrastructure and Development

o Common patterns for cloud applications
o Design techniques for performance, resiliency and scalability

• Design App Service Web Apps

o Features and capabilities of Azure Web Apps, Azure SQL Database, ARM.
o Design techniques for business continuity.

• Designing Application Storage & Data Access

o Features and capabilities of Azure Storage, Mobile Services, other Azure storage options.
o Design techniques.

• Securing Resources

o Techniques for designing secure solutions.

• Design Microsoft Azure Infrastructure & Networking

o Azure networking and infrastructure features and capabilities
o Design techniques for distributed applications.

• Designing an Advanced Application

o Advanced Azure platform capabilities:

 Running compute-intensive applications
 Long-running jobs,
 Other advanced features.

• Designing a Management and Monitoring Strategy

o Techniques for configuring, monitoring, and continuous updating of Azure applications.

• Designing a Business Continuity Strategy

oTechniques for designing backup and recovery solutions.

Abstract:

Microsoft Azure is a collection of services that enables individuals and organizations to create, deploy, and operate cloud-based applications and infrastructure services. In this course, we’ll give a brief overview of the various services on Azure, including compute, networking, storage, data and analytics services, explaining who they are and how they work together on Azure.

This workshop is a chance for developers to have an introduction to the services available in Microsoft Azure.

.

Table of principal contents:

• Cloud Overview
• Microsoft Azure
• Virtual Machines, Networking and Authentication
• Azure Storage
• Data & Analytics
• Web
• AI & Cognitive Services
• Internet of Things
• Media Services

Azure Time Series Insights is a fully managed analytics, storage, and visualization service that makes it simple to explore and analyze billions of IoT events simultaneously.
It gives you a global view of your data, letting you quickly validate your IoT solution and avoid costly downtime to mission-critical devices by helping you discover hidden trends, spot anomalies, and conduct root-cause analyses in near real-time.

Time Series Insights ingests time-series data from event-brokers (e.g. IoT Hubs or Event Hubs), indexes the data, and retires data based on a configurable retention policy. Users consume the data for their business scenario either through an intuitive UX or REST Query APIs.

This course will give you an insight into Time Series Insights and help you to write, deploy, control and monitor your Azure functions.

Table of Contents:

• Introducing Time Series

o What is Time Series Insights?

• Get Started

o Create an environment
o Grant data access
o Create an event source
o Send events

• How to

o Create an Event Hub event source
o Create an IoT Hub event source
o Scale your environment
o Diagnose and solve problems
o Query data using C#

• Reference

o Query API
o Query syntax

Microsoft Flow allows you to create automatic processes, called flows, that react to an event in one app or application (like SharePoint, Twitter, ...), do something with the event data, and then use this data in another service (like SharePoint, Salesforce, Twitter, ...). All this can be done without having to write a single line of code.

With Flow, also available for mobile devices, you can manage your flows from your mobile. It also allows you to trigger flows on the click of a button. In this module, participants will explore the capabilities of the mobile Flow app.

In this course, participants will get familiar with the concepts of Microsoft Flow. They will learn how to use these services to create flows without needing any development skills.

 

Table of Contents:

• Introduction to Flow

o What is Flow?
o Flow building blocks
o Flow connections
o Licensing and pricing conditions
o Flow templates

• Building Flows

o Building flows from templates
o Building flows from scratch
o Working with services, triggers, actions, conditions and loops
o Run a flow on a schedule
o Calling custom business services
o Using approval options
o Observing flows

• Using Flows for on premises data

o What are gateways?
o Set up a gateway for on premises connections

• Flow Admin Center

o Managing environments
o Data Loss Prevention policies

• Flow for mobile

Abstract:

Microsoft Azure is the public offering of Microsoft for Cloud Computing. Cloud computing is becoming massively adopted across the world. This is not just by chance, this is the next (or should I say current) great technology.

This workshop is a chance for developers to have the skills necessary to develop solutions for Microsoft Azure.

 

 

Table of Contents:

• Introduction to Cloud Computing.
• Introduction to ARM deployment and Resource Groups.
• Introduction to Visual Studio Team Services.
• Introduction to Azure Virtual Machines and Azure Virtual Networks.
• Azure App Service.
• Azure Storage.
• Azure SQL Databases.
• Azure Active Directory.
• Azure Service Bus
• Create High-Available and Performance Web Applications on Azure
• Introduction to Azure Search

In the world of the information worker you will handle information that is probably stored across different software suites, like SharePoint, Salesforce, Excel file, Access database, ... Typically, you would like your end-users to be able to browse and/or modify this data in a general user-friendly, and preferably mobile, way.

Microsoft PowerApps allows people, without any development skills, to build applications that are mobile friendly on top of their data. Allowing other people to use the built application to browse the data and maybe even modify it.

In this course, participants will get familiar with the concepts of Microsoft PowerApps. They will learn how to use these services to create custom applications without needing any development skills.

No prior knowledge to PowerApps is required.

 

Table of Contents:

• Introduction to Power Apps

o What is PowerApps?
o PowerApps components
o Related technologies
o Licensing and pricing conditions
o PowerApp connections
o App samples and templates

• Building PowerApps apps

o Introduction to PowerApps Studio
o Creating apps from templates
o Creating apps from scratch
o Screens and Pages
o Screen components: Forms, DataCards, Controls, …
o Handling bindings
o Publishing and sharing apps

• PowerApps advanced features

o Using functions, signals, enumerations and named operators
o Understanding and applying data source delegation

• The Microsoft Common Data Model

o What is the Microsoft Common Data Model (CDM)
o Managing entities
o Working with structured metadata
o Importing and exporting data
o Excel integration for CDM
o Managing security
o Building Apps with CDM

• Using PowerApps for on premises data

o What are gateways?
o Set up a gateway for on premises connections

• PowerApps Admin Center

o Managing connections
o Managing environments and security
o Managing data policies

• PowerApps for mobile

o Capabilities of PowerApps App for IOS, Android and Windows 10 mobile

Abstract:

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.

Functions can make development even more productive, and you can use your development language of choice, such as C#, F#, Node.js, Python or PHP. Pay only for the time your code runs and trust Azure to scale as needed.

Azure Functions lets you develop server less applications on Microsoft Azure.

 

 

 

 

 

Table of Contents:

• Introducing Azure Functions

o Introducing Azure Functions
o Azure VMs, Cloud Services, and Web Apps
o What's Different About Azure Functions?
o App Service and Functions Pricing
o Benefits of Azure Functions
o Introducing Serverless Architecture
o Serverless - A Real-world Example

• What Are Azure Functions Good For?

o Creating Your First Azure Function
o Creating Our First Function
o Creating Functions from Templates
o Creating a Function App
o Exploring the Function App
o Exploring the Storage Account

• Understanding Triggers and Bindings

o Introducing Triggers and Bindings
o Demo: Webhook Trigger
o Demo: Queue Output

• Building a Function Pipeline

o Demo: Queue Trigger, Blob Output
o Queue Trigger, Blob Output Recap
o Blob Trigger, SendGrid Output
o Blob Trigger, SendGrid Output Recap
o Demo: Table Storage Output
o Table Storage Output Recap
o Demo: IBinder and Table Storage Input
o IBinder and Table Storage Input Recap

• Deploying Azure Functions

o Ways to Create Azure Functions
o Demo: Getting Started with Azure Command Line Tooling
o Demo: Creating and Testing Functions with Command Line Tooling
o Demo: Visual Studio Integration
o Options for Deploying Azure Functions
o Demo: Deploying with Git

• Working in Production

o How Can I Monitor My Functions?
o Demo: Live Monitoring
o Demo: Historic Monitoring
o Demo: Monitoring Cost
o How Can I Debug My Functions?
o Demo: Local Debugging a C# Function in Visual Studio
o Demo: Local Debugging a JavaScript Function in VS Code
o Demo: Remote Debugging Azure Functions
o How Can I Reference NuGet Packages?
o How Can I Secure My Functions?
o Demo: Working with Function Keys
o How Do I Configure CORS?
o How Can I Learn More?

 

Abstract:

Azure Stream Analytics is a fully managed, cost effective real-time event processing engine that helps to unlock deep insights from data. Stream Analytics makes it easy to set up real-time analytic computations on data streaming from devices, sensors, web sites, social media, applications, infrastructure systems, and more.

With a few clicks in the Azure portal, you can author a Stream Analytics job specifying the input source of the streaming data, the output sink for the results of your job, and a data transformation expressed in a SQL-like language. You can monitor and adjust the scale/speed of your job in the Azure portal to scale from a few kilobytes to a gigabyte or more of events processed per second.

This course will give you an insight into Azure Stream Analytics and help you to implement, control and monitor your data through the pipeline.

Table of Contents:

• Introduction to Real-Time Analytics

o Traditional Analytics Approaches
o Shifting to a Streaming Data Solution
o Complement Existing Analytics with Streaming Data
o Multiple Stream Processing Offerings

• Value Proposition of Real-Time Data in Azure

• Common Scenarios for Real-Time Analytics

o Inventory Management
o Demand Based Price Elasticity
o Infrastructure Monitoring
o Device Telemetry
o Website Analytics / Content Management
o Fraud Detection

• Architecture and Components

o Data Sources
o Data-Integration Layer

 Azure Event Hubs
 Azure Blob Storage
 Data-Integration Best Practices

o Real-Time Analytics Layer

 Azure Stream Analytics
 Azure Machine Learning

o Data Storage Layer

 Azure Blob Storage (with HDInsight
 Azure SQL Database

o Presentation / Consumption Layer

 Power BI
 Event Processor Application

o Connected Architecture.

Abstract:

IoT device SDKs are available in most popular languages, so that you can implement your client application on wide variety of operating systems and hardware platforms.

IoT Hub also provides per device authentication, which helps in managing the devices that connect to the hub. Azure Stream Analytics is used to analyze data streaming from various IoT devices and helps in providing important information.

This course will give you an insight into Azure IoT Hub and help you to connect, control and monitor your IoT devices in Azure IoT Hub.

 

 

 

 

Table of Contents:

• Introduction to IoT Hub.

o Azure and IoT.
o What is Azure IoT Hub?
o Pricing Structure of Azure IoT Hub.

• Creating and Configuring IoT Hub.

o Overview of device management.
o Manage cloud device messaging with iothub-explorer.
o Usage metrics.
o Operations monitoring.
o Configure IP filtering.

• Connecting devices to Azure IoT Hub.

o Setup your device.
o Available SDK’s
o Use a simulated device.
o Use a simulated gateway.
o Use a physical gateway.
o Use a physical device.
o Device twins.

• Introduction to Consuming Data from IoT Hub.

o Introduction to Stream Analytics.
o Data Visualization in Power BI.
o Data Visualization with Web App.

• Concepts to know before planning IoT Solutions.

o Security Security from the ground up.

 Security best practices.
 Security architecture.

o Scale your solution.

o High availability and disaster recovery.

o Comparison of IoT Hub to Event Hubs.

Abstract:

In this course students will learn how to use SQL Server Data Tools (SSDT) to create SSIS packages to extract, transform, and load (ETL) data using a variety of data sources, transformations, and destinations.

They will also understand SSIS package management and package deployment with the new SSISDB Package Catalog.
They will also learn how to write solid code using debugging, error handling, and logging techniques.

 

Table of principal contents:

 

• Introduction to Integration Services
• Control Flow
• Data Flow Sources and Destinations
• Making Packages Dynamic
• Containers and Advanced Control Flow Tasks
• Package Reliability
• Advanced Scripting
• Deployment and Troubleshooting
• Data Quality Services

This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals.

The course will very likely be well attended by SQL power users who aren’t necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers

Table of Contents:

• Introduction to T-SQL Querying
• Writing SELECT Queries
• Querying Multiple Tables &Sorting and Filtering Data
• Working with SQL Server Data Types
• Using DML to Modify Data
• Using Built-In Functions
• Grouping and Aggregating Data
• Using Subqueries
• Using Table Expressions
• Using Set Operators
• Using Window Ranking, Offset, and Aggregate Functions
• Pivoting and Grouping Sets
• Executing Stored Procedures & Programming with T-SQL
• Implementing Error Handling & Transactions
• Improving Query Performance

This course introduces the SQL Server Reporting Services platform, and teaches the necessary skills to develop, deploy and maintain Reporting Services.

Table of Contents:

• Introduction to Reporting Services
• Authoring Basic Reports
• Manipulating Data Sets
• Report Enhancements
• Advanced Report Components
• Report On OLAP Data
• Mobile And KPI Reports
• Administering Reporting Services
• Administering Reporting Services
• Self-service Reporting
• Branding Reporting Services

This course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database.

The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.

 

Table of Contents:

• Design and Implement Tables.
• Describe advanced table designs
• Ensure Data Integrity through Constraints.
• Describe indexes, including Optimized and Columnstore indexes
• Design and Implement Views.
• Design and Implement Stored Procedures.
• Design and Implement User Defined Functions.
• Respond to data manipulation using triggers.
• Design and Implement In-Memory Tables.
• Implement Managed Code in SQL Server.
• Store and Query XML Data.
• Work with Spatial Data.
• Store and Query Blobs and Text Documents.

Abstract:

On the current globalized market, where we compete in distinct markets with distinct cultures speaking distinct languages, having a fully localized application can mean the difference between users skipping your application or using it.

Still, it’s not just replacing your text with resources, or allowing for locale-specific date formats, but taking into consideration aspects of how language, culture and customs can influence the UI and workings of an application.

This training will go over the main challenges of internationalization and localization, how to solve them and avoid the main pitfalls and trouble spots. It will also go over best practices for text and other media, and processes for translation of content and resources.

 

 

Table of Contents:

• Intro to I18N and L10N

o Motivation for globalizing software
o Definition of Internationalization
o Definition of Localization

• I18N of Text

o Alternatives for representing text for translation
o RTL and LTR text
o Gender, pluralization and other linguistic details
o Best practices for I18N of text

• I18N of Text in .Net

o Resources and ResourceManager
o Encodings

• I18N of Text in .Net Core

o IStringLocalizer, IHtmlLocalizer, IViewLocalizer and friends

• I18N of Text in client-side javascript code

o Alternatives for storage of resources
o Formatting of text
o Dates and times

• I18N of Web UIs

o Affordances
o RTL vs LTR UI

• Culture in .Net

o Currency
o Formatting
o CurrentCulture, CurrentUICulture
o Changes in .net 4.6

• Dates, times and timezones

o DateTime, DateTimeOffset and Timezones
o When to store in UTC, and when to be timezone-aware

• Multilanguage content

o Considerations on how to represent and handle Multilanguage content
o Impacts in full text search
o Impacts in caching

• Tooling

o Supporting tools for translation processes
o Infrastructure tools for supporting localizing applications