8 Mar 2022 Himanshu Kathuria What Is the OUTER JOIN in SQL? Even if you are new to SQL, you must have come across the term OUTER JOIN. In this article, I will explain what OUTER JOIN in SQL does. I’ll use some practical examples to demonstrate how it is used in day-to-day SQL applications. If you want to use SQL for practical purposes, learning the different JOINs is extremely important. In fact, you will be using a JOIN in just about every second query you write. Read more 8 Feb 2022 Himanshu Kathuria What Is the Future of the Data Engineer? If you are wondering about the future of data engineering as a career and whether it is worth becoming a data engineer, then this article is for you. Here, I cover how lucrative the prospects are for data engineering and how you can get started and thrive in the domain. “Data” is probably one of the most used terms in our everyday business language today. A data engineer plays a pivotal role in developing the infrastructure required for data-related actions. Read more 11 Jan 2022 Himanshu Kathuria The Most Popular Databases for 2022 With the number of database products increasing with each passing year, it is important to understand which database best fits your use case. This article lists the top-ranking databases available in the market today. When something that first became popular in the early 1980s is not slowly fading away but is still evolving and becoming more relevant, you know it had to be an important invention. The database is no exception. Read more 9 Nov 2021 Himanshu Kathuria How to Write a WHERE Clause in SQL We explain how to use the SQL WHERE clause with practical examples. If you have just started learning SQL and want to know how to retrieve or work with only a specific portion of the data stored in your tables, then this article is for you! The SQL WHERE clause is something you must master if you wish to use SQL for working with data. It is arguably one of the most basic and must-learn constructs of SQL. Read more 21 Oct 2021 Himanshu Kathuria The SQL Count Function Explained With 7 Examples One of the most useful aggregate functions in SQL is the COUNT() function. If you are new to SQL and want to learn about the various ways to use the COUNT() function with some practical examples, this article is for you. The COUNT() function is one of the most useful aggregate functions in SQL. Counting the total number of orders by a customer in the last few days, the number of unique visitors who bought a museum ticket, or the number of employees in a department, can all be done using the COUNT() function. Read more 23 Sep 2021 Himanshu Kathuria Who Has the Highest Salary, Department-wise? Use SQL to Find Out! This article shows how to get the total salary by department for an organization, using the GROUP BY functionality of SQL. We explain the SQL GROUP BY clause in detail along with conditional filtering using a HAVING clause. Understanding the salary outlay for an organization is one of the common starting points for business leaders. It helps them see who in the organization has the highest total salary cost, department-wise. Read more 15 Sep 2021 Himanshu Kathuria Top 10 Tools for Business Analytics Business Analytics is one of today’s hottest career fields. However, success as a business analyst requires that you learn the right skills and software programs. Let’s see what tools you should know if you want to be a business analyst. With the world generating immense amounts of data – and having systems in place to capture and manipulate that data to fuel business growth – job opportunities for business analysts are only going to grow. Read more 19 Aug 2021 Himanshu Kathuria The SQL AVG() Function Explained With Examples We explain the SQL AVG() function with practical examples, covering how and where you can and cannot use it. The average is probably one of the most widely used metrics to describe some characteristics of a group. It is so versatile and useful that it can describe something about almost anything. If you like sports, you see things like average runs per game in baseball, average assists per game or per season in basketball, and so on. Read more 17 Aug 2021 Himanshu Kathuria How to Use CASE in SQL If you need to evaluate multiple conditional statements, the SQL CASE statement will do the job. Here’s what you need to know to use CASE like a pro. Why is CASE so important in SQL? If you’re analyzing or manipulating data, you’ll often want to define rules based on certain conditions, e.g. if an employee’s performance is above average, give them a 10% raise; if it is outstanding, give them a 15% raise; otherwise, give them a 5% raise. Read more 30 Jul 2021 Himanshu Kathuria New to Data Engineering? Don't Make These Mistakes It's best to learn from the mistakes of others. This advice also works for data engineering. In this article, you'll find tips to help you advance your career and avoid common data engineering mistakes. The data revolution has produced tremendous opportunities and created various high-paying jobs related to the collection, maintenance, and manipulation of data. Data engineering is one of the most lucrative and interesting jobs of this family. Read more «« « 1 2 3 » »»