Category Archives: SQL

Difference between File System and DBMS

Here you will learn about difference between File System and DBMS in tabular form. File Management System, better known as File System is the most ancient and still the most popular way to keep your data files organised on your drives. On the other hand, when it comes to security and appropriate management of data… Read More »

Category: SQL

Difference between SQL and NoSQL

Here you will learn about difference between sql and nosql or sql vs nosql. Both are a complete different concept, which could be better understood by the following explanation. SQL SQL or the Structured Query Language is a Database language for storing, retrieving and accessing database. SQL stores data in the form of data-tables i.e.… Read More »

Category: SQL

Difference between varchar and varchar2

In this tutorial you will learn about difference between varchar and varchar2. Varchar stands for variable length character string. Both Varchar and Varchar2 are data types to store character strings for particular column (field) in databases. These are reserved by ORACLE. If we relay empty string and NULL being the same, then we should use… Read More »

Category: SQL

SQL Server Tuning for Faster Queries

Your SQL Server Compact is capable of lightening-fast performance and stunningly efficient service even while handling huge work loads. But without regular SQL sever performance tuning, you can’t expect it to “win the race” any more than a race car could without regular tune ups. You will have an opportunity to read in-depth information about… Read More »

Category: SQL

Normalization in DBMS – 1NF, 2NF, 3NF and BCNF

Here you will learn about normalization in dbms with examples. What is Normalization in Database? Most of the projects and websites contain lot of information. They store the data in tables. Since lot of data therefire database contains so many tables. In order to retrieve some information we must go through number of tables which… Read More »

Category: SQL

Difference between DBMS and RDBMS

In this tutorial you will learn about difference between dbms and rdbms with example. DBMS DBMS stands for Data Base Management System. This system is a computer software component introduced during 1960’s. It is a software that is used to store any type of data and it should provide easy manipulation of the data such… Read More »

Category: SQL

Difference between SQL and PL/SQL

Here you will learn about difference between SQL and PL/SQL. SQL and PL/SQL are two popular database technologies. These two topics are very frequently asked in database interviews. In this article I have shared the key differences between these two technologies. Also Read: PL/SQL Interview Questions and Answers Image Source Difference between SQL and PL/SQL S.… Read More »

How to Backup or Restore MySql Database Using SQLyog

This tutorial will guide you how to backup or restore mysql database using sqlyog. It is really important to create regular backups of database on which you are working. It will keep the database safe from any kind of loss. In case any loss occurs, you can restore the database by its backup. Database backup… Read More »

Category: SQL