In this article we look into the difference between Primary Key and Unique Key Constraints. We will see the description of both along with how to define a schema and create attributes in a table with these constraints. Primary Key A Primary Key is a key attribute or a column which is used to uniquely …
In this article we look into the difference between CLOB and BLOB datatypes in Oracle/MYSQL. We will also see about the description of each datatype and how to create attributes in a table with these datatypes. So, CLOB and BLOB are types of Large Object Datatypes (LOB). LOB’s are a set of datatypes used to …
Difference between CLOB and BLOB Datatypes in ORACLE/MYSQL Read More »
In this article, we look into the difference between DELETE, DROP and TRUNCATE commands in SQL. We will also see the general syntax related to each of the commands and the corresponding queries to implement these commands in SQL. DELETE The SQL DELETE command is used to delete existing records or rows from a table. …
Difference between DELETE, DROP and TRUNCATE in SQL Read More »
A web developer is a person who’s responsible for a visual appeal of a website and performs tasks related to the website’s layout, development of web applications, and integration of graphics. A web developer is also a person who writes programs that are important for the design of a website using computer languages such as …
Why Do You Need to Listen to Your Developer When Choosing Web Hosting? Read More »
Metadata in DBMS is the data (details/schema) of any other data. It can also be defined as data about data. The word ‘Meta’ is the prefix that is generally the technical term for self-referential. In other words, we can say that Metadata is the summarized data for the contextual data. For example, consider the index …
In this article, you will learn about difference between MongoDB and SQLite. MongoDB MongoDB first version was released in 2009. It is the most reliable database used with Node.JS application. Its structure of saving the data is different because it stores data in a document which is like JSON. It uses the most popular document …
MongoDB vs SQLite – Difference between MongoDB and SQLite Read More »
Here you will learn about joining three tables in sql with example. Let us consider three tables Employee, Department and Project. We will see the complete example wherein these 3 tables are joined to produce a result: Table Employee This table records the Id of the Employee which is the primary key, the name of …
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. …
Joins in SQL – Inner, Outer, Left and Right Join Read More »
