sql Archives - {coding}Sight

How to Get SQL Percentage Calculation as Easy as Pie

Edwin Sanchez — Thu, 14 Mar 2024 15:54:32 +0000

Percentage calculation in SQL can be a bit like traversing an unfamiliar labyrinth. If you’re a beginner, it’s easy to get lost in a maze of numbers and functions. You may stumble over pitfalls that can lead to incorrect results. But fear not because we’re about to make SQL percentage calculations as easy as pie! …

The post How to Get SQL Percentage Calculation as Easy as Pie appeared first on {coding}Sight.

SQL Aggregate Functions: Easy Tips for Newbies

Edwin Sanchez — Wed, 28 Sep 2022 07:59:00 +0000

SQL Aggregate Functions are functions that perform calculations and return a summarized result. With these, it’s easy to do these calculations on data sets: But there’s more. Statistical calculations like standard deviation and variance are also part of the tools. Mix it with grouping and sorting, and you’ll have something fantastic for your new report. So, …

The post SQL Aggregate Functions: Easy Tips for Newbies appeared first on {coding}Sight.

Tutorial Guide to Spark SQL: Great Tool for a Big Data Engineer

Philipp Zhenov — Thu, 22 Sep 2022 08:44:00 +0000

Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re working with the Spark platform. But what exactly is Spark SQL? What are spark data frames? How can you learn using it? Let’s take a look at its functions, capabilities, and, more importantly, the results it can provide for you. Table of …

The post Tutorial Guide to Spark SQL: Great Tool for a Big Data Engineer appeared first on {coding}Sight.

SUBSTRING Command in SQL: A Primer

Ian Fogelman — Tue, 15 Mar 2022 15:47:13 +0000

Similar to my article regarding the SQL Server STUFF command, today we will be examining the SUBSTRING SQL server command. It is similar to the STUFF command in regards to the parameters it accepts. In the vast landscape of data manipulation, one function that consistently proves its worth is the ‘SUBSTRING’ in SQL Server. As …

The post SUBSTRING Command in SQL: A Primer appeared first on {coding}Sight.

SQL Server Primary Key

Raja Jegan — Tue, 22 Feb 2022 14:20:47 +0000

Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the records present in a table uniquely. Hence, we should choose Primary Keys server carefully during the table design to improve the performance. In this article, we’ll learn what a Primary Key constraint is. Also, we’ll see how to …

The post SQL Server Primary Key appeared first on {coding}Sight.

NoSQL vs SQL: Which One is Better for Big Data Management?

Nahla Davies — Fri, 14 May 2021 07:55:10 +0000

Nowadays, customer behavior becomes more complex and market trends continue to shift rapidly. Thus, businesses need specialized technological systems to make sense of the mountains of data they generate. We’ve all seen devices that can connect over a shared network, algorithms that can predict future consumer behavior, and devices that can talk to you. Have …

The post NoSQL vs SQL: Which One is Better for Big Data Management? appeared first on {coding}Sight.

How to Use Array Functionality in SQL Server

Josip Saban — Mon, 26 Apr 2021 13:08:35 +0000

Have you ever been asked how to create array in SQL Server? Or, you might be asked how to how to store values in an array in SQL Server. Processing an array of values inside a procedure/ function is a common requirement. The question arises quite often, especially if you communicate with Oracle specialists. For …

The post How to Use Array Functionality in SQL Server appeared first on {coding}Sight.

Add Columns to an Existing Table in SQL Server Database

Kenneth Igiri — Tue, 01 Dec 2020 17:30:42 +0000

Introduction A table is a two-dimensional logical structure and the fundamental means of storing data in relational database management systems. Its ‘row and column’ format is very much like the organization of the spreadsheet. Each new record introduced to a table is a row (also called a record or tuple), while rows are grouped into …

The post Add Columns to an Existing Table in SQL Server Database appeared first on {coding}Sight.

Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners

Haroon Ashraf — Thu, 26 Nov 2020 13:35:52 +0000

This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values. Additionally, the readers will get hands-on experience by implementing some simple examples of this function. We’ll also highlight the importance of T-SQL functions in resolving database analytical problems. About the SQL COALESCE Function First, …

The post Handling the NULL Values Effectively with the SQL COALESCE Function for Beginners appeared first on {coding}Sight.

Using CASE Expressions in SQL Server

Kenneth Igiri — Wed, 18 Nov 2020 16:25:37 +0000

Introduction CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion or simple queries. Use cases for such commands are various. For instance, there is a column containing the department code, but you wish to display the department’s name rather than the code. You …

The post Using CASE Expressions in SQL Server appeared first on {coding}Sight.