Common use cases of SQL SELECT Distinct
SQL Shack
by Haroon Ashraf
4d ago
This article talks about the commonly used scenarios of SQL Select Distinct in an easily understandable format equally suitable for beginners and professionals. The article also brings into light some of the data analysis performed based on the Distinct keyword. Additionally, the readers of the article are going to get hands-on experience in implementing the ..read more
Visit website
Top Power BI Interview Questions and Answers
SQL Shack
by Arindam Mondal
6d ago
Microsoft Power BI is a very popular data visualization tool. In this article, we will discuss the most frequently asked Power BI Interview Questions and Answers. What is Power BI? Power BI is a self-service Business Intelligence tool from Microsoft. It is a collection of software services, apps, and connectors that work together to transform ..read more
Visit website
SQL Practice: Common Questions and Answers for the final round interviews
SQL Shack
by Esat Erkec
1w ago
In this article, we are going to make a SQL practice exercise that will help to prepare for the final round of technical interviews of the SQL jobs. Introduction Technical interviews are an indispensable part of the recruiting process for employers. Employers want to assess the technical knowledge and ability of the candidate for the ..read more
Visit website
Introduction to SQL Escape
SQL Shack
by Rahul Mehta
1w ago
This article will provide an introduction to SQL escape characters for using special characters and their characteristics. Introduction In SQL Server, MySQL, and other databases, data is stored in huge amounts. Relatively, it is being processed using various ways. A few of the basics are using queries, procedures, functions, and more. SQL developers usually use ..read more
Visit website
Learn the PostgreSQL COALESCE command
SQL Shack
by Rajendra Gupta
2w ago
This article will make you learn the Postgres Coalesce command with examples. Introduction The coalesce function in PostgreSQL is beneficial when we want to ignore null values while processing data. As we all know, we can insert both null and non-null values into a PostgreSQL table. However, in many cases, we don’t want those null ..read more
Visit website
Learn SQL standard deviation function
SQL Shack
by Hadi Fadlallah
2w ago
This article will show the SQL standard deviation function with several examples. Mean, Range, Variance, and Standard deviation: A reminder Before explaining how to use the SQL standard deviation function, we will briefly introduce the need for this value in this section. Assuming that we have two sets, each representing the monthly salaries of employees ..read more
Visit website
Common SQL Interview Questions and Answers
SQL Shack
by Randheer Parmar
1M ago
If you are working on SQL programming or learning SQL or how to write queries and looking to test your knowledge or prepare for any SQL interview, the below article can help you. The objective of today’s article is to help you prepare for an Interview or test the knowledge you gain in your learning ..read more
Visit website
Overview of the SQL Median function
SQL Shack
by Gauri Mahajan
1M ago
In this article, we will learn how to implement the median functionality and wrap it into a SQL median function Introduction Calculations are an integral part of data analysis. Often business logic implemented in programmable database objects involves numerous calculations using a variety of mathematical formulae and operators. When it comes to calculations, statistics play ..read more
Visit website
SQL Subtract Dates with Examples
SQL Shack
by Arindam Mondal
1M ago
SQL Server provides various dates and time functions for different needs. In this article, we will focus on SQL subtract date functions with various examples. Introduction SQL Server has numerous built-in SQL date and time data type which includes time, date, smalldatetime, DateTime, datetime2, and datetimeoffset. SQL Server also provides a wide range of built-in ..read more
Visit website
5 Best Practices for writing SQL queries
SQL Shack
by Esat Erkec
1M ago
In this article, we are going to learn some best practices that help to write more efficient SQL queries. Introduction Queries are used to communicate with the databases and perform the database operations. Such as, we use the queries to update data on a database or retrieve data from the database. Because of these functions ..read more
Visit website

Follow SQL Shack on Feedspot

Continue with Google
OR