Introduction
Mobile apps, cloud services, serverless technologies, IoT devices, web APIs; modern applications combine a diverse set of new technologies to supply users relevant information directly to their mobile devices at just the right moment. At the heart of these modern applications is a vast amount of data that is generated, ingested, synthesized, analyzed, and queried. Which database provides the right foundational mix of capabilities and scalability on which to build? Azure SQL Database is a reliable, scalable, and feature-rich data platform around which you can design your modern applications.
Suppose you work for a major city's transportation department and you want to increase the number of bus riders. To make it convenient to jump on the bus, you want to build a mobile app that allows users to monitor a bus’s progress along its route. By providing up-to-the-second information on the whereabouts of the next bus along the route, you can help potential riders eliminate the situation where they either end up waiting for the bus or running to catch the bus and missing it.
A mobile application that can provide this type of real-time information requires an architecture featuring many of the technologies that we already introduced, including a mobile app, cloud services, serverless technology, IoT devices, and web APIs. Most importantly, you'll need a data store like Azure SQL Database that can provide a foundation for it all.
In this module, you'll break down a scenario for an application and build a multiservice architecture of a solution, which is based on the microservices approach. After constructing the architecture, you'll dive into the first crucial step: building the foundation for a modern application. Using Azure SQL Database, you'll deploy, configure, and automate continuous integration and continuous delivery/continuous deployment (CI/CD) for the database component of your full stack application.
By the end of this module, you'll be able to use modern database capabilities to build a foundation for modern applications.
Learning objectives
By the end of this module, you'll be able to:
- Build a foundation for applications with Azure SQL Database.
- Demonstrate modern database capabilities with Azure SQL Database.
Prerequisites
- Ability to navigate the Azure portal
- Familiarity with database concepts such as stored procedures and querying
- Familiarity with CI/CD concepts such as GitHub Actions
- Familiarity with available Azure services