Introduction ​

This is a beginner's SQL tutorial for those with no prior experience.

What is SQL? In simple terms, SQL is the standard computer language for accessing and manipulating relational databases. This means that regardless of the programming language used (Java, Python, C++, etc.), whenever you need to operate on a relational database—such as when an e-commerce site needs to store user and product information, or when a mobile game needs to store user items and progress in a database—you must use SQL to accomplish that.

Therefore, modern programs cannot be separated from relational databases, and mastering SQL is essential for using them.

In this tutorial, you will learn the basic concepts of relational databases, how to manipulate databases using SQL, and the basic installation and usage of one of the most popular open-source databases, MySQL.

NoSQL ​

You may have also heard of NoSQL databases, which are databases that do not use SQL, such as MongoDB, Cassandra, Dynamo, and others. These are not relational databases. Many people advocate that modern web applications no longer require relational databases and can solely rely on NoSQL. However, in reality, SQL databases have never been replaced. Let’s take a look at the evolution of NoSQL:

1970: NoSQL = We have no SQL
1980: NoSQL = Know SQL
2000: NoSQL = No SQL!
2005: NoSQL = Not only SQL
2013: NoSQL = No, SQL!

Today, SQL databases continue to serve as the core data storage for various applications, while NoSQL databases complement SQL databases. The relationship is no longer an either/or situation but rather a primary/secondary relationship. Therefore, regardless of the programming language used, whether in web development, game development, or mobile development, mastering SQL is essential for all software developers.

Don't hesitate any longer! Start now, and stick with it for a week to master SQL!