How to quickly deal with the basics of SQL?

Good evening all,
want to make for myself for work application in Python + Tkinter + SQL
question on SQL prompt please, what literature is better to use
to learn the basic functions, and there are many different books on databases,
I do not understand what to choose, so the key points to understand:
the app will save the information in the database (different extracts from the building regulations),
then need the ability to edit, delete records and output records by a certain
their categories (e.g. types of buildings), i.e. me much at the moment from SQL
not required )
March 19th 20 at 08:31
3 answers
March 19th 20 at 08:33
View sql-ex, I think everyone starts talking about sql from this site.
March 19th 20 at 08:35
The book will not advise, but it is important to understand the concept of tables and work with them. That's a table, it has a certain set of fields, such as a set of properties of the class. And each entry in the table is an instance of the object. You can get all or some of the entries/instances from a table, you can edit one of them or update the properties/fields from several at once. You can delete. You can create a new one.
Under each entity to select its table. You can make relationships between tables when one of the fields refers to another table.
When understanding this, you can read any book on SQL syntax and library for your YAP to work with the database. And you can take the first steps in programming, database.
But when these basics are settled down, you can then sit down and carefully read one of the fundamental books.
it is important to understand the concept of spreadsheets and work with them

It is important to understand relational theory and its application in a relational DBMS. - Graham commented on March 19th 20 at 08:38

Find more questions by tags DatabasesSQL