Tag: sql

SQL Aggregate Functions: Easy Tips for Newbies

Database development, Statements

SQL Aggregate Functions are functions that perform calculations and return a summarized...
Read More

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

Frameworks, Languages & Coding

Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re working with the Spark platform. But what...
Read More

SUBSTRING Command in SQL: A Primer

SQL Server

Similar to my article regarding the SQL Server STUFF command, today we will be examining the SUBSTRING SQL server command. It is similar to...
Read More

SQL Server Primary Key

SQL Server

Across all major RDBMS products, Primary Key in SQL constraints has a vital role. They identify the...
Read More

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

Database administation, Work with data

Nowadays, customer behavior becomes more complex and market trends continue to shift rapidly. Thus, businesses need specialized...
Read More

How to Use Array Functionality in SQL Server

Database administation, Work with data

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....
Read More

Add Columns to an Existing Table in SQL Server Database

Database development, Tables

Introduction A table is a two-dimensional logical structure and the fundamental means of storing...
Read More

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

Database development, Statements, Tables

This article aims to help beginners understand the basics of the T-SQL COALESCE function and its application for handling NULL values....
Read More

Using CASE Expressions in SQL Server

Database development, Statements

Introduction CASE Expressions in SQL Server are used for the column values substitution to present the result sets in a particular fashion...
Read More

Welcome Back the T-SQL Debugger with SQL Complete – SQL Debugger

Tools & technologies, Utilities & Extensions

When you develop large chunks of T-SQL code with the help of the SQL Server Management Studio tool,...
Read More
Close