Here is the expert-level, insider guidance you need on using Azure SQL Database as your back-end data store. This book highlights best practices in everything ranging from full-stack projects to mobile applications to critical, back-end APIs. The book provides instruction on accessing your data from any language and platform. And you learn how to push processing-intensive work into the database engine to be near the data and avoid undue networking traffic. Azure SQL is explained from a developer's point of view, helping you master its feature set and create applications that perform well and delight users.
Core to the book is showing you how Azure SQL Database provides relational and post-relational support so that any workload can be managed with easy accessibility from any platform and any language. You will learn about features ranging from lock-free tables to columnstore indexes, and about support for data formats ranging from JSON and key-values to the nodes and edges in the graph database paradigm. Reading this book prepares you to deal with almost all data management challenges, allowing you to create lean and specialized solutions having the elasticity and scalability that are needed in the modern world.
This repo contains all the code samples discussed, used and referenced in the "Practical Azure SQL Database for Modern Developers" book, and additional resource on the topics discussed in the book.
The book is just a starting point. You can find more specific samples also here:
Azure SQL DB Samples and Best Practices
And, beside those, we have prepared even more samples to show how you can create amazing end-to-end solution with any language you like:
- Creating a REST API with .NET Core and Azure SQL
- Creating a REST API with Python and Azure SQL
- Serverless REST API with Azure Functions, Node and Azure SQL
- Using Change Tracking API to sync data between Apps and the Cloud
- Creating API to securely access data using Azure SQL Row Level Security
The above list is just an excerpt of the many samples you can find here:
There are plenty of videos on Azure SQL to help everyone, from the beginner to the experienced developer:
If you want to have some hands-on experience, you can choose among different workshops and labs:
SQL Server and Azure SQL Labs and Workshops
There are also several "learning paths" that you can use to learn at your own pace. They provide step-by-step guidance to anything you may need:
If you want even more details on Azure SQL and you are already familiar with SQL Server and looking forward to move to the cloud, Bob's book is for you:
Azure SQL Revealed - A Guide to the Cloud for SQL Server Professionals