Learn how to build a full stack application with Azure SQL and Prisma

A self-paced course from Microsoft Study primarily based on an actual case examine on find out how to implement Azure SQL utilizing Prisma and Vue.

Microsoft is striving to make its Azure platform a serious participant within the cloud computing market, attempting to make Azure the dominant atmosphere for utility growth. To this finish, Microsoft has launched numerous applications and programs, such because the one we just lately examined within the “Take the Azure Cosmos DB Cloud Abilities Problem”, a free self-paced course supplied by Microsoft that offers you an opportunity to increase your data of Azure Cosmos DB.

This publish falls into the identical class; Free, self-paced and quick supply. In it, you learn to create a Full Stack Software from Entrance to Again-Finish, utilizing:

  • node. youth
  • Vue. youth
  • Prisma
  • Azure SQL Database
  • Azure Jobs
  • Azure Persistent Internet Apps
  • github procedures

However first let’s check out the stack. We do not have to speak about Node/Vue and GitHub actions; Everybody is aware of what it’s.
However some customers who’re new to Azure won’t be accustomed to its elements resembling Azure SQL, Azure Capabilities, and static internet functions.

Subsequently, Azure SQL Database is a part of the Azure SQL household, which is a totally managed, all the time up-to-date relational database service for the cloud.

Azure Capabilities, supplies serverless computing for Azure. You should use the capabilities to construct internet APIs, reply to database modifications, course of IoT flows, handle message queues, and extra.

Azure Static Internet Apps supplies static content material internet hosting and dynamic scaling for built-in serverless APIs. It helps front-end JavaScript and TypeScript functions, together with these developed utilizing well-liked frameworks resembling Vue. js, React, Angular, and extra.

What about Prisma? Whereas not solely associated to Azure, it’s a new know-how, so I’ve left one of the best for final. Prisma is an open supply subsequent era node. js and TypeScript ORM. It consists of the next elements:

  • Prisma consumer: an mechanically generated, type-safe question builder for Node. js & TypeScript
  • Prisma Migrate: Migration System
  • Prisma Studio: GUI for viewing and modifying information in your database
  • Prisma consumer can be utilized on any node. js (supported variations) or a TypeScript backend utility (together with serverless functions and microservices). This may very well be a REST API, a GraphQL API, a gRPC API, or anything that wants a database.

The principle objective of Prisma is to make utility builders extra productive when working with databases. Listed below are some examples of how Prisma achieves this:

  • Enthusiastic about objects somewhat than mapping relational information
  • Queries don’t have any lessons to keep away from advanced kind objects
  • One supply of fact for database and utility fashions
  • Wholesome restrictions stop widespread pitfalls and patterns
  • An abstraction that makes the best factor straightforward (“The Pit of Success”)
  • Kind protected database queries that may be validated at compile time
  • Much less modular type so builders can concentrate on the vital elements of their utility
  • Autocomplete in code editors as an alternative of looking for documentation

The course combines all of those elements to create a whole, database-driven worker administration utility.
In response to the next technique:

  • Course overview
  • Studying targets
  • What’s Prisma?
  • Why ought to we use Prisma?
  • Fundamental ideas about Prisma
  • Essential sources and conclusion
  • What’s Azure SQL?
  • Why ought to we use Azure SQL?
  • Azure SQL help in Prisma
  • Essential sources and conclusion
  • What are Azure Static Internet Apps?
  • Azure static internet functions workflow
  • Why ought to we use Aswa?
  • Frameworks that we will use with ASWAQ
  • Essential sources and conclusion
  • Overview of growth and set up instruments
  • configuration. devContainer folder
  • Essential sources and conclusion
  • Software overview
  • Entrance-end utility fork
  • Again mission structuring
  • Create a database server
  • Create a database
  • Create a shadow database
  • Set up packages
  • Database modeling with Prisma
  • Use publication migrations
  • Utilizing Prisma Studio
  • Develop “create worker”
  • Developed by “GetEmployee”
  • Growth of the “Worker Replace”
  • Growth of “Delete Worker”
  • Activate the appliance with aswaaq
  • subsequent steps

The 37 movies are fairly brief, starting from 2 to 10 minutes in size, making for a light-weight weekend studying checklist.

Whereas I used to be initially drawn to it with the Prisma side, the remainder of the stack actually does make for mission, too. On the identical time you get to know the Azure platform, which will be helpful, in reality…

extra data

Full stack utility with Azure SQL Playlist and Prisma-Youtube

Stack utility full with Azure SQL and Prisma-Github

Associated articles

Take the Azure Cosmos DB Cloud Abilities Problem

To concentrate on new articles on I Programmer, subscribe to our weekly publication, Subscribe to our RSS feed and comply with us on Twitter, Fb or linkedin.

Signboard

picobook

feedback

Or e mail your remark to: feedback@i-programmer.data

Leave a Comment