SQL Shack
1000 FOLLOWERS
SQL Shack is a new SQL server blog with articles about database auditing, server performance, data recovery and more. Share SQL knowledge, help you learn about SQL and communicate with people from SQL world.
SQL Shack
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
SQL Shack
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
SQL Shack
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
SQL Shack
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
SQL Shack
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
SQL Shack
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
SQL Shack
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
SQL Shack
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
SQL Shack
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
SQL Shack
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