Generic Microsoft Exam Voucher via Prometric Testing Centers.

Take an existing ASP.NET MVC application and expand its functionality as part of moving it to Azure. Learn how to build an application infrastructure in Azure, host web applications on the Azure platform, store SQL data and tabular data in Azure, design Cloud applications, automate integration with Azure resources, and secure Azure web applications. Prerequisites: Students must have experience working with the Azure platform. They should also have a general understanding of C# concepts for the lab scenario

This five-week, ten-session course is the first course in the MCSA: Windows Server 2016 series. It is designed primarily for IT professionals who have some experience with Windows Server. Learn how to manage and computer storage by using Windows Server 2016. Understand the scenarios, requirements, and storage and compute options that are available and applicable to Windows Server 2016. Prerequisites: Experience working with Windows Server, general IT and networking knowledge.

Provides the fundamental networking skills required to deploy and support Windows Server 2016 in most organizations. Covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking. Prerequisite: LNT0006 Installation, Storage, and Compute with Windows Server 2016 or equivalent experience.

This course is designed 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. Write SELECT queries, query multiple tables, sort and filter data, use built-in functions, group and aggregate data types, work with table expressions and set operators, and program with T-SQL. Prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality; working knowledge of relational databases.

Learn the skills to administer and maintain the SQL Server 2016 database infrastructure. The course is designed for developers of applications that deliver content from SQL Server databases. Learn how to authenticate and authorize users and access resources. Understand how to monitor and troubleshoot the SQL Server infrastructure. Prerequisites: basic knowledge of the MS Windows core functionality, working knowledge of Transact-SQL, working knowledge of relational databases, and some experience with database design.

Gain the knowledge and skills to provision a Microsoft SQL Server 2016 database, both on-premise and in Azure. Covers installing from new and migrating from an existing install. Learn to upgrade and configure SQL servers and manage databases and files. Prerequisites: basic knowledge of the MS Windows operating system and its core functionality, working knowledge of Transact-SQL, working knowledge of relational databases, and some experience with database design (LNT0009, Administering a SQL Database Infrastructure or equivalent experience).

Provides the knowledge and skills to provision a Microsoft SQL Server 2016 database. Covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. Focuses on hands-on work creating business intelligence (BI) solutions, including Data Warehouse implementation, ETL, and data cleansing. Prerequisites: basic knowledge of the Microsoft Windows operating system and its core functionality, working knowledge of relational databases, and some experience with database design.

Provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases. Covers SQL Server architecture, scheduling, waits, and I/O. Focuses on SQL Server memory and concurrency, along with query execution and query plan analysis. Covers tools and techniques to monitor, trace, and baseline SQL Server performance data. Prerequisites: basic knowledge of the Microsoft Windows operating system and its core functionality, working knowledge of database administration and maintenance, and working knowledge of Transact-SQL.

Helps you prepare for Microsoft’s Azure Developer certification exam AZ-200: Microsoft Azure Developer Core Solutions. Designed for developers who already know how to code in at least one of the Azure-supported languages. Covers Azure architecture, design and connectivity patterns, and choosing the right storage solution for your development needs. Focuses on C#, Node.js, Azure CLI, Azure PowerShell, and JavaScript. Recommended: Students should have some experience with Azure and must be able to program in at least one Azure-supported language.

Helps you prepare for Microsoft’s Azure Developer certification exam AZ-201: Microsoft Azure Developer Advanced Solutions. Defines asynchronous processing, autoscaling, long-running tasks, and distributed transactions. Learn how to integrate and manage APIs by using the API Management service, configure a message-based integration architecture, and develop an application message model. Covers how to integrate Azure Cognitive Services, like Computer Vision, QnA Maker, and natural language processing in your solution. Create and manage bots using the Bot Framework and Azure portal. Learn how to leverage Azure Time Series Insights, Stream Analytics and the IoT Hub for your IoT solution. Focuses on C#, Node.js, Azure CLI, Azure PowerShell, and JavaScript. Recommended: Students should have some experience with Azure and must be able to program in at least one Azure-supported language.

Investigate how to develop advanced ASP.NET MVC applications using the .NET Framework and technologies. Learn coding activities that enhance performance and scalability of website application. Gain knowledge in developing advanced web applications and creating websites that separate the user interface, data access, and application logic. You will be prepared for Microsoft certification exam 70-486 Developing ASP.NET MVC 4 Web Applications.

Explores PowerShell, a scripting language and a working administrative shell available for Windows, Linux, and the Mac environments. Starts with understanding what PowerShell is, what you can do with it, and where it is available to use. Identifies techniques, features, and putting PowerShell to use in automating parts of your Windows-based IT work. Covers key concepts, tips, and usage of scripting, in addition to lab work to reiterate the material via hands-on work. Recommended Preparation: some IT Experience, such as CompTIA A+, MCSA Windows 10, Server 2012R2, or other relevant experience.

Gain the knowledge and skills to provision a Microsoft SQL Server 2016 database, both on-premise and in Azure. Covers installing from new and migrating from an existing install. Learn to upgrade and configure SQL servers and manage databases and files. Prerequisites: basic knowledge of the MS Windows operating system and its core functionality, working knowledge of Transact-SQL, working knowledge of relational databases, and some experience with database design (LNT8764, Administering a SQL Database Infrastructure or equivalent experience).

Identifies foundational level knowledge of cloud services and how those services are provided with Microsoft Azure. Covers 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). Explores some core Azure services and solutions, as well as key Azure pillar services concerning security, privacy, compliance and trust. Prepares for Microsoft certification exam AZ-900.

Teaches how to implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft Azure data services and Microsoft SQL Server. Explores how to use a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes. Prepares for Microsoft certification exam DP-300. Recommended Preparation: basic knowledge of the Microsoft Windows operating system and its core functionality; working knowledge of relational databases.