SQL Server PIVOT Operator

Uncategorized

In SQL Server, PIVOT is a powerful operator to transpose table values in the rows format to table...
Read More

How to Connect and Manage MariaDB via MySQL WorkBench

MySQL, Tools & technologies

To use MySQL Workbench as a GUI for MariaDB? If you’re filled with disbelief right now, you’re not alone. Though Michael...
Read More

An Overview of SQL LIKE Statement and Its Use Cases

Uncategorized

SQL LIKE statement is used to search a similar phrase or pattern in a column. It supports ASCII and Unicode pattern matching. This...
Read More

SQL IN operator

Uncategorized

The SQL IN statement matches a specified value from a list or subquery. It reduces our efforts to...
Read More

Syntax of LINQ GroupBy Method in C#

SQL Server

We are continuing our series dedicated to LINQ technologies with a more detailed look at some methods available under the LINQ umbrella....
Read More

Different types of LINQ queries: Query Syntax and Method Syntax

Languages & Coding

The current article continues the series about LINQ. The previous part introduced the LINQ technologies and demonstrated its usage on some...
Read More

SQL Aggregate Functions: Easy Tips for Newbies

Database development, Statements

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

How to Build a Simple Data Warehouse in Azure – Part 2

Azure, Cloud, Microsoft Azure

This is the second part of the three-part article which aims to help both beginners and professionals in designing a simple but fully...
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

The Tutorial Guide to SQL Server DROP TABLE Statement

Database development, Statements

The SQL DROP statement is a command that deletes existing database components or the entire...
Read More
Close