Languages & Coding

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

PgAdmin GUI client for PostgreSQL: Comprehensive Overview

Code Management, Languages & Coding, PostgreSQL, Tools & technologies

The PgAdmin is a popular tool for the open-source database – Postgres or PostgreSQL. It provides various graphical user interfaces for...
Read More

LINQ to Entities – Tutorial with Examples

Basics of C#, Languages & Coding

When we think about querying databases, the first thing that pops to mind is usually some SQL...
Read More

An Overview of the SQL Variables Usage

Languages & Coding, SQL Server

The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle starts with declaration and ends with...
Read More

Getting Started with the SQL Server T-SQL CASE Expression Statement

T-SQL

SQL Server CASE expression is very useful in returning an output based on some conditional matching criteria. We can state multiple...
Read More

JSON in SQL Server: The Ultimate Guide to JSON Data Manipulation

JSON, Languages & Coding

In the last few years, JSON has positioned itself as a standard data exchange format between...
Read More

LINQ to XML: Easy Work in C#

ASP .NET CORE, Languages & Coding

LINQ to XML is an in-memory XML programming interface that enables XML manipulation. Similar to the more traditional Document Object Model...
Read More

Query JSON Data with SQL/JSON Functions & Autonomous Database

JSON, Languages & Coding

In the previous article, we worked on the Twitter Activity dataset in JSON format with the SQL Developer Web tool in Autonomous Database....
Read More

An Overview of Analytic Functions in PostgreSQL

Languages & Coding, PostgreSQL

Analytic functions are special kinds of pre-built functions that come with PostgreSQL by default....
Read More
Close