Intermediate SQL Tutorials
How to Create a Stored Procedure in SQL
If you need to package up blocks of code to run regularly, you may want to create a stored procedure in SQL. In this article, we will cover the basics of creating stored procedures. You will also see...
How to Query Metadata in SQL
Learning how to query metadata in SQL will help you to navigate your databases more efficiently. Metadata is data about your database structure. This includes information about all of the objects in your...
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....
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...
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...