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...
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 result. With these, it’s easy to do these...
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...
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 databases with all their data permanently....
Read More

How to use Oracle Advanced Analytics: Tutorial Guide

Business intelligence, Oracle BI

Advanced Analytics is a mandatory trend for Business Intelligence platforms and Self-service...
Read More

What is AWS IAM: Tutorial Guide and Features Overview

AWS, Cloud

In this article, we are going to explore the Identity and Access Management concepts available in Amazon Web Services. Abbreviated as IAM,...
Read More

How to Change Default MySQL Port in Windows 10

MySQL

A network port is a communication endpoint used by applications, incoming connections, and external devices to the computer/server or...
Read More

How to Download, Install and Restore AdventureWorks Database in SQL Server

Database administration

Sometimes, we need a sample database that has all the required objects along with a large set of...
Read More
Close