Intermediate SQL Tutorials

Intermediate SQL Tutorials

How to Create a Stored Procedure in SQL

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

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

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

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

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