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 26 Dec 2023 Tihomir Babic SQL Query Practice: 20 Exercises for Beginners These 20 exercises are just what beginners need for SQL query practice. Try to solve each of them, and then look at the solutions. If something needs to be clarified, there are explanations for each solution. In this article, there’ll be less talking than usual. Instead, you’re going to write the answers to SQL practice exercises. (Don’t worry; we’ve included the solutions if you get stuck.) The whole point is to give you, as a beginner, plenty of opportunities for SQL query practice. Read more 28 Nov 2023 Tihomir Babic What Are SQL Window Functions? Need to up your data analysis game? Learn these SQL window functions here and you’ll take your analysis skills to the next level. Practice exercises and detailed explanations included! When I first heard about SQL window functions, I thought it was some strange marriage between SQL and Windows. I was wrong. The SQL window functions have nothing to do with that famous operating system. They are SQL functions that do computations on the set of rows related to the current row. Read more 19 Oct 2023 Tihomir Babic Top 29 SQL Server Interview Questions Looking for an SQL Server job? Review these 29 must-know SQL Server interview questions and you’ll be well-prepared. And don’t worry about looking up the answers – we provide them, too! Microsoft SQL Server's first version was released in 1989 and has a rich history. It has come a long way since then, becoming one of the most used database engines in the data industry. In the last ten years, it’s been the third most popular database engine. Read more 21 Sep 2023 Tihomir Babic What Is FULL JOIN in SQL? An Explanation with 4 Examples What is FULL JOIN – one of the often neglected SQL join types? In this article, we’ll show you how useful FULL JOIN can be and teach you how to apply it to different scenarios. The four examples cover some of the typical uses. An SQL join is a construction for combining data from two or more tables. FULL JOIN is one of the types of joins. You’ll get the most from this article if you’re already familiar with SQL joins and how they work. Read more 5 Sep 2023 Tihomir Babic SQL Joins: 12 Practice Questions with Detailed Answers In this article, we dig into our SQL JOINS course and give you 12 join exercises to solve. But don’t worry – all the exercises have solutions and explanations. If you get stuck, help is there! This is, after all, made for practicing and learning. SQL joins can be tricky. It’s not just the syntax, but also knowing what joins to use in what scenarios. Joins are used when combining data from two or more tables in SQL. Read more 17 Aug 2023 Tihomir Babic 20 Basic SQL Query Examples for Beginners These 20 basic queries are a must in a starter pack for every SQL beginner. These examples will get you going on your journey to mastering SQL. You’ve set your mind on learning SQL, googled ‘basic sql query examples’ or something similar, and here you are staring at this article. Now what? All learning starts with the basics, so let’s start with the most basic question: What Is SQL? Read more 25 Jul 2023 Tihomir Babic Using GROUP BY and ORDER BY Together: A Guide Untangling how to use two basic SQL clauses – GROUP BY and ORDER BY – in one query. GROUP BY and ORDER BY are basic SQL clauses. As such, they are taught relatively early in the learning process. And they usually don’t present a big hurdle to beginners. However, using GROUP BY and ORDER BY together can be confusing. By the end of this article, your confusion on this subject will go away. Read more 20 Jul 2023 Tihomir Babic A Complete Guide to Working With Substrings in SQL In this article, we’ll discuss how to work with substrings in SQL. It involves learning several approaches, so we’ll show you their ins and outs. To work with substrings in SQL, we first need to know what a string is. In programming, a string is any kind of textual data (a title, a description, a name). A string consists of any number and type of characters. In a SQL database, strings are typically stored as CHAR or VARCHAR data types. Read more 20 Jun 2023 Tihomir Babic What Is a LEFT OUTER JOIN in SQL? 4 Practical Examples Today’s article will discuss the LEFT OUTER JOIN in SQL. We’ll go through several examples of typical LEFT OUTER JOIN usage and compare it with INNER JOIN. A JOIN is an SQL feature that allows you to combine data from two or more tables. The nature of relational databases makes JOIN one of the most commonly used features in SQL. There are many different types of JOINs. We’ll focus on LEFT OUTER JOIN here. Read more «« « 1 2 3 … 9 » »»