If you are a beginner or not so familiar with SQL, I want to point you to the PATSTAT SQL Self Study Course which has been updated recently. Starting from zero, it presents the most frequently used concepts of SQL. All examples are based on PATSTAT and can be directly copied&pasted into PATSTAT Online for immediate execution.
In addition, the current update contains some best practice on how to approach the task of writing queries; see slide 99 ff.
The Self Study Course can be downloaded from the PATSTAT Online web page: http://www.epo.org/searching-for-patent ... .html#tab3
Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
1 post • Page 1 of 1