- “SQL Problems and Solutions”, I. Moiseenko Interactive SQL textbook
- Bytescout SQL Trainer is a fast and pleasant simulator, complicated as your advance.
- Simple SQL queries exercises for postgres
- SQL Tutorial for Beginners: Database, Join, Where, Group by, Having, Order by, Like, In, Between
- How to count everything in the world with one SQL request. Window functions postgreSQL
- A simple simulator with theory
-PostgreSQL installation manual at macos
-An example of a MySQL appeal using Python using the SQLALCHEMY
-An example of an appeal to postgreSQL using Python:
-Window Function -
-Window Function-?
-A good article about the SQL window functions-
- Russian translation of documentation to Beautifulsoup Beautiful Soup is the Python library to extract data from HTML and XML files. She works with your favorite Parser to give you natural ways to navigate, search and change the analysis of the analysis. She usually saves programmers hours and days of work.
- An article with an example of parsing data from websites using Beautifulsoup is highlighted all the main stages: the formation of a request and obtaining a page using Reques, searching for the desired element in HTML through the inspector, selecting data from the element through the BeautifulsUP methods.
Working with primary analytics: unload raw data from the metric using a script