Why is a naming convention required in SQL? The short answer is READABILITY. A naming convention is a set of rules that you decide on
Category: MySQL
Aliases in SQL
In this post, we’ll go over aliases in SQL Server. The following are some key points about Aliases. In SQL Server, aliases can be used
MySQL UPDATE JOIN with Aggregate Function in SET
When relational model tables are normalized, as was discussed in a previous post, it may be necessary to join them to obtain the correct records
MySQL UPDATE with JOIN
When tables in a relational model are normalized, it may be necessary to join them in order to fetch the required records or update the
Adding multiple columns in between columns – MySQL
When working with several RDBMSs, even minor changes in syntax can cause difficulties. This is the first in a series of postings about how to
Adding multiple columns in a table – MySQL
When you engage with several RDBMSs, even a small amount of change in syntax can cause confusion. This is the first in a series of
Big Data & SQL 