Intermediate SQL Tutorials

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

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

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

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

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