Microsoft SQL Server is a relational database management system that Microsoft has created. It is a database server, which is a software product whose principal
Apache Impala – Step by Step
Throughout the year, “Big Data & SQL” published a number of articles about Apache Impala. It covers the majority of its features and functions. It’s
HDFS Tutorial
Here are all of the HDFS articles that have been published on this website so far. It’s basically a collection of information organized in a
Apache Pig Tutorial
This page combines all Apache Pig related posts into a single to make it more helpful and beneficial to learners. It is presented in a
Apache Sqoop Course Contents
This page combines all Sqoop-related topics into a single article to make it more helpful and beneficial to learners. It is presented in a hierarchical
Apache Hive Course Contents
Apache Hive is built on top of Apache Hadoop, which is a distributed, fault-tolerant, and open source data warehouse platform for reading, writing, and handling
JOINS in SQL Server
A JOIN clause is used to combine rows from two or more tables, based on a related column between these tables. The purpose of JOINS
MySQL JSON_EXTRACT Examples
JSON_EXTRACT returns data from a JSON document, selected from the parts of the document matched by the path arguments. Returns NULL if any argument is
AWS RDS – Delete Option Group
Once an option group has been allocated to an instance, it cannot be deleted. The option group must be removed from all instances. When attempting
AWS RDS – Audit logs in Cloudwatch
When I first started utilizing AWS RDS, I ran into a slew of issues. Most of them are due to a lack of knowledge, and
How to bring the Database online from the Suspect Mode in SQL server
Is your SQL database marked as suspect? Learn how to bring the Database online from the Suspect Mode in SQL server with manual as well
Amazon RDS – Engine Types, Editions and Versions
Amazon Web Services (AWS) is the world’s most comprehensive and widely used cloud platform, with over 200 fully featured services available from data centres around
Big Data and SQL 