Mysql for email marketer - what features do you need to know?

Question

MySQL

Hello!
Usually in email marketing, a general marketer works with a project manager or other IT specialist, who can be tasked with obtaining the necessary data from the database.
Suppose that there is no such specialist, and our marketer needs to pull out the data on his own, for example, to conduct regular mailings. He will need email, username, first name last name, demographic data, purchase data (amount, time of purchase, product name) + some events that the analytical system collects (last visit date, region where the visit or registration was from, etc.) . Our specialist has little knowledge of working with databases, but he will have to pull out the data himself.
Actually, the question is: where to start in order to do all of the above on your own? Those. independently find / determine the desired data type and how to collect (uploads to csv, api, etc.). You can link to videos, articles, your own experience.

Answer 1

It is best to design in advance the main scenarios for requesting data and ask technical specialists to make a form with password access, in which you can select what you need with drop-down lists and checkboxes, and after receiving the necessary data by clicking the "Download" button, download them.
1. Understand the principles of relational databases (building a database based on relationships),
there is now one main principle - 3rd normal form, read:
Exercise : sql-ex.ru/learn_exercises.php
4. To save:

• learn how to upload to a file so that it can be downloaded for later use
  
• find a converter for converting the SQL result to csv, I found this one: www.convertcsv.com/sql-to-csv.htm, but maybe there is a better one
  
• or learn to program, if you have analytics - look towards the Python language
  

Answer 2

DataGrip or its free equivalent