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 to build on? Azure SQL Database is a reliable, scalable, and feature-rich data platform that you can design your modern applications around.

Suppose you work for the transportation department of a major city 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 will require an architecture featuring many of the technologies that we already introduced, including a mobile app, cloud services, serverless technology, IoT devices, web APIs, and most importantly, you'll need a data store like Azure SQL Database that can provide a foundation for it all.

In this series of four modules that are part of the Build serverless, full stack applications in Azure learning path, we'll design and build this bus ride application from scratch.

In this module, you'll break down a scenario for an application and build a multi-service 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.


  • 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