SQL Course of the Month: PostGIS

2 Jul 2020 It's summer, and it's travel time ... at least it would be under normal conditions. The pandemic is still going on, but that doesn't stop us from dreaming about distant trips and visits to beautiful places. For now, most of us will have to do it on a map. Did you know that databases can store geographical data? With interactive maps, if you find a nice summer house on the internet, you can accurately track it and plan the best route there.

SQL Course of the Month - SQL Practice Set

5 Jun 2020 It is said that practice makes perfect. I agree with this statement one hundred percent. What is applicable in basketball training, playing an instrument, or learning a foreign language is also useful in learning SQL. Practicing writing queries, using functions, and putting together clauses is the basis for learning the true power of SQL. But how and where do you practice SQL? I spoke with Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo about this.

SQL Course of the Month - Creating Basic SQL Reports

20 May 2020 In May, we chose Creating Basic SQL Reports as our course of the month. Why? Because the basis of every successful business is making the right decisions based on proven data and good SQL reports. I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, about this. She knows SQL better than just about anyone and is probably the best person to talk about SQL Reporting. What does it mean to create SQL reports?

SQL Course of the Month - Window Functions

29 Apr 2020 Spring has come. It is nicer outside. It's a great time to learn something new. Which course should you choose? In April, it's worth it to bet on SQL window functions. What are they, what are they used for, and why are they worth knowing? I asked Agnieszka Kozubek-Krycuń, Chief Content Officer at Vertabelo, these questions. She has a PhD in mathematics and over 10 years’ experience teaching mathematics and computer science at the University of Warsaw.