SQL Exercises

As part of my SQL training and in order to know postres better I am (slowly) doing exercises from pgexercises.com page.

I like that page very much:

• it does not want my email address
• it does not require me being logged in
• it remembers my progress
• ine can solve many SQL-related mini-tasks in different categories (from simple selects to joins, data modifications, to aggregate functions)

Although database schema for those exercises is very simple, I’m struggling a bit when things get complicated…

I’ve just started reading: Anthony De Barros “Practical SQL: A Beginner Guide to Storytelling with Data”. All examples in the book are using Postgresql db system. Therefore I decided it’s time to instal postgres on my machine.

I want to take a closer look to postgresql itself, and during reading I want to play a bit with with different data sets. I need to recall how to use SQL. So this is my plan for October.

This is my first blog post in English. I’ve finally made a decision to start blogging in English.