Updated SQL Self Study Course for PATSTAT

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.
Post Reply

mkracker
Posts: 120
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Updated SQL Self Study Course for PATSTAT

Post by mkracker » Wed May 11, 2016 3:33 pm

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
-------------------------------------------
Martin Kracker / EPO


Post Reply