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 )
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.