In the continuation of the last blog Back-End Stack (Guide to become Full Stack Developer). In this, we are covering the area of Databases, Types of Databases, Role of a DBA and pathway to become DBA.
So first of all, What the heck is this Database?
In a laymen term, a database is a collection of information that is organized so that it can be easily accessed, managed and updated. Or, a database can be considered as a collection of data where it is organized into indexed rows, columns, and tables to make it easier to find relevant information. Data gets updated, expanded and deleted as new information is added. Databases process workloads to create and update themselves, querying the data they contain and running applications against it.
Well, there are tons of types of databases nowadays. Many companies develop their own databases to adapt them to their needs. But let’s get to it. There are mainly two categories of database
The Relational Databases is the first kind of database, where data is stored on the disk in table-like schemes. This kind of database is pretty good to store business data. Here is where MySQL, Postgres, SQL Server came into action.
Then there are NoSQL databases. This kind of database covers a wide amount of technologies where you can find key-value databases, document databases, graph databases, streaming databases and so on. The only thing in common that they have is not following the relational scheme. Here you would find databases like MongoDB, Cassandra, Neo4j among these MongoDB is the topmost in NoSQL Database and Cassandra is one of the databases used in Facebook Data Management.
There’s a new kind of database that come into action in recent days i.e., NewSQL. The NewSQL databases are a kind of databases that follow a relational scheme but they work on memory instead of the disk so they outperform the traditional relational databases. However, they are limited by the memory and that’s where they lose against the traditional relational databases. Here you can find databases like VoltDB, MemSQL.
The database administrator — or simply DBA — is a critically important role in many of today’s IT departments, and by extension, their organizations overall. The DBA is the person who manages, backs up and ensures the availability of the mountains of data produced and consumed by today’s organizations via their IT systems. Database administrators develop, install, test, troubleshoot and safeguard the massive data systems inside corporations that store information. Database developers work on commercial or e-commerce websites. They develop and secure the network structures that store and return information based on Internet queries.
So, the question that arises now is, How to become a DBA? or From where should I begin?
All of the above are the major steps which on the pathway to become DBA, rest depends on various case studies and working experience on the Database, as each new problem statement have a new kind of database design as well as Database Architecture and Technology Stack.