Do you have a solid Transact-SQL foundation? This query language, also known as T-SQL, is used to work with data in SQL Server and Azure SQL Database, and is a fundamental skill for aspiring database professionals and application developers.Explore T-SQL in a series of self-paced modules which include lectures, demos, hands-on labs, and self-assessments. Find out how to use T-SQL to retrieve, insert, update, and delete data in a database. Learn about table expressions, grouping sets, error handling, and more. If you're studying for Exam 70-461, this course can help you prepare for it.(NOTE: Download course lab files.)Instructors | Graeme Malcolm - Microsoft Senior Content Developer, Geoff Allix - Content Master Principal Technologist. Twelve video modules.
If you are a PHP developer, you may be wondering what Microsoft Azure can do for you or what you can do with Azure. Get those questions answered in this course, which is an introduction to integrating Azure Services into your current and future PHP development projects. Learn about deploying your existing application to Azure, and take a look at the database services available in Azure. Begin with an overview of PHP development with Azure, the different Azure SQL services, and Azure Web App Services. See how to connect the current code base to a newly created database, and push code up to the web app for a deployed full-stack application. Plus, get a look at additional resources, in this practical Azure for PHP developer training.
If you’re a SQL Data Pro, check out this demo-packed course to explore using PowerShell to manage SQL Server and Azure SQL Database. Hear about the background of PowerShell, and learn PowerShell basics, such as how to get help, use cmdlets, and load modules. Look at task automation and configuration, and learn how to provision, deploy, and manage SQL Server in Azure Virtual Machines and Azure SQL Database. Plus, see how to use the SQLPS module to administer SQL Server, both on-premises and in Azure Virtual Machines. Don’t miss this practical PowerShell training.
What does a modern approach to data in new apps look like? Join us to find out, and see how to transform data into intelligent actions through the use of Microsoft Azure. Learn how to combine Azure SQL Database, DocumentDB, and Azure Search to ingest store documents, social data, and structured transaction data to build applications with different data needs. Plus, explore the functional capabilities for relational, non-relational, NoSQL, real-time streaming, and search workloads. NOTE: To find other Cloud Roadshow courses on MVA, search Cloud Roadshow.
Interested in Azure SQL Database training? Be sure to watch this session! Azure SQL Database is a robust relational database platform for developing, deploying, and managing the data tier in a wide range of cloud-based applications. Join us to explore the latest investments in the Azure SQL Database in the areas of service tiers, performance, scale out, business continuity, security, and experiences for data developers and data management. Note: You can find other Cloud Roadshow courses on MVA by searching “Cloud Roadshow”.
XML is a commonly used data format, and is often used to store and communicate data structures used by applications. SQL Server and Azure SQL Database provide built-in support for XML that enables application developers to combine relational and XML data structures at the database level. This course explores this XML support.
If you’d like to learn application development, end to end, be sure to take this course. Get a look at a number of cloud-based technologies, see practical demonstrations, and dig into what’s new in Visual Studio 2017, in this course, part of Connect(); //2016 Day 3. In six in-depth modules, take a look at the interoperability of many tools, platforms, and APIs. From .NET Core and the power of Application Insights to Azure SQL, SQL Server 2016, and Azure Storage, get helpful insights into the Microsoft ecosystem. Plus, learn about Power BI and Office Graph, Azure Search, Docker, and much more. Take this opportunity to see how these fit together, as you build a solution, from start to finish, and explore full-stack development with the experts, in this Azure for developers course.
Saving please wait...