Magento 2 Development Workshop Learn More

Manual QA in Magento 2 for Beginners

10 lessons

SQL

SQL, what can be said about this query language? I guess all of you are sick of SQL courses on the internet, it is flooded with them. But I will try to summarize it and make it easier to understand.

SQL (Structured Query Language) is a domain-specific language used in programming and designed for managing data helps in a relational database management system. This is how wikipedia says to us about this topic.

As a casual user it is hard to understand why you need this one, but in general it is a tool that helps you to manage system data, like images, thumbnails, media files, user data and other.

SQL is a tool to create specified tables where data is divided into rows and columns. It is like every type of data has its own table with specified rows where data about each element has its own row.

For most QA engineers this knowledge is not used in practice, but this can help anyone who wants to understand the problem, not only locate and catch it.

There are a lot of the apps on the internet that can be used for SQL, but basically you can use any FTP app. You will find them with one google query.

image1

This simple example will show you how this is going, but the syntax in general of SQL queries can’t be checked in so quick a way as I’m trying to. So please let me know if you are interested and I will create some kind of guide about them particularly.