![]() Most of the data is offered in the most popular file formats such as JSON or CSV.Ī website like this is great, not only for SQL practice but also for democracy and transparency from the authorities. In just a few clicks, you can access information about your city's budget or the average academic performance of students from your alma mater. The website offers a great search engine where you can define topics of interest, time intervals, tags, locations, and even the data file format or data type. It is a gigantic, and more importantly, completely open and free collection of over 200,000 data sets from the US Government. ![]() See for yourself: is what we write about on the blogs only an empty promise, or does the world really need people who know SQL? I’ll give you a hint-the trend is growing! 2. The possibilities are limited only by your imagination and courage in entering words into the Google Trends search engine.įor the first try, I recommend entering the phrase "Learn SQL" in Google Trends. You can import them into your program and view them using SQL. Be warned, though-looking through all of this is really addictive and time-consuming!Įach statement and each report can be conveniently downloaded with one click in the form of a CSV file. It is also worth checking out the possibilities of data visualization by Google. Google shows five search terms in several categories. By writing this article, I learned that most of the searches related to Taylor Swift in the last 30 days were from Utah. You can also click on any of the examples suggested by Google. the most popular terms currently searched on Google. Thanks to this feature, in a few minutes you can narrow down your search to, for example, specific locations, time, or nature of data.Īnother interesting feature is the list of trends, i.e. To keep all this under control, various filters and data breakdowns are available. Sounds like something from one of Orwell's books? Let me just add that you can analyze almost every possible search query, keyword, and their history since 2004. Google allows you to use its browser data and analyze what people are searching for and when they do it most often. The sheer volume of data from which you can choose is overwhelming! They can be compiled and analyzed practically freely. ![]() ![]() So why not use this for your SQL practice? Google Trends is one of the largest public data sets available. Every click, every query entered into the search engine, everything is tracked and saved. Instead, I want to share with you other interesting data sets and have selected seven free sources of databases that are great for practicing SQL. However, since they are so common today, I will not point to any specific one of those. There are tons of great databases that keep track of contagions and deaths. Databases on the spread of COVID-19 around the world should be at the top of my list. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |