This blog covers some of the concepts as well as applications of the SQL queries and clauses. I will keep on updating the blog as and when I get more time or I learn newer concepts. SELECT — The result of a SELECT statement is another table known as result…

This blog covers the order of execution of various SQL queries. SQL is a non-procedural language. This means that unlike other procedural languages, we do not write steps to be performed to achieve a desired functionality. …

This blog covers the common data types in SQL and their useful properties. Please note that this is not an exhaustive list and is meant to be a quick reference for most frequently used data types. Numeric: INTEGER (4 bytes), SMALLINT (2 bytes), BIGINT (8 bytes), FLOAT [(n)], MONEY (8…

The databases which store data as tables related to each other by some attribute(s) are called Relational Databases. The rows and columns of the table in which data resides are not in any particular order. SQL Server, MySQL are examples of RDBMSs, i.e., Relational Database Management Systems. SQL is a…

Normalization is a process of removing redundancies from the data. Sometimes, more than one columns in a table are functionally dependent on one another. In other words, it is possible to deduce the values in one column by knowing the values in the other. …

I am an aspiring data analyst and an engineering graduate in Electrical Engineering. I am skilled in Python programming and I have completed Google Data Analytics Specialization certificate on Coursera as well. So, why I am writing this blog? To serve two purposes: — To be able to document my…