Intermediate SQL Tutorials

Working with JSON in an RDBMS – Part 1, MS SQL Server

Working with JSON in an RDBMS – Part 1, MS SQL Server

I have to begin by admitting that I'm no expert with NoSQL databases. I understand them conceptually and have worked hands-on with MongoDB and AWS DynamoDB in some learning and exploratory environments. But I have yet to build anything substantial...
Working with JSON in an RDBMS – Part 2, PostgreSQL

Working with JSON in an RDBMS – Part 2, PostgreSQL

In the first installment in this series, I covered working with JSON documents in a SQL database using Microsoft SQL Server. As we saw, there are a number of functions that Microsoft has added to their database platform to allow you to store a...
Working with JSON in an RDBMS - Part 3, MySQL

Working with JSON in an RDBMS - Part 3, MySQL

Welcome to the third and final installment covering how to store and interact with JSON data in an RDBMS. We've covered using JSON in PostgreSQL and Microsoft SQL Server. What we've learned so far is that Microsoft pushes you to store the data in...
%d bloggers like this: