Databases

Replication and Sharding in MongoDB

There are two replication models used in NoSQL databases, master-slave and master-master. In master-slave replication, all write operations are performed on master copy and then propagated to slave copies while in master-master write operations can be done on both master copies, but read operations are not guaranteed to be consistent

Databases

What is Database Administration

Databases are integral part of any Information Technology (IT) system, with advancement in technology these IT systems are getting more and more involved in people everyday life. IT is involved in every aspect of life such as food such as online food delivery, travel online booking, hospitals system, social media

Databases

A complete database example using SQL Server

In this article we are going to create a hypothetical company database system with end-to-end workflow. We are going to start with Entity Relationship Diagram (ERD), then we will create database using SQL script and finally run some queries to test workflow. You need MS SQL Server & Management Studio

Databases

Types of Database Programming

Embedding SQLThe first technique of database programming is embedding SQL commands into code written in any programming language. In this technique programmer write code in with some commonly agreed prefix “EXEC SQL” is one of the examples used by programs to identify embedded SQL code, which is then extracted by

Databases

SQL Basics

Structure Query Language (SQL) is programming language used to query relational databases. This article is going to cover some basic contracts in SQL, which would help you in career path to SQL developer using relational databases such as SQL server or any other database management systems (DBMS). Nested Queries Nested