28 Apr 2021 LearnSQL.com Team Breaking With Filing Cabinets: The History of PostgreSQL This July, PostgreSQL turns 25. It has had an extensive influence on computing. Thanks to PostgreSQL, the world said “Goodbye!” to filing cabinets as the standard for storing and processing data. So, who created PostgreSQL, and how has it changed over the decades? There are quite a few PostgreSQL enthusiasts among my colleagues at LearnSQL.com. It is simply a great database solution. Why? It is free and open-source. So, you can use it for free, even for commercial uses. Read more 1 Apr 2021 LearnSQL.com Team New Monthly SQL Practice for April 2021! Are you ready to use SQL skills to write queries that resolve business problems? Give it a try in the new Monthly SQL Practice on LearnSQL.com. The April SQL Practice is for people with a basic level of SQL proficiency. You will test your SQL skills based on data about an apartment rental agency in Chicago, USA. If this is the first time you’ve come across our Monthly SQL Practices, you should know that LearnSQL. Read more 1 Mar 2021 LearnSQL.com Team New Monthly SQL Practice for March 2021! Are you ready to use your SQL skills to create reports and help resolve business problems? You can do this with our new SQL Practice on LearnSQL.com! The March SQL Practice is at an advanced level. You will test your SQL skills by creating reports with data about language courses in the U.S. If this is the first time you’ve come across our Monthly SQL Practices, LearnSQL.com offers one free SQL Practice each month (at the basic level in the even months and at the advanced level in the odd months). Read more 1 Mar 2021 LearnSQL.com Team Free SQL Course of the Month – Window Functions Are you looking for a good SQL window functions course? What if I told you that throughout March, you could access the best window functions course in the world for absolutely FREE? You read that right: you won't pay a dime! Hurry up! Time is running out! But wait – why is LearnSQL.com giving you a free SQL course? Well, we believe sometimes you just have to be good to others. Read more 2 Feb 2021 LearnSQL.com Team SQL Course of the Month – SQL JOINs If you want to really learn SQL, you can’t skip SQL JOINs. They are some of the most fundamental and commonly used features of the SQL language. That’s why SQL JOINs is our February SQL Course of the Month. What makes SQL JOINs so important? I asked Agnieszka Kozubek-Krycuń, Vertabelo's Chief Content Officer, about it. Here's what she said. Is it true that SQL JOINs are one of the foundations of SQL? Read more 1 Feb 2021 LearnSQL.com Team New Monthly Challenge for February 2021! Are you ready to solve business problems using SQL in 2021 with a new Challenge on LearnSQL.com? The February Challenge is at a basic level. You will test your SQL skills with data about a rental car company in the U.S. If it is the first time you’ve come across our Monthly Challenges, LearnSQL.com offers one free SQL Challenge each month: at the basic level in the even months and at the advanced level in the odd months. Read more 6 Jan 2021 LearnSQL.com Team Winter 2021 Track of the Season: Creating Database Structure New year, new challenges, and ... a new SQL Track of the Season! Start 2021 by learning SQL and data engineering. In this article, we answer frequently asked questions about our Creating Database Structure track. Maybe you haven't noticed yet that there’s an order to many LearnSQL.com courses; you can learn SQL by doing them in the right order. We call this option our ‘SQL tracks’. These are logically structured and well-thought-out learning paths that will help you take the next steps towards becoming an SQL expert. Read more 5 Jan 2021 LearnSQL.com Team SQL Course of the Month – Standard SQL Functions Are you dreaming of becoming a data analyst? Or maybe you just want to work effectively with your company’s databases? You can – with SQL functions. We’ve selected Standard SQL Functions to be our January 2021 SQL Course of the Month. What will you find inside? I asked Agnieszka Kozubek-Krycuń, Vertabelo's Chief Content Officer, about it. Here's what she said. What are SQL functions? The term reminds me of SELECT or JOIN. Read more 1 Jan 2021 LearnSQL.com Team New Monthly Challenge for January 2021! This month’s LearnSQL.com Monthly Challenge is now available! In January, you can test your SQL skills in window functions by solving problems for Jeremy, the manager of the clothing retailer, Edward. Is this the first time you’ve come across our Monthly Challenge? LearnSQL.com delivers one SQL Challenge each month to our users. Starting in January 2021, we have monthly challenges separately for beginners and for advanced users. Each challenge contains 5 to 10 SQL exercises, prepared for those who want to practice their skills. Read more 31 Dec 2020 LearnSQL.com Team Why Learn SQL This New Year? In answering this question, we’ll take a look at the idea behind New Year’s resolutions, explore what SQL is, and see why learning it should be your goal for 2021. We’ve all heard of New Year’s resolutions, and we all have personal experience of how difficult it can be to see them through to a successful conclusion. We’ll examine the history of New Year’s resolutions, why they often fail, and how to ensure your resolution for learning SQL in 2021 doesn’t meet with the same fate as so many others that never made it past the end of January. Read more «« « 1 2 3 … 6 7 8 … 10 » »»