It is best to pre-design core scripts to query data and ask techspecs to do a form with password access, which can drop-down lists and checkboxes to make a selection of what I need, and having obtained the necessary data on the "Download" button to download them.If pressed:1.
To understand the principles of relational database (construction database based on relationships),
here now there is one main principle — 3 normal form, read:2.
Obviously to get a tool to access the database and to learn podklyuchaetsya to it3.
Learn how to do queries with SELECT, that is read-only:
- query from 1 table with different conditions
- query 2 or more tables with relationships to the terms, for example to choose all users with the name Andrew, and data for these users in other tables orders
- to learn how to upload a file ,to be downloaded for later use
- find the Converter for the driving of the SQL result to csv, here found this: www.convertcsv.com/sql-to-csv.htm, but maybe there are better
- or learn to program, if you have an Analytics view in the direction of Python