Discussing the article: "Market Simulation (Part 23): Getting Started with SQL (VI)"

 

Check out the new article: Market Simulation (Part 23): Getting Started with SQL (VI).

In this article, we will see how to visualize a database and, from that, understand how it is structured. This is done by analyzing the database’s internal structure. Although this may seem unnecessary at first, it is fully justified if we really want to become database administrators. After all, some people make a living maintaining and designing databases.

In the previous article Market Simulation (Part 22): Getting Started with SQL (V) we looked at how to use—or, more precisely, how to associate—a primary key with a foreign key. If this is not clear yet, I recommend reading the previous articles first. That background is necessary to fully understand what we will do here.

Before we start looking at the MQL5 code, however, we need to understand a few SQL concepts.


Author: Daniel Jose