17 Sep 2020 Tihomir Babic How to Use 2 CTEs in a Single SQL Query Have you ever wondered how to use multiple CTEs in one SQL query? Read this article and find out about recursive CTEs. After learning common table expressions or CTEs, a natural question is “Can I use several CTEs in one query?” Yes, you can! And you can do it quite easily, especially if you already have some basic knowledge of CTEs. Whether you know a bit about CTEs or you’re entirely new to the CTE world, reading about what a CTE is is always a good start. Read more 25 Aug 2020 Tihomir Babic How to Calculate the Length of a Series with SQL What is a time series and why bother to calculate its length using SQL? How do we calculate the length of a series in SQL? I can answer that in two words: window functions! Yes, you’ll need some knowledge of SQL window functions to calculate series length. But what is a time series, and why would you want to find out how long it is? What Is a Series? Read more 5 Aug 2020 Tihomir Babic Who Should Learn SQL Window Functions? Do you want to learn how SQL window functions can help you at your job? This article will show you examples from various business applications where they can be very useful. I won’t be explaining what SQL window functions are in this article, but rather how to use them. If you’re not familiar with window functions or their syntax, don’t worry. Here’s an article that can help you with an introduction to SQL window functions. Read more 16 Jul 2020 Tihomir Babic When Should I Use a Common Table Expression (CTE)? Interested in hearing more about common table expressions or CTEs? Would you like to know when CTEs are useful? Read on—we’ll discuss in this article. If you’ve heard of common table expressions, you’ve probably wondered what they do. Even if you have not, it’s good that you’re here! CTEs can be very useful, especially if you have already mastered the basics of SQL, such as selecting, ordering, filtering data, and joining tables. Read more 16 Jun 2020 Tihomir Babic How to Practice SQL Window Functions at Home Are you looking for a way to maintain your knowledge of SQL window functions? What’s the best way to practice them at home? Here are some suggestions. Learning something new feels great, but it’s also arguably the easiest part of gaining knowledge. You’ve probably experienced that yourself. You struggle with learning an idea, and then you finally get it! There’s the feeling you’ve learned something. And then, very soon, you practically have to start all over again with the very same concepts. Read more 27 May 2020 Tihomir Babic 5 Advanced SQL Constructions Every Data Analyst Should Learn Does your job involve data analysis? Here are five examples of how advanced SQL can help you in your daily work. I’m a data analyst and I have to say – data analysts can be quite strange. Other people are usually afraid of immense amounts of data; we enjoy it. The deeper we get into data, the happier we are. An important tool for getting into data (and thus being a happier data analyst) is SQL. Read more 13 May 2020 Tihomir Babic 11 Advanced SQL Interview Questions (and Answers) Do you want to move to a job that uses SQL? Are you unsure about what to expect during the job interview or how to benchmark your knowledge? This article will give you a good idea of where you stand. If you feel stuck in your job, you’re not the only one. The modern division of work pushes people to perform very specific tasks, expecting them not to look at what's on the other side. Read more 22 Apr 2020 Tihomir Babic When Do I Use SQL Window Functions? Have you heard one of your colleagues bragging about using SQL window functions? Do you know basic SQL but not much, or anything, about window functions? If you want to learn about window functions and how to use them in a business context, you’re in the right place! This happens often. You reach a certain level of knowledge, and you feel like the king (or queen) of the world. Read more 5 Mar 2020 Tihomir Babic Best Online SQL Courses for Finance & Economics Majors Are you studying finance and wondering how you can use your knowledge in this technical world? Maybe you’ve just started working as a data analyst and you want to bring new tools and skills to your workplace? This article could help you with the list of the SQL courses worth trying. Maybe you’re studying finance and find your studies too theoretical. How will you put this knowledge into practice? Read more 20 Feb 2020 Tihomir Babic 8 Common Entry Level SQL Developer Interview Questions Have you ever been interviewed for an entry-level SQL position? Are you planning to apply for such a job? This article will help you to know what to expect and prepare for common SQL developer interview questions. After gaining some basic knowledge of SQL and programming, you're probably wondering what to do next. Or maybe you're not wondering! You know that what you've learned will soon disappear if you don't use it regularly. Read more «« « 1 2 3 … 7 8 9 » »»