How to analyse big data.

I study analyse big data, because excel is limited 100 millions line.I am interested in SQL programming languages,can expand kinds of software, such as My SQL, Access and a part of Big query.In addition, I want to make open data link station. For example, I have assignments that analysis have between the population and sales data. In this case, I must look for data source and download them. Every time, I repeat these transaction, I spend waste of time, so I want to set up auto control system.