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.
Flutter is a multi-platform framework built by Google and used to develop native applications for web, mobile and desktop from a single code base. Here we review key ideas, concepts and introduction Tutorials to Flutter.
The SOLID principles are used to improve code reusability and help to maintaining a clean software architecture. There are 5 principles that stablish a set of rules to design a well-organised software system.