There are many GUI tools to connect to MongoDB databases and browse but sometimes you need to get to the command line. That moment when something has gone wrong on the database server, and you need to SSH 4-levels deep in order to debug a problem with a database can leave you stuck. In this cheat sheet you can get a quick refresher...

MongoDB is a popular open-source NoSQL database management system that falls under the category of a document-oriented database. It was developed by MongoDB Inc. and is designed to provide high performance, scalability, and flexibility for handling large amounts of data. MongoDB stores data in flexible, JSON-like BSON (Binary JSON) documents,...

RDBMS Relational Database Management System is the most famous among the Database, we are calling this as relational Database meaning is there is a relationship between the data stored in the database Relational Database Management System (RDBMS) is an advanced version of a DBMS system. It came into existence during the 1970s. RDBMS system...

What is Apache Cassandra? Apache Cassandra is a distributed open source database that can be referred to as a “NoSQL database” or a “wide column store.” Cassandra was originally developed at Facebook to power its “Inbox” feature and was released as an open source project in 2008. Cassandra is designed to handle “big data”...

What is Data Manipulation? A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. Read-only selecting of data...

The SQL Server DBA advertise is relied upon to develop to more than $5 billion by 2020, from just $180 million, as per SQL Server DBA industry gauges. In this way, despite everything you have the chance to push forward in your vocation in SQL Server DBA Development. GangBoard offers Advanced SQL Server DBA Interview Questions and answers that...

This article will provide an overview of the SQL Join and cover all of the SQL join types including inner, self, cross and outer. For inner joins we’ll be discussing Equi and Theta joins. The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL Server, this is...

Cassandra and MongoDB are both “NoSQL” databases, but the reality is that they are very different. They have very different strengths and value propositions – so any comparison has to be a nuanced one. Let’s start with initial requirements… Neither of these databases replaces RDBMS, nor are they “ACID” databases. So If you have a...

What is SQL? As you all might be aware of the term SQL, stands for the Structured Query Language. SQL is an ASI standard language but there are many different versions of this language. SQL is the standard language for Relational Database System. It helps you in accessing and manipulating databases. Several queries against the database can be...