Getting started with Elasticsearch

Nowadays searching on the web server is widely increasing day by day and data is getting huge in the server. A relational database server having petabytes of data can take a lot of time...

Database Testing and its Acid Properties

A database is a collection of multiple and unique format data. In addition, a database is a collection of files, report, data structure, tables, queries, views and other elements. DBMS vs RDBMS DBMS stands for Database...

How to connect SQL Server and Advanced features

Microsoft SQL Server SQL stands for Structured Query Language which is used for storing, manipulating and retrieving data in database storage. SQL launched its extended version SQL: 2016 in December. How to connect database using SSMS We...

How to use Function and stored procedure in sql

What is stored procedure? A stored procedure is a compiled query which stores in the database. In other words, we can say it is a database object which stores in the database. Create Procedure For Select: create...
How to understand Sql basics query

Understanding Sql basics queries

In this blog, I am trying to incorporate all the SQL queries with the instance that typically you may not get simply along and that I will attempt to make a case for terribly...
How-to-Use-Index-in-SQL

How to Use Index in SQL?

Indexes are used by queries to find data from the table quickly. It can be created on table and views. An Index in SQL server is very similar to indexes in books. Indexes are commonly...
Microsoft SQL Server vs Oracle: A Comparison of Popular RDBMS

Microsoft SQL Server vs Oracle: A Comparison of Popular RDBMS

There are many different relational database management systems (RDBMS). You have probably heard about Microsoft Access, Oracle, Sybase and MySQL, but the two most popular and widely used are Oracle and SQL Server! In this...
How to make Improvements in MongoDB with Aggregation, Array & Topologies

How to make Improvements in MongoDB with Aggregation, Array & Topologies?

In this blog, we'll look at how to make improvements in MongoDB with Aggregation, Array and Topologies. With MongoDB 3.6 out, and us having discussed security, exchanges, and sessions, we would now be able...
How To Achieve Business Intelligence Using Data Warehousing

How To Achieve Business Intelligence Using Data Warehousing?

Business Intelligence is the activity which contributes to the growth of any company. BI is the act of transforming raw/operational data into useful information for business analysis. How Does Business Intelligence Work? There is a certain...
How to test data processed through ETL

How to test data processed through ETL?

In this blog, we are going to learn about the ETL, which is a process to load data into the database. Data, which is the most basic term of today's Internet world is actually...

TRENDING RIGHT NOW

Author

Prashant is a professional analyst who works with corporate worlds to improve quality of analysis. He believes in dignity and integrity for works related environment. He knows about quality of data and database. He has awarded for 'Inspiring Team', Platinum awarded for 'most promising person of the team', and 'Best employee of the team'. He truly believes in 'Hard work'.