
SQL Joins, Group and Union
Overview of the SQL Join clauses: Inner, Left, Right and Full joins. How to join two or more database tables and how to group them using Group By. What are aggregate functions in SQL and how to Union multiple SQL queries.


Hey there and welcome!
This is the first page of the book. An introduction to these publications that collect information about software development, best practices and insights from the latest web technology.
In this site you will find some coding examples that are easy to copy and paste. I post them to help understand the context of a publication and because they come handy while I am writing code. There are thousands of websites that share code and this one is just another one of them.
I believe writing articles is one of the best way to learn. I am not an expert in most of the publications that I write on this website, but I find really helpful to research about a topic and write about it afterwards. I try to be as objective as possible while writing, but because I am human any opinion expressed on this site comes from a personal point of view.
Web technologies are rapidly evolving and they change very quickly. That is why it is important to keep publications up to date. If you find any outdated reference, feel free to contact me and I will be happy to update them.
Thank you for stopping by and see you around!

Overview of the SQL Join clauses: Inner, Left, Right and Full joins. How to join two or more database tables and how to group them using Group By. What are aggregate functions in SQL and how to Union multiple SQL queries.

Notes from a webinar presentation about the future of the energy sector. Insights of the digital transformation that the energy industry is currently involved in.

Canonical has released a new version of Ubuntu. This articles covers how to update to Ubuntu 21.04 - Hirsute Hippo and what are the new features of Ubuntu OS.