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.

Articles

  • String Functions in MySQL

    In this article, learn how to use MySQL string functions.
  • How to Handle Null Values in MYSQL Server

    Here we will learn how to handle null values and null values functions in MySQL.
  • Types Of Database Management Systems

    There are multiple types of database management systems such as relational database management system, object databases, graph databases, network databases, and document db. In this article, we discuss the types of Database Management Systems or DBMS.
  • 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 manipulate the data in the database.
  • What Is The Most Popular Database In The World

    Do you wonder which database is the most popular database in the world? This article lists world’s most popular databases and their rankings.
  • 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 configuration. What used to be in the hands of only the biggest in Silicon Valley is now available as a mature database to the masses.
  • 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 effort to carry out their job functions to the best of their capabilities, they may appear to be control freaks.
  • 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 BSON, we can make remote procedure calls in MongoDB. In MongoDB, each data type has an alias as well as a number which can be used for finding or searching the record in MongoDB.
  • 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 upgrades. MongoDB Atlas is a PaaS (Platform as a Service) offering that can be hosted on Amazon AWS, Google Cloud Platform, or Microsoft Azure. In this article I will be demonstrating the steps needed to create your first MongoDB Atlas cluster using the Microsoft Azure service, and add JSON documents manually using the Atlas portal.
  • 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.
  • Configure A Windows Service For MongoDB

    In this article, we will learn how to configure a Windows Service for MongoDB.
  • 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 basic understanding how we retrieve Data from Database and Display it in our Application.
  • 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.
  • 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, we learned the Insert and Delete operations in MongoDB.
  • Normalization In Databases

    Sometimes the database design that looks Ok at first sight may have some hidden problems. One such kind of problem is Non-Atomic Values. This means that the value that stored in a single column in the database is actually a combination of multiple values which makes the database harder to work with because you’ll always need expressions to extract the individual value. And it comes with major impact in performance as well.
  • Delete Operation In MonGoDB Using Robo 3T

    In this article, we will learn how to delete 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, we learned the Insert operations in MongoDB.
  • Insert Operation In MongoDB Using Robo3T

    In this article, we will learn how to insert data in MongoDB using Robo 3T. We will learn from basics because I have written this article focusing on the beginners. We will also learn how we can setup MongoDB environment, with an example using console application.
  • Getting Started With SQLite

    Getting Started With SQLite. SQLite is a lightweight local database and it's become the industry standard for mobile apps. Learn SQLite, SQLite tutorial.
  • Extended Security Updates No More Freebies

    As data professionals, we should always strive to keep our systems updated and patched to ensure proper security of our environments. Microsoft has moved away from releasing service packs to releasing just cumulative updates and the occasional hotfixes. These hotfixes may or may not be security related, but it behooves us to ensure things get patched. Not just from a SQL Server perspective but also from a Windows perspective.
  • MongoDB - Day 1 (Introduction To MongoDB)

    This article provides an introduction to MongoDB. MongoDB is a document-based open-source database. MongoDB is a leading NoSQL database.
  • View More