17 Oct 2024 Tihomir Babic The ORDER BY Clause in SQL Window Functions In this article, you’ll get an overview of ORDER BY in window functions. You’ll learn how it compares to PARTITION BY and the regular ORDER BY all accompanied by examples and explanations. If you want to create reports that go beyond simple aggregations, you’ll need SQL window functions. Window functions help you create rankings, compute running totals and moving averages, and find the difference between rows. To use window functions effectively, you must understand the role of the ORDER BY clause. Read more 26 Sep 2024 Tihomir Babic SQL Interview Cheat Sheet Need to quickly reference all the fundamental knowledge for an SQL interview? Want to refresh your memory about an SQL concept? Our SQL Interview Cheat Sheet is your new best friend! Preparing for an SQL interview requires brushing up on your SQL. But it’s very easy to get lost in all the SQL concepts you must review. In such situations, you need an easily browsable resource packed with SQL knowledge. Read more 19 Sep 2024 Tihomir Babic SQL Basics: The Complete Resource List If you want to work with data, you have to start by learning the SQL basics! In this article, you’ll get an overview of core SQL concepts and syntax. Plus, we include links to great resources if you want to learn more! Structured Query Language, or SQL, is a programming language that first appeared in 1974. It is designed for managing data in relational databases, which means storing, changing, deleting, and querying the data inside the database. Read more 18 Jul 2024 Tihomir Babic SQL Project for Portfolio: Northwind Store SQL portfolio projects are an important part of a data analyst’s education. How do you start a project, and where do you go with the insights you discover? We’ll use the Northwind store database to answer this. Doing a solid SQL project is an essential element of any data analyst’s learning process. An SQL project is a great tool for learning, as it makes you use SQL on a real-world dataset. Read more 20 Jun 2024 Tihomir Babic SQL for Financial Reporting SQL should be part of every modern financial reporting process. It can deal with gigabytes of data and perform financial calculations in a split second. It’s time to transition from Abacus (also known as Excel!) and start using SQL in financial reporting. Data has taken a central part in business decision making. This applies even more to financial data. The main goal of businesses is to make a profit, so it’s no wonder that financial data plays a crucial role in the strategic decision-making process of any modern business. Read more 21 May 2024 Tihomir Babic SQL Window Functions Guide Every data analyst can benefit from knowing SQL window functions. They up your data analysis game and open doors to analyzing data on an entirely new level. This article is your starting point for the world of SQL window functions. SQL window functions allow you to show all the data rows and their aggregate values at the same time. Sounds a bit like GROUP BY on steroids, doesn’t it? Read more 18 Apr 2024 Tihomir Babic GROUP BY and Aggregate Functions: A Complete Overview Updated: October 29, 2024 SQL’s GROUP BY and aggregate functions are essential in data aggregation – and for analyzing data and creating reports. Let’s explore them together! In SQL, GROUP BY and aggregate functions are one of the language’s most popular features. Data aggregation is critical for data analysis and reporting; to make sense of all the data in a dataset, it often needs to be aggregated. But what is data aggregation? Read more 21 Mar 2024 Tihomir Babic 15 Tricky SQL Interview Questions for Experienced Users SQL interview questions for experienced users usually contain some trick(y) questions. Interviewers use them to test your gumption, which is typically a result of extensive experience and a high level of SQL knowledge. I will show you 15 tricky SQL interview questions (mostly coding) in this article. Mind you, these are not necessarily complex questions. Actually, that’s their main characteristic: they seem very easy and straightforward, but that’s the interviewer trying to deceive you. Read more 8 Feb 2024 Tihomir Babic 9 Practical Examples of SQL LEFT JOIN Updated on: October 28, 2024 LEFT JOIN is one of SQL's most common JOINs. Make sure you know all its ins and outs by going through all nine of our real-life LEFT JOIN examples. LEFT JOIN – alongside INNER JOIN – is one of the essential SQL tools you need to work with data from two or more tables. But how and when should you use it? These nine LEFT JOIN examples will point the way. Read more 30 Jan 2024 Tihomir Babic SQL Server Date Functions: A Data Analysis Guide Date functions are the bread and butter of data analysis and reporting with SQL Server. In this guide, I will show you practical examples of the use of SQL Server date functions and how to apply them to your reports. A question for all data analysts: Do you want to be taken seriously? I’m sure you do. In that case, knowing SQL Server date functions is mandatory. Date and time data types are ubiquitous in databases, as they are essential for reporting. Read more «« « 1 2 3 … 9 » »»