Best Online Courses for SQL Window Functions by Zahin Rahman 16 Dec 2020 In this article, I will summarize the top online tutorials and courses available on SQL window functions for enthusiasts of data analysis, data science, and data engineering. The information is here to help you embrace the topic with ease and feel comfortable using window functions in SQL databases. SQL window functions can help you solve some of the most common analysis challenges in business: What are the N most popular products for each month of the year? Read more Top 7 Online Courses for Data Engineers by Zahin Rahman 11 Nov 2020 This article summarizes the top online courses available for data engineers. We have picks suitable for beginners as well as intermediate learners. If you’re interested in database design and management, check these courses out! Most individuals who aspire to enter the realm of data aim for data scientist or data analyst roles. While these roles are indeed very rewarding because of their tangible links to customers and business direction, the role of data engineers is equally vital for businesses that operate in a data-rich environment. Read more SQL HAVING Tutorial by Zahin Rahman 14 Oct 2020 Learn how to use the SQL HAVING clause to filter groups using your own specified conditions. The SQL HAVING clause is often a challenging concept to grasp, especially for beginners. Additionally, its specific use cases can be difficult to visualize without specific examples based on real-world datasets. In this tutorial, you will learn how to apply the SQL HAVING clause to filter groups of records based on specified conditions. You’ll see examples where we apply this concept to solving business problems on a realistic dataset. Read more How to Find Duplicate Values in SQL by Zahin Rahman 2 Sep 2020 Duplicate records waste time, space, and money. Learn how to find and fix duplicate values using SQL’s GROUP BY and HAVING clauses. Database best practices usually dictate having unique constraints (such as the primary key) on a table to prevent the duplication of rows when data is extracted and consolidated. However, you may find yourself working on a dataset with duplicate rows. This could be because of human error, an application bug, or uncleaned data that’s been extracted and merged from external sources, among other things. Read more Using GROUP BY in SQL by Zahin Rahman 21 Jul 2020 Now that you know SQL’s core commands, power up your queries with the GROUP BY clause and aggregate functions. GROUP BY is a SQL clause that arranges data into groups based on a common value (or values). It is widely used to obtain summary information for large datasets as well as for computing basic aggregate statistics. Once you have grasped SQL’s basic commands like SELECT, WHERE, and JOIN, mastering the GROUP BY clause can help you implement your SQL knowledge in real-world business intelligence scenarios. Read more How to Learn SQL JOINs by Zahin Rahman 2 Jun 2020 JOINs are one of the most fundamental and commonly used SQL commands for manipulating and querying real-world data sets. They are also one of the more challenging SQL topics to master! In this article, you’ll learn an effective strategy to learn the different types of SQL JOINs. When data is stored in a single table, we can easily retrieve rows and get all the information we need. But when businesses scale, so does their data. Read more What is the Best SQL Training Online? by Zahin Rahman 10 Apr 2020 In today’s data-driven world, SQL is a highly sought-after skill, but it cannot be mastered merely over a fortnight. With so many resources at your disposal to learn SQL, where do you even consider beginning, and how do you practice SQL? Savvy and knowledgeable database professionals have consistently been in high demand over the last five years. If you are aiming to advance your career as a database developer, administrator, warehousing specialist, or analyst, SQL training and mastery is an absolute necessity. Read more The Top 7 Platforms with the Best SQL Courses for 2020 by Zahin Rahman 12 Mar 2020 Are you struggling to narrow down which platforms are the best for learning SQL online? We have all been there. I know how confusing it can be when choosing amongst the hundreds of resources available. Find out below which platforms offer the most enriching and seamless SQL learning experiences online. In this article, I will review the platforms with the best online SQL courses offered this year. Whether you are a student looking for your first job, a professional hoping to transition to a data analysis, or an experienced data practitioner, there are plenty of great opportunities to learn SQL online at various levels of technical ability. Read more