Category: SQL for Power BI

Common SQL Table Expressions For Power BI Users

Common SQL Table Expressions For Power BI Users - Enterprise DNA

In this blog, we’ll discuss some common table expressions, also known as CTEs. If you encounter complex problems, using these SQL table expressions can help you. With CTE, you can break any task into small and manageable queries to solve complicated problems. Now let’s explore how CTE can make your work more efficient in troubleshooting

Continue reading

SQL Data Extraction Using OFFSET And FETCH

SQL Data Extraction Using OFFSET And FETCH - Enterprise DNA

In this blog, we’ll discuss OFFSET and FETCH. These two – when combined – are very powerful and can help us with our SQL data extraction tasks. We can use these two to extract data based on our requirements or needs. The purpose of OFFSET is to skip the first rows that you have mentioned

Continue reading

Basic SQL Table Operations

Basic SQL Table Operations - Enterprise DNA

In this tutorial, I’m going to show you how to perform the Basic SQL table operations which include creating and deleting tables. We’ll also discuss inserting, removing, and updating records in a table. In addition, we also use the term CRUD which stands for Create, Read, Update, and Delete for the basic table operations of

Continue reading

Common SQL Functions: An Overview

Common SQL Functions An Overview - Enterprise

In this tutorial, we’ll learn common functions that we can use in SQL. These functions can be a String or a Date. SQL functions are used for processing or manipulating data. Let’s first talk about the String functions. These are the SQL functions that we usually use for manipulating String characters or String values. Common

Continue reading

SQL WHERE Clause For Filtering Data

In this tutorial, we’ll discuss what the SQL WHERE clause is and how to use it. We’ll also talk about multiple conditions by using AND and OR operators.  The SQL WHERE clause is for filtering data or records. It’s used to create a condition to extract only the necessary records needed.  Aside from using the

Continue reading