studying sql at the faculty of applied mathematics and Informatics at MIPT website: http://bdis.umeta.ru/db/db_course/labs/index.html
Writing selects on an existing database
familiarity with sql syntax. Used the book on habr https://habr.com/ru/post/255523/
Design my database on the topic of shipping in a Vertabelo environment.
The database is designed for cargo tracking and transportation analytics
Writing sql script to create and populate the designed database.
The data was generated using Python (numpy library) or filled in manually
Setting tasks for the purpose of the database.
Writing scripts for tasks.
Delete and modify data (insert and update). Nested select statement
A study of the views in SQL.
Formulation of problems that are solved with the help of representations.
Writing a script that creates them.