Here you will get detailed information about joins in SQL. Join is a very basic concept in SQL which can be confusing at times. The joins are used when we need to find out the solution to a query involving the attributes of more than one table which have at least one attribute in common.… Read More »
A “key” is one of the most basic and important concepts of the Database Management System (DBMS); the keys helps us work easily with the records and the tables in our database by providing us with the ease of accessing and retrieving the data from the table. A primary key is the first key to… Read More »
Here you will get to know about difference between mysql and oracle database. Both MySQL and Oracle are popular relational database management software developed by Oracle Corporation. MySQL: Its name is combination of words “My” and “SQL”, where “My” is name of daughter of co-founder Michael Widenius. And SQL full form is Structured Query Language.… Read More »
In this article you will know about advantages and disadvantages of DBMS. Database management system is an efficient way to create, manage and update databases and also is a prolific replacement of the old file systems which were earlier used to store and retrieve records. The DBMS facilitates the users to work with large amount… Read More »
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 »
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 »
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 »
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 »