• Length:
    4 Weeks
  • Effort:
    2–4 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $99 USD

  • Institution
  • Subject:
  • Level:
    Intermediate
  • Language:
    English
  • Video Transcript:
    English

Prerequisites

  • Knowledge of writing T-SQL queries
  • Knowledge of basic relational database concepts
  • Knowledge of SQL Server Database Development

About this course

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'll 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'll 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'll 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.

What you'll learn

  • What is NoSQL
  • Store XML Data in SQL Server
  • Use Spatial Data in SQL Server
  • Considerations for BLOB Data storage
  • Storing and Returning JSON
  • Integrating SQL Server with  Azure Cosmos DB

Meet your instructors

Geoff Allix
Microsoft Certified IT Professional for SQL Server
Content Master
Pete Harris
Senior Content Developer
Microsoft’s Learning Experiences

Pursue a Verified Certificate to highlight the knowledge and skills you gain $99.00

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    EdX, a non-profit, relies on verified certificates to help fund free education for everyone globally