Database noob asking for a flying start from the pro's

[Draconin]

I want to be able to pull the data out of the historical Betfair results on a bigger scale then using the Excel sheet.

My goal is to buy one month of advanced data, put that in the database and be able to pull all winning horses of all races out and find odd data.
I, for instance, don't want to download 1k races and put them all in an excel file race by race, that will take ages. Stats like prematch and inplay odds are very important for me, the advanced package should be enough right?

1. What coding language do I need to learn? I have some basic knowledge of Python. But I probably need to learn JSON, but I don't know for sure?
2. Can someone advise me on any of the tools from other users here, which are good for my goal?
3. I only bet on the IRE and UK market, can I also use data sets from other countries? They are probably not the same due to lower liquidity right?
4. Any other tips that you believe that will come in handy are welcome

Thanks in advance

[LetsGo]

What database are you using?
I use Microsoft SQL Server and filter the data using grouping and views before loading it into excel.

[bfexplorer]

I did it this way:

http://bfexplorer.net/Articles/Content/302

that is the app using historical data and analysing them.

Here is my database app for horse racing, yes ms sql server:

http://bfexplorer.net/Articles/Content/257

and here is simple bot to save only data to ms sql database:

http://bfexplorer.net/Articles/Content/234

[Draconin]

What database are you using?
I use Microsoft SQL Server and filter the data using grouping and views before loading it into excel.

I'm currently not using any database as I did not know which one to choose, seems like it will be an M SQL one
Thanks for your answer!

[Draconin]

I did it this way:

http://bfexplorer.net/Articles/Content/302

that is the app using historical data and analysing them.

Here is my database app for horse racing, yes ms sql server:

http://bfexplorer.net/Articles/Content/257

and here is simple bot to save only data to ms sql database:

http://bfexplorer.net/Articles/Content/234

Thank you for the elaborate answer!
So with that tool I will be able to see historical data and also create a bot to bet the exchanges with automatically?
Can I at least for now just use the tool for historical data and then use the free version of the tool or is historical data also subscription-based after the trial period?

[bfexplorer]

Thank you for the elaborate answer!
So with that tool I will be able to see historical data and also create a bot to bet the exchanges with automatically?
Can I at least for now just use the tool for historical data and then use the free version of the tool or is historical data also subscription-based after the trial period?

You have got access for free, in trial period to the both: bfexplorer app, and bfexplorer bot sdk. All tools, apps presented on my blog:

http://bfexplorer.net/User/Articles?userId=1

I developed using the same bfexplorer bot sdk, you have got access to:

http://bfexplorer.net/Products/BfexplorerBotSDK

https://github.com/StefanBelo/Bfexplorer-BOT-SDK

so what you do with that all depends only on your skills, and work.

[LetsGo]

The best way when you are starting is to use the API sample code.
Most updated code is in c#

https://docs.developer.betfair.com/d...ni/Sample+Code