SQL Server for Developers, Workshops

SQM03 Workshop: Full Stack Development From Zero to Hero

11/14/2022

8:30am - 5:30pm

Level: Introductory to Intermediate

Davide Mauri

Principal Product Manager

Microsoft

Let's build a fullstack/jamstack solution together, in one day. Starting from scratch, we'll see how using Azure Static Web Apps, Vue.js, Azure Functions and Azure SQL Database you can build a modern, ultra-scalable, secure solution, in just a day. We'll cover the basic of a Jamstack solution, and we'll go through all these steps to have it built and tested locally and deployed in Azure, using GitHub to setup a CI/CD pipeline that will take care of everything. We'll go through changing requirements, authentication and authorization, scalability and alternative architectures so that, and the end of the day, you will have a solid and practical foundation for building a modern, cloud based, hyper scalable, solution.

We will cover the following topics:

  • Jamstack Architecture
  • Static Web Apps, Vue.Js and Azure Functions
  • The Database: Azure SQL DB (Why? Stored Procs or not? JSON? Dapper or EF Core?)
  • Authentication
  • Connection Resiliency
  • Deployment and CI/CD
  • Caching
  • Alternative Implementations