How to quickly understand the basics of SQL?

Question

SQL

Good evening everyone,
I want to make an application for myself in Python + Tkinter + SQL SQL
question - please tell me which literature is better to use in
order to master the basic functions, otherwise there are many different books on the subject of databases,
I don’t understand which one is better to choose, in order to understand the main points:
in the application I will save information in the database (different extracts from building codes),
then I need the ability to edit, delete records and display records by
their certain categories (for example, by types of buildings), i.e.
I don't need much from SQL at the moment )

Answer 1

Look at sql-ex, I think everyone starts talking about sql from this site.
sql-ex.ru
sql-tutorial.ru

Answer 2

I won’t recommend the book, but here it is important to understand the very concept of tables and working with them. That there is a table, it has a certain set of fields, sort of like a set of properties for a class. And each record in the table is an instance of such an object. You can pull all or some records/instances from the table, you can edit one of them or update the properties/fields of several at once. Can be deleted. You can create new ones.
Under each entity to allocate the table. You can make links between tables when one of the fields refers to another table.
When there is an understanding of this, you can read any reference on the SQL syntax and on the library for your PL for working with the database. And you can take the first steps in programming under the database.
But when these foundations are settled, then you can sit down and thoughtfully read one of the fundamental books.

Answer 3

What would you recommend to use for using databases through Python?