Using Non-Relational Data in SQL Server
Go beyond integers and strings, and use non-relational data in your SQL Server applications.
Featured on: Nov 9, 2018
You’ve probably heard about all the cool things that developers are doing in Azure Cosmos DB. It’s the best place to start if you’re building modern NoSQL applications from scratch. This course shows you how to build applications that use non-relational data structures in SQL Server. Whether your app needs to store unstructured data, or you want to store coordinates for your map app in a meaningful way, you’ll learn skills that go beyond storing traditional data types. You’ll also learn how to integrate legacy applications with modern applications that are built in Azure Cosmos DB.Bring your experience in SQL Server database development, along with your knowledge of T-SQL and relational databases, and explore the flexibility of non-relational data and the kinds of apps you can build. We l start with a look at the capabilities of SQL Server, and learn about non-relational data, and apps that use this type of data. Then, you l learn all the things you can do with XML data in SQL Server. Dive into some interesting spatial data types, and learn about storing files with BLOB. Tie it all together, and you l get the details on how JSON can be stored in SQL Server and how you can integrate SQL Server relational data with NoSQL data stored in Azure Cosmos DB. Find out why the pessimist who says you can’t build modern NoSQL apps in SQL Server is wrong.