Databases & DBA
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. Here you may find Databases & DBA related articles and news.

RECENT POSTS

  • Mahesh Chand

    What is a Hierarchical Database

    Hierarchical databases represent data in a tree-like structure. In this article, we'll learn basics of hierarchical database management systems and how data is represented and stored in a hiera...
    Mahesh Chand Jul 26, 2019
  • Mahesh Chand

    What Is A Column Store Database

    Column Store Databases store the data in columns rather than rows. In this article, let's understand what column databases are and what are the most popular column store DBMS.
    Mahesh Chand Jul 23, 2019
  • Mahesh Chand

    What is a Graph Database

    Big data, semantic searches, and real-time responses are the reason behind the growing demand for graph databases. This article talks about what a graph database is, why graph databases are popular...
    Mahesh Chand Jul 22, 2019
  • Mahesh Chand

    What are the Most Popular Relational Databases

    Relational database management systems are the most popular form of database management systems (DBMS) that includes Oracle, SQL Server, MySQL, and DB2. This article lists the most popular RDBMSs i...
    Mahesh Chand Jul 13, 2019
  • Nirav Gandhi

    Installing SQL Server On Linux In Azure

    In this video, let us learn to create Azure Virtual Machine (Linux) and install SQL Server on it.
    Nirav Gandhi Jul 10, 2019
  • C# Curator

    Most Popular Graph Databases

    Graph databases, or Graph DBMS, are growing in popularity. Neo4j is the most popular graph database. This article lists the most popular graph databases.
    C# Curator Jul 10, 2019
  • Kuldeep Singh

    GitLab Ends MySQL Support With 12.1 Release

    GitLab ends MySQL support with release 12.1 as it slows down Gitlab and poses a number of limitations.
    Kuldeep Singh Jul 04, 2019
  • Arjun Panwar

    String Functions in MySQL

    In this article, learn how to use MySQL string functions.
    Arjun Panwar May 28, 2019
  • Kuldeep Singh

    PostgreSQL 12 Beta 1 Available Now

    First beta release of PostgreSQL 12 is now available.
    Kuldeep Singh May 26, 2019
  • Arjun Panwar

    How to Handle Null Values in MYSQL Server

    Here we will learn how to handle null values and null values functions in MySQL.
    Arjun Panwar May 16, 2019
  • Kuldeep Singh

    Redis Changes Its Licensing Model

    Redis Labs has announced Redis Source Available License (RSAL) to communicate its terms more clearly with the open source and developer communities.
    Kuldeep Singh Feb 22, 2019
  • Ganeshan N

    Overview Of SQLite

    In this article, I will show you how to use SQLite in Android Studio to create the Android database. SQLite is an open source project and an embedded relational database engine which is used to man...
    Ganeshan N Jan 15, 2019
  • Sourav Mukherjee

    What Are The Advantages And Usage Of Apache Cassandra Database

    This article reviews basics of Apache Cassandra and its advantages and usages. Apache Cassandra is the easiest truly big-data database that can scale and replicate data globally in a master-less co...
    Sourav Mukherjee Dec 21, 2018
  • Sourav Mukherjee

    Are The DBAs Paranoid By Nature

    With respect to the job functions of Database Administrators, the term “paranoid” does not necessarily imply that they are under an extreme state of paranoia; however, perhaps in their zealous effo...
    Sourav Mukherjee Dec 17, 2018
  • Dinesh Gabhane

    PostgreSQL - Some Basics

    There are many differences in the syntaxes of PostgreSQL and other database queries. Mentioned are some commonly used ones.
    Dinesh Gabhane Dec 12, 2018
  • Jinal Shah

    Find Methods, Operators, And Filters In MongoDB

    In this video of MongoDB Series, I will show how to import JSON data to a MongoDB Database (Collection) and perform some operations with find and findOne methods. Also, we will see some queries wit...
    Jinal Shah Dec 03, 2018
  • Jinal Shah

    How To Install MongoDB Locally And Perform CRUD Operations (Basic-Query)

    This video explains how to perform basic CRUD operation on MongoDB using MongoShell. We will learn the functionality and usage of find, insertOne, insertMany, deleteOne, deleteMany, updateOne,updat...
    Jinal Shah Dec 01, 2018
  • Anoop Kumar Sharma

    DataTypes In MongoDB

    In this article, we will learn about the Datatypes and its usage in the MongoDB. As we already know, MongoDB stores data in BSON format. BSON stands for the Binary-encoded format of JSON. Using BSO...
    Anoop Kumar Sharma Nov 26, 2018
  • Herve Roggero

    Creating Your First MongoDB Atlas Cluster

    MongoDB Atlas is an online no-sql database that allows you to run a MongoDB database as a service. Running MongoDB as a service means that you no longer need to host your own servers or manage upgr...
    Herve Roggero Nov 20, 2018
  • Sanwar Ranwa

    MongoDB Database Backup And Restore

    Open command prompt by pressing window + R and change directory to the location in which MongoDB server is saved. Go to MongoDB folder >Server >bin folder and copy the folder address. In my s...
    Sanwar Ranwa Nov 16, 2018
  • Anoop Kumar Sharma

    Working With Databases In MongoDB

    In this article, we will learn about Database in MongoDB. If you are new to MongoDB then I would recommend you to go through the previous article in this series.
    Anoop Kumar Sharma Oct 28, 2018
  • Anoop Kumar Sharma

    Configure A Windows Service For MongoDB

    In this article, we will learn how to configure a Windows Service for MongoDB.
    Anoop Kumar Sharma Oct 22, 2018
  • Sanwar Ranwa

    Retrieve Operation In MonGoDB Using Robo 3T

    In this article, we will learn how to retrievethe data from MongoDB. We will learn from the basics because I have written this Series of articles focusing on the beginners.This article give some ba...
    Sanwar Ranwa Oct 12, 2018
  • Anoop Kumar Sharma

    How To Set Up And Start With MongoDB

    In this article, we will learn How to set up and starts with MongoDB in Windows Operating System.
    Anoop Kumar Sharma Oct 08, 2018
  • Sanwar Ranwa

    Update Operation In MonGoDB Using Robo 3T

    In this article, we will learn how to Update the data from MongoDB Using Robo 3T. We will learn from the basics because I have written this article focusing on the beginners. In my previous article...
    Sanwar Ranwa Oct 05, 2018