An Overview of the SQL Variables Usage
The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle...
Getting Started with the SQL Server T-SQL CASE Expression Statement
SQL Server CASE expression is very useful in returning an output based on some conditional matching criteria. We can state multiple...
Spark SQL – the Most Important Tool for a Big Data Engineer
Understanding Spark SQL is extremely helpful for analyzing big data, especially when you’re working with the Spark platform. But what...
An Overview of PgAdmin Tool for Postgres
The PgAdmin is a popular tool for the open-source database – Postgres or PostgreSQL. It provides...
SQL Server JSON – Part 2
Introduction In the previous article, we covered the basics of JSON and showed how to use JSON in SQL Server, demonstrating these concepts...
JSON for SQL Server. Part 1
In the last few years, JSON has positioned itself as a standard data exchange format between services, although XML is still widely used....
XML Made Easy – LINQ to XML
LINQ to XML is an in-memory XML programming interface that enables XML manipulation. Similar to the...
Query JSON Data with SQL/JSON Functions & Autonomous Database
In the previous article, we worked on the Twitter Activity dataset in JSON format with the SQL Developer Web tool in Autonomous Database....
Introducing LINQ to Entities
When we think about querying databases, the first thing that pops to mind is usually some SQL query. Then other questions arise in regards...
An Overview of Analytic Functions in PostgreSQL
Analytic functions are special kinds of pre-built functions that come with PostgreSQL by default....